Send Etsy Orders to Google Sheets

6 min setup
No coding required
Runs automatically

Keeping up with Etsy orders in a spreadsheet means constant copy-pasting — and one missed order can throw off your whole tracking system. This template automatically creates a new Google Sheets row for every product in every order the moment a receipt is created in your shop. Customer details, product titles, prices, quantities, and a direct link to each order in your Store Manager are all captured without lifting a finger.

etsy logo icon
Receipt Created
Loop through line items
google sheets logo icon
Add Row

Trusted by 1,000+ Shopify merchants — from solo operators to scaling brands.

Logo: GLDN Logo: MUD/WTR Logo: Bartesian Logo: Allure Logo: Made In Cookware

How it works

3 steps to start exporting Etsy orders to Google Sheets automatically

etsy logo icon

Receipt Created

App connector: Etsy • Time to complete: 2 minutes
Why this matters: This is the starting point for the entire workflow. Without it, MESA has no way of knowing when a new order comes in — nothing else runs until this step fires.

When a customer completes a purchase on Etsy, a new receipt is created in your shop. This trigger listens for exactly that event and immediately kicks off the workflow. During setup, you'll be prompted to enter your Etsy Shop ID — you can find this in your Etsy Shop Manager under "Settings" > "Info & Appearance." Once connected, every new order will automatically start the workflow without any manual action on your part.

Loop through line items

App connector: Loop • Time to complete: 0 minutes (Auto-configured)
Why this matters: Etsy orders can contain multiple line items — each product a customer bought. This step breaks the order apart so each product gets its own dedicated row in your spreadsheet, keeping your data clean and easy to analyze.

The Loop step processes each transaction inside the order one at a time, cycling through every product purchased. For example, if a customer buys a candle, a card, and a tote bag in a single order, this step runs three times — once per item. This is what enables per-product tracking of titles, quantities, and prices rather than a single blended order row. No configuration is needed here; the loop is pre-wired to the order's transaction data.

google sheets logo icon

Add Row

App connector: Google Sheets • Time to complete: 3 minutes
Why this matters: This is where your data lands. For each product the Loop processes, this step writes a new row to your Google Sheet — turning raw Etsy order data into a structured, searchable log you can actually use.

During setup, you'll name your spreadsheet (e.g., "Etsy Orders 2026") and choose which columns to include. All columns are selected by default, and you can deselect any you don't need:

  • Receipt ID — the unique order identifier
  • Customer Name — recipient name from the shipping address
  • Total Price — sum of all items, excluding tax and shipping
  • Shipping Address — formatted delivery address
  • Product Title — the listing name for that specific item
  • Product ID — the numeric ID for the purchased product
  • Product Quantity — how many units were ordered
  • Product Price — per-unit price of that item
  • Store Manager Link — a direct URL to the order in your Etsy dashboard

If the spreadsheet doesn't exist yet, MESA creates it automatically on the first order. The sheet name defaults to "Sheet1" — you can rename it in Google Sheets after creation.

Ready to start exporting Etsy orders to Google Sheets automatically

Get setup in 6 minutes.

Try this template →

Frequently asked questions

Can I add custom columns beyond the template options?

Yes, after initial setup, edit the "Add Row" step in the workflow builder and modify the body.fields object to add additional columns mapped to any Etsy receipt or transaction data variables available in the workflow context.

What happens if I change columns after orders have been logged?

Adding new columns will leave existing rows' cells blank for those columns. Removing columns from the workflow won't delete existing data—those columns simply stop receiving new data. For major restructuring, consider creating a new spreadsheet.

Will this capture orders from multiple Etsy shops?

This workflow monitors one Etsy Shop ID. To track multiple shops, create separate workflows for each shop (each configured with a different Shop ID), either writing to separate spreadsheets or including a "Shop Name" column to distinguish sources in a shared spreadsheet.

Make this template your own!

Customize this workflow even further:

Add a low-stock alert when popular items sell
Connect a condition step after the Loop that checks whether a product's remaining inventory falls below a threshold you set. If it does, route to a Slack or email notification so you can restock before you sell out — no manual inventory checks needed.
Tag high-value orders for priority fulfillment
After the Add Row step, add a condition that checks the order's total price. If it exceeds an amount you define, trigger a follow-up action — like adding a tag in Etsy, creating a task in Asana, or pinging your team in Slack — so high-value orders get handled first.
Build a running revenue summary with a data table
Alongside the Google Sheets row, write each order's key fields (receipt ID, product price, quantity) to a MESA data table. From there, you can query totals, calculate averages, or power a lightweight dashboard without touching your main spreadsheet.
Send a personalized post-purchase follow-up
After logging the row, add a delay step and then an email action that sends a thank-you message or a review request to the customer a few days after their order ships — turning your order log into a retention touchpoint.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

Ready to start exporting Etsy orders to Google Sheets automatically?

7-day free trial • 6 min setup • Cancel anytime

Need help? Our automation experts will help you personalize this workflow for free. Contact support