Export Uploadery Line Items and Order Details to Google Sheets

When a customer places an order through Uploadery, this trigger automatically captures the complete order information including customer details, shipping address, and all line items purchased. The trigger runs in the background with no configuration needed from you, collecting order data like customer email, shipping information, and product details for each item in the order. This data gets passed to subsequent steps to create individual spreadsheet rows for every product purchased.

The step automatically connects to your Shopify store and retrieves your shop's domain information, which gets used to build clickable admin URLs in your spreadsheet. No configuration is required as it uses your existing Shopify connection to gather the necessary store details. The shop information combines with order IDs from step 1 to create direct links to each order in your Shopify admin panel.

The Loop step takes the line items from each Uploadery order and processes them individually, so if someone buys 3 different products, you'll get 3 separate spreadsheet rows with detailed information for each item. The loop runs automatically for every line item in each order, extracting product-specific details like name, SKU, and price for each item. This ensures your spreadsheet provides granular tracking where each row represents one specific product purchase with its own pricing and details.

You'll configure which data fields to include in your spreadsheet by selecting from options like Order Name, Customer Email, Shipping Address, Product Name, SKU, and Price. The "What do you want to name your spreadsheet?" field lets you specify a custom name for your Google Sheets file (example: "Uploadery Orders 2024"). The system will create column headers based on your selections and populate each row with data from the looped line items, ensuring every product purchase gets its own detailed record in your spreadsheet.