E-commerceFREE

Automatically Send Every WooCommerce Order to Google Sheets in Real Time

Every time a new WooCommerce order comes in, n8n instantly captures the details and append it as a new row to a spreadsheet — no manual exports, no missed data, no code.

difficulty Beginnersetup 20 minresult A hands-off pipeline where every new WooCommerce order is automatically append it as a new row to a spreadsheet in Google Sheets.—
—
  1. 1

    Add the WooCommerce Trigger node

    Start with a WooCommerce Trigger node — connect your WooCommerce store (URL + consumer key/secret) and set Event to order.created. This fires the workflow the moment a new order arrives.

  2. 2

    Map the fields with a Set node

    Add a Set node after the trigger to shape the data cleanly. Create fields: order_id to {{ $json.id }}, email to {{ $json.billing.email }}, total to {{ $json.total }}, and status to {{ $json.status }}. This turns the raw payload into tidy values your destination can use.

  3. 3

    Send it to Google Sheets

    Add a Google Sheets node set to operation Append Row. Connect your Google account, choose the Spreadsheet and Sheet (e.g. a Log tab), and map each field from the Set node to a matching column. Make sure row 1 of your sheet has headers with the same names.

  4. 4

    Activate and test

    Click Activate in the top-right of the canvas. Trigger a test order in WooCommerce, then confirm it appears in Google Sheets. Once it works, you're done — every new order now flows through automatically.

Frequently asked questions

Do I need any coding skills to set this up?

No. n8n is a visual, drag-and-drop tool. You connect your WooCommerce and Google Sheets accounts, point the nodes at the right form/sheet/channel, map the fields, and activate. No code required.

What happens if my n8n workflow is off when a order comes in?

It depends on the source. Services like Stripe, Shopify and HubSpot retry webhook deliveries for a period, so events are processed once the workflow is back on. For the most reliable capture, run this on n8n Cloud (always online) or keep your self-hosted instance up.

Can I send each order to more than one place at once?

Absolutely. Branch the workflow after the Set node: connect it to multiple destination nodes so the same order lands in Google Sheets and, say, Slack or a spreadsheet simultaneously.

Related recipes
E-commerceFREE
ShopifyTelegramn8n
agent ready—

Log Every Shopify Order to Telegram Automatically

This n8n workflow watches Shopify for a new order and automatically send a Telegram message. Set it once and it runs 24/7.

n8nn8nShopifyShopifyTelegramTelegram
Beginner · 25 min setup
E-commerceFREE
ShopifyNotionn8n
agent ready—

Automatically Send Every Shopify Order to Notion in Real Time

Connect Shopify and Notion in n8n: each new order is captured and sent straight to Notion, in real time and completely hands-off.

n8nn8nShopifyShopifyNotionNotion
Beginner · 30 min setup
E-commerceFREE
ShopifyHubSpotn8n
agent ready—

Automatically Send Every Shopify Order to HubSpot in Real Time

This n8n workflow watches Shopify for a new order and automatically create or update a HubSpot contact. Set it once and it runs 24/7.

n8nn8nShopifyShopifyHubSpotHubSpot
Beginner · 25 min setup
Explore more like this
All E-commerce recipes →n8n WooCommerce automationsn8n Google Sheets automations
About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.