Log Infinite Options Orders to Google Sheets Automatically

Export Shopify Product Options to Google Sheets

5 min setup
No coding required
Runs automatically

Keeping up with custom orders means tracking a lot of moving parts — what was selected, who ordered it, and where it's going. When that happens manually, things slip through. This workflow sends every Infinite Options order straight to Google Sheets the moment it's placed, creating one row per line item with all the product, option, and shipping details you need to stay on top of production and fulfillment without the copy-paste.

How it works

4 steps to start logging every Infinite Options order — line item by line item — directly into Google Sheets

New Infinite Options Order

App connector: [Infinite Options](/content/apps/infiniteoptions/integrate "View Infinite Options integration page"/index.html) • Time to complete: 0 minutes (Auto-configured)

Why this matters: This is what starts the workflow. Without this trigger, nothing runs — every other step depends on a new order coming in with Infinite Options data attached.

When a customer places an order on your store, Infinite Options captures all the product option details selected at checkout (think engraving text, gift wrap preferences, custom colors). This trigger fires the moment that order is created and passes all of that order data — including line items and their associated options — to the steps that follow. No configuration is needed here; it connects automatically to your Infinite Options account.

Retrieve Shop

App connector: [Shopify](/content/apps/shopify/integrate "View Shopify integration page"/index.html) • Time to complete: 0 minutes (Auto-configured)

Why this matters: This step fetches your Shopify store's domain so the workflow can build accurate, clickable links to each order in your spreadsheet. Without it, the Order URL column won't work.

This step pulls your store's base URL from Shopify automatically. It runs silently in the background and hands that domain information to the Add Row step so each spreadsheet row can include a direct link back to the order in your Shopify admin. No configuration is needed.

Loop Through Line Items

App connector: [Loop](/content/apps/loop/integrate "View Loop integration page"/index.html) • Time to complete: 0 minutes (Auto-configured)

Why this matters: Orders often contain multiple products — this step makes sure each one gets its own dedicated row in your spreadsheet instead of cramming everything into a single entry.

The Loop step iterates over every line item in the order, processing each product one at a time. So if a customer orders three items, this step runs three times — once per item — passing that individual product's data (name, SKU, price, options) into the Add Row step. This is what makes your spreadsheet granular and useful for production, fulfillment, or reporting. No configuration is needed.

Add Line Item to Google Sheets

App connector: [Google Sheets](/content/apps/googlesheets/integrate "View Google Sheets integration page"/index.html) • Time to complete: 2 minutes

Why this matters: This is where the data lands. Each loop iteration writes one row to your spreadsheet — this step is the bridge between your Infinite Options orders and the organized Google Sheet you'll actually use.

During setup, you'll name your Google Spreadsheet (for example, "Infinite Options Orders 2026") and choose which columns to include. All columns are selected by default — deselect any you don't need. The available columns are: Order URL, Order Name, Email, Shipping Name, Address, City, State/Province, Zip/Postal Code, Country, Product Name, Product SKU, and Product Price. If the spreadsheet doesn't exist yet, MESA creates it automatically the first time the workflow runs.

Frequently asked questions

Can I add custom columns beyond the template options?

Yes, after the initial setup, edit the "Add Row" step in the workflow builder and modify the body.fields object to add additional columns mapped to any Infinite Options or Shopify data variables available in the workflow context.

What happens if I change the columns after orders have been logged?

Adding new columns will leave existing rows' cells blank for those columns. Removing columns from the workflow won't delete existing data—those columns will simply stop receiving new data. For major restructuring, consider creating a new spreadsheet and updating the spreadsheet_id in the workflow.

Will this capture all custom option types from Infinite Options?

Yes, the trigger includes all_infinite_options_options which captures text inputs, dropdowns, checkboxes, file uploads, and all other Infinite Options field types. The specific custom options for each product will appear in the spreadsheet automatically based on what was configured for that product.

Make this template your own!

Customize this workflow even further:

You're in good company

Avg. App Store rating
4.9/5
Merchant reviews
157
Avg. time saved per week
3.5 hrs

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

Ready to start logging every Infinite Options order — line item by line item — directly into Google Sheets?

7-day free trial • 5 min setup • Cancel anytime

[Start with this template — It's free](/content/pricing?template=infiniteoptions%2Forder%2Fadd_line_items_to_google_sheet&templateName=export-shopify-product-options-to-google-sheets "Install and use this template in MESA - Free to use"/index.html)