n8n Google Sheets Monthly Order Logger
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. An n8n automation workflow template by Ruthwik.
Ruthwik
web
free
Others in the same category, ranked by how often they are opened.
