Send Etsy Orders to Google Sheets

When an order (called a "receipt" in Etsy's system) is created on your Etsy shop, this trigger activates the workflow and captures complete receipt data including {{etsy.receipt_id}}, {{etsy.name}} (customer name), {{etsy.total_price.amount}}, {{etsy.formatted_address}}, and {{etsy.transactions[]}} which contains all purchased items with their details. Configuration: You must provide your Etsy Shop ID during setup. To find your Shop ID, log into Etsy, go to Shop Manager, click on Settings, and look at your Shop Info—the Shop ID is displayed there or visible in the URL when viewing your shop settings (a numeric value).

This loop step iterates through each transaction in the {{etsy.transactions[]}} array. For every product, the loop executes the spreadsheet row creation step using {{loop.title}}, {{loop.product_id}}, {{loop.quantity}}, and {{loop.price.amount}}. This granular approach creates one row per product, which is essential for fulfillment workflows where individual items need tracking and for accurate inventory management.

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 Receipt ID, Customer Name, Total Price, Shipping Address, Product Title, Product ID, Product Quantity, Product Price, and Store Manager Link. The workflow maps Etsy data to spreadsheet columns: {{etsy.receipt_id}} to Receipt ID, {{etsy.name}} to Customer Name (recipient name from shipping address), {{etsy.total_price.amount}} to Total Price, {{etsy.formatted_address}} to Shipping Address (complete formatted address), {{loop.title}} to Product Title, {{loop.product_id}} to Product ID, {{loop.quantity}} to Product Quantity, {{loop.price.amount}} to Product Price, and a constructed URL "https://www.etsy.com/your/orders/sold/new?order_id={{etsy.receipt_id}}" to Store Manager Link for one-click access to the order in Etsy. The on_error setting is "replay," meaning if the spreadsheet write fails temporarily, the workflow will automatically retry to ensure no orders are lost.