Log e-commerce orders in Google Sheets with monthly tabs & status tracking

n8n Google Sheets Monthly Order Logger

This n8n template records incoming e-commerce orders into Google Sheets, auto-creates a monthly sub-sheet, and adds a “Status” dropdown so your team can track fulfillment at a glance.

---

Use cases

Centralize order logs, coordinate shipping across months, trigger customer updates (e.g., WhatsApp/Email) from status changes, and build lightweight ops dashboards.

---

Good to know

- The Google Sheet ID is the part in the URL between /d/ and the next slash: https://docs.google.com/spreadsheets/d/<sheetId>/. - A new sub-sheet is created every month (sheet name = current month, e.g., “September 2025”). If it already exists, the workflow appends to it. - The Status column uses data validation with these options: Not Shipped, Pickup Scheduled, Shipped, InTransit, Delivered, Cancelled. - Make sure the Google credential in n8n has edit access to the spreadsheet. - The Webhook URL must be updated in your Shopify Settings → Notifications → Webhooks page with the required Order events (e.g., Order creation, Order update, Order fulfillment). Reference: [Shopify Webhooks Guide](https://help.shopify.com/en/manual/fulfillment/setup/notifications/webhooks)