Export Shopify Product Options to Google Sheets

When an order with Infinite Options is created in Shopify, this trigger activates the workflow and captures complete order data including {{infiniteoptions.order.id}}, {{infiniteoptions.order.name}}, {{infiniteoptions.order.email}}, {{infiniteoptions.order.shipping_address}}, and {{infiniteoptions.line_items[]}} which contains all products with their custom options. The workflow runs only for orders that include Infinite Options customizations (not all orders). Setup requirement: You must have Infinite Options installed on your Shopify store for this trigger to receive order data with customization details.

This step retrieves your Shopify store information, specifically {{shopify.myshopify_domain}}, which contains your store's unique domain (like "yourstore.myshopify.com"). This domain is used to build the order URL format "https://admin.shopify.com/store/yourstore/orders/[id]" that provides immediate access to order details from the spreadsheet.

This loop step iterates through each item in the {{infiniteoptions.line_items[]}} array. For every line item, the loop executes the spreadsheet row creation step using {{loop.title}}, {{loop.sku}}, {{loop.price}}, and all custom Infinite Options data associated with that specific product. This granular approach creates one row per product, which is essential for production workflows where each customized item needs individual tracking.

This step adds a new row to your Google Sheets spreadsheet with columns you configured during setup. Configuration: During initial setup, you'll: (1) Name your spreadsheet (it will be created automatically in your Google Drive), and (2) Select which columns to include from options like Order URL, Order Name, Email, Shipping Name, Address, City, State/Province, Zip/Postal Code, Country, Product Name, Product SKU, and Product Price. The template maps Infinite Options data to spreadsheet columns using variables like {{infiniteoptions.order.name}} for order number, {{infiniteoptions.order.email}} for customer email, {{infiniteoptions.order.shipping_address.first_name}} and {{infiniteoptions.order.shipping_address.last_name}} for recipient name, shipping address fields, and {{loop.title}}, {{loop.sku}}, {{loop.price}} for line item details. All custom options (text fields, dropdowns, checkboxes) from Infinite Options are automatically included in additional columns. The on_error setting is "replay," meaning if the spreadsheet write fails temporarily, the workflow will automatically retry.