Export Shopify Product Options to Google Sheets

When a customer completes an order that includes Infinite Options data (like custom text, uploaded files, or selected variants), this trigger captures all the order details including line items, customer information, and shipping address. The trigger is pre-configured to listen for order creation events and automatically passes the complete order data to the next step. No configuration is needed - it starts working as soon as you activate the workflow.

The workflow automatically retrieves your shop details from Shopify, including your store's domain name which gets used to create clickable links to orders in your admin panel. This step runs in the background and pulls essential store metadata that other steps reference when formatting the spreadsheet data. The shop information gets passed forward so the spreadsheet can include working links to view orders directly in Shopify.

The Loop step takes the line items array from the order and processes each product individually, extracting details like product name, SKU, price, and any custom options selected. If an order contains 3 different products, this step will run 3 times - once for each item. This allows you to analyze product-level data rather than just order-level summaries. Each iteration passes individual line item data to the spreadsheet creation step.

You'll configure which columns to include in your spreadsheet by selecting 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 workflow will create a new Google Spreadsheet with your specified name (enter this in the "What do you want to name your spreadsheet?" field) and populate it with the selected data fields. Each time the loop runs, a new row gets added with that line item's information, building a comprehensive database of your Infinite Options orders.