# Send Avis Product Options to Google Sheets 5 min setup No coding required Runs automatically Send Avis product options data directly to Google Sheets whenever customers place orders. Track custom selections, add-ons, and personalization choices in organized spreadsheets. Spot order trends, see which options are most popular, and keep your team in the loop on customer preferences — all without manual data entry. Leave the template as-is to capture all orders containing any line item properties, or filter for specific line item properties in the trigger if you only want the workflow to run for certain options. Order Created Loop Add Row ## How it works 4 steps to start capturing product option data in Google Sheets for every new order ### Order Created - **App connector:** [Avis Product Options](/content/apps/avis-product-options/integrate "View Avis Product Options integration page"/index.html)• **Time to complete:** 0 minutes (Auto-configured) **Why this matters:** This step monitors your store for new orders containing Avis product options and kicks off the entire workflow when customers complete purchases. 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. ### Retrieve Shop - **App connector:** [Shopify](/content/apps/shopify/integrate "View Shopify integration page"/index.html)• **Time to complete:** 0 minutes (Auto-configured) **Why this matters:** This step pulls your shop's domain information needed to create direct links to orders in your Shopify admin. 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. ### Loop - **App connector:** [Loop](/content/apps/loop/integrate "View Loop integration page"/index.html)• **Time to complete:** 0 minutes (Auto-configured) **Why this matters:** This step processes each product in the order individually, ensuring multi-item orders create separate spreadsheet rows for each product. 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. ### Add Row - **App connector:** [Google Sheets](/content/apps/googlesheets/integrate "View Google Sheets integration page"/index.html)• **Time to complete:** 2 minutes **Why this matters:** This step creates the actual spreadsheet entries with your selected order and product data organized in columns. 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. ## Frequently asked questions ### Will this create a separate row for each product in multi-item orders? Yes, the Loop step processes each line item individually, so if someone orders 3 different products with Avis options in one order, you'll get 3 separate rows in your spreadsheet - one for each product with its own customization details and pricing. ### Can I add more order fields that aren't in the default options? The template includes the most commonly needed fields, but you can customize the Add Row step to include additional order data like tags, fulfillment status, or custom order attributes by modifying the column configuration. ### What happens if I change the spreadsheet name after the workflow is running? The workflow will create a new spreadsheet with the updated name for future orders. Existing data will remain in the original spreadsheet, so you'll need to manually merge the data if you want everything in one sheet. ## Make this template your own! Customize this workflow even further: - Set custom filters - Connect to email notifications - Store additional metrics - Deploy data transformations