Stop copying Etsy orders by hand: a 10-minute automation

If you run an Etsy shop, you already know the evening ritual: open the orders page, copy the buyer, the item, the amount, paste it into a spreadsheet, repeat. It is not hard. It is just every single day. This guide sets up a small automation that does it for you: every new receipt lands as a new row in a Google Sheet within minutes, with the fields you choose.

What you need

An Etsy shop, a Google account, and a free Make account. Make is the automation tool that connects the two; its free plan gives you 1,000 operations a month, which is more than enough for a small shop.

The five steps

1. In Google Sheets, create a sheet called Orders with a header row: Date, Receipt ID, Buyer, Items, Total, Status.
2. In Make, create a new scenario and add the Etsy module Watch shop receipts as the first step. Connect your Etsy account when asked (Make handles the login; you approve it once).
3. Add the Google Sheets module Add a Row. Pick your spreadsheet and the Orders sheet.
4. Map the fields: drag the receipt's date, id, buyer name, item titles and total into the matching columns. Make shows you every field the receipt contains.
5. Set the schedule (every 15 minutes is plenty), turn the scenario on, and place a test order or wait for the next real one.

Useful extras

Add a filter between the two modules so only paid receipts are logged. Add a second Google Sheets module to keep a separate sheet per month. If you want a ping as well, the same scenario can send a Telegram or email message for every new order; see the guide on sale alerts.

What this does not do

Cost

Each new order uses about two operations. On the free plan that is roughly 500 orders a month before you would need a paid plan, and the paid plans start at a few dollars.