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
How it works
- Order created (Webhook/Trigger): Receives a new order payload from your store/stack.
- Config (set spreadsheetId): Stores the target Google Sheets spreadsheetId (copied from the URL).
- Get Order Sheets metadata: Lists existing tabs to see if the tab for the current month already exists.
- Generate Sheet Name: Computes the sheet name like
{{ $now.format('MMMM YYYY') }}.
- If (sheet exists?):
- True → Google Sheets Row values (existing): Prepares the row for append using the month tab.
- Append to Existing Orders Sheet: Appends the order as a new row.
- False → Set Sheet Starting row/col: Sets starting cell (e.g., A1) for a brand-new month tab.
- Create Month Sheet: Creates a new tab named for the current month.
- Write Headers (A1:…): Writes the column headers.
- Google Sheets Row values: Maps payload fields into the header order and applies validation to Status.
- Append to Orders Sheet: Appends the first row into the newly created month tab.
How to use
- In Config , paste your
spreadsheetId from the sheet URL and confirm your Google credential has edit access.
- (Optional) Adjust the month-tab naming format to match your preference.
- In Shopify → Settings → Notifications → Webhooks , add your n8n webhook URL and select the Order events (Order creation, Order update, Order fulfillment, etc.) you want to capture.
- Deploy the workflow and send a sample order to the trigger; a new month tab will be created automatically on the first order of each month.
Requirements
- n8n instance with the Google Sheets node credential configured.
- A Google Spreadsheet you own or can edit.
- A Shopify store with webhook events enabled (see Shopify Webhooks Guide).
Customising this workflow
- Add/remove columns (e.g., taxes, discounts, warehouse notes).
- Change the Status list or add conditional formatting (e.g., green = Delivered).
- Chain automations: on Status update → send tracking links, COD confirmation, or delivery feedback forms.
🚀 Innovate Beyond Boundaries
We help ambitious businesses harness the power of AI + automation for growth, efficiency, and customer delight. Contact us at [email protected]
