Send OPTIS Product Options to Google Sheets

When a customer places an order containing products with OPTIS custom options (like personalization, upgrades, or add-ons), this trigger captures all the order details including customer information, shipping address, and line item specifics. The trigger runs automatically in the background - no configuration needed from you. It passes the complete order data to the next step so your workflow can process each product with its custom options.

The workflow automatically connects to your Shopify store and retrieves essential shop details like your store's domain name. This information gets used to generate clickable admin URLs in your spreadsheet, so you can jump directly from a Google Sheets row to the specific order in your Shopify admin. No setup required - the step uses your existing Shopify connection to gather this data and pass it forward.

The loop takes the order data and breaks it down product by product, creating a separate processing cycle for each line item. If a customer orders 3 different products with custom options, this step will run 3 times - once for each product. It extracts product details like name, SKU, price, and custom option selections for each item. The loop structure ensures your Google Sheets gets one row per product rather than one row per order.

For each product processed by the loop, this step adds a complete row to your Google Sheets with the columns you chose during setup - like order name, customer email, shipping address, product details, and custom options. You'll configure the spreadsheet name and select which data columns to include (order URL, customer email, shipping details, product name, SKU, price, etc.). The step automatically creates the spreadsheet on first run and adds headers based on your selections.