Track Shopify Order Refunds in Google Sheets

This is what starts the workflow. Without it, nothing runs — every refund has to be detected the moment it's issued or the rest of the steps never fire.

Using the order ID from the refund trigger, this step calls the Shopify API to pull the complete order record. That gives the workflow access to customer information (ID, name, email) and order-level data (tags) that get written to your spreadsheet later. This happens automatically using data from the trigger — no manual input required. If this step fails, your row will be missing customer details.

This step iterates over every transaction attached to the refund event. For each transaction, it runs the next step — adding a row to Google Sheets — before moving on to the next one. The loop pulls transaction-level data (like the refund amount) that gets written per row. If a refund has three transactions, you'll get three rows. No configuration needed; the loop is pre-wired to the refund's transaction list.

During setup, you'll name your spreadsheet and choose which columns to include. All available columns are selected by default: Customer ID, Customer Name, Customer Email, Refund Amount, Refund Issue Date, Order Tags, and Refund Notes. Deselect any you don't need. Once saved, MESA creates the spreadsheet in your connected Google Drive and starts populating it automatically from that point forward. The sheet name is set once at setup and doesn't need to change unless you want to start a new tracking file.