Log E-commerce Orders in Google Sheets with Monthly Tabs & Status Tracking

This n8n workflow captures incoming e-commerce orders via webhook from platforms like Shopify and logs them into a Google Sheet. It automatically generates or appends to monthly tabs (e.g., 'September 2025') and adds a 'Status' column with predefined dropdown options: Not Shipped, Pickup Scheduled, Shipped, InTransit, Delivered, Cancelled. This enables teams to track order fulfillment at a glance without manual data entry.

The workflow starts with a webhook trigger for order events (creation, update, fulfillment). It sets the target spreadsheet ID, retrieves existing sheet metadata, generates the current month's sheet name using date formatting, and uses conditional logic to either create a new tab or append rows to an existing one. Data validation ensures consistent status updates, and the setup supports edit access via Google credentials.

Ideal for e-commerce operations, it centralizes order logs across months, facilitates team coordination for shipping, and integrates with triggers for customer notifications (e.g., WhatsApp/Email on status changes). Benefits include time savings on manual logging, scalable inventory management, and lightweight dashboards for ops monitoring. Perfect for gaming/lifestyle stores handling seasonal order spikes.

Setup requires updating the webhook URL in Shopify notifications and ensuring Google Sheets access. Refer to Shopify's webhook guide for order events.