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.

infinite options icon
Order Created
Retrieve Shop
Map order and line item details to Google Sheets
google sheets logo icon
Add Row

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

How it works

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

infinite options icon

Order Created

App connector: Infinite Options • 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 • 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.

Map order and line item details to Google Sheets

App connector: Loop • 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.

google sheets logo icon

Add Row

App connector: Google Sheets • 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.

Use this free template. Set this up in 5 minutes.

Start automating this task today.

Use this template →

Common 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:

Filter by specific product options
Add a condition inside the loop to only log rows when a particular custom option is present — for example, only capturing orders that include engraving or gift wrapping. This keeps your sheet focused on the work that actually needs manual attention.
Notify your team when an order comes in
Extend the workflow with a Slack or email step inside the loop to alert the right person whenever a line item with a specific option is placed — useful for custom orders that need handoff to a production team right away.
Tag orders in Shopify by option type
After the loop, add a Shopify step that applies a tag to the order based on which custom options were selected. This makes it easy to filter orders in the Shopify admin without ever opening your spreadsheet.
Store option data in a MESA table for reporting
Add a MESA Tables step alongside Google Sheets to build a queryable database of all option selections over time — handy for spotting trends like which custom options are most popular by month or product.

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

Need help? Our automation experts will help you personalize this workflow for free. Contact support