Send Avis Product Options to Google Sheets

When a customer places an order with Avis product options configured, this trigger captures all the order details including customer information, shipping address, and line item data. The trigger runs automatically in the background and requires no configuration from you. It passes the complete order data to the next step so the workflow can process each product separately.

The workflow automatically retrieves your shop details from Shopify to build proper admin URLs for each order. This happens behind the scenes and requires no input from you. The shop information gets combined with order data in later steps to create clickable links in your spreadsheet that take you directly to the order page in your Shopify admin.

The Loop step takes the line items array from the order and processes each product separately. If someone orders 3 different products, this creates 3 iterations that will result in 3 separate rows in your Google Sheet. The loop runs automatically and passes individual product data (title, SKU, price) to the Add Row step for each iteration.

You'll configure which columns to include in your spreadsheet by selecting from options like Order URL, Order Name, Email, Shipping Name, Address details, Product Name, Product SKU, and Product Price. The workflow creates a new Google Spreadsheet with your specified name and adds a row for each product in every order. You can customize the spreadsheet name in the setup and choose which data fields to track based on your reporting needs.