How to Log New Shopify Orders to Google Sheets with N8n

Dashboard > New Workflow

Create new N8n workflow

Start with a blank workflow in N8n. This will be your order logging automation that runs every time a new order comes in.

1. 1Click 'New Workflow' from the N8n dashboard
2. 2Click the '+' button to add your first node
3. 3Name your workflow 'Shopify Orders to Sheets'

Node Panel > Shopify Trigger

Add Shopify webhook trigger

Configure N8n to listen for new orders from Shopify. The webhook fires immediately when someone completes checkout.

1. 1Search for 'Shopify Trigger' in the node panel
2. 2Select 'Shopify Trigger' from the results
3. 3Choose 'Order Created' from the Event dropdown
4. 4Click 'Listen for Test Event' to generate webhook URL

Shopify Node > Credentials > Create New

Connect your Shopify store

Link N8n to your Shopify store using API credentials. This gives N8n permission to receive order webhooks.

1. 1Click 'Create New' under Credentials in the Shopify node
2. 2Enter your Shopify store URL (yourstore.myshopify.com)
3. 3Paste your Admin API access token
4. 4Click 'Save' and test the connection

Shopify Admin > Settings > Notifications > Webhooks

Register the webhook with Shopify

Tell Shopify to send order data to N8n's webhook URL. This creates the real-time connection between your store and the automation.

1. 1Copy the webhook URL from the trigger node
2. 2Go to Shopify Admin > Settings > Notifications
3. 3Scroll to 'Webhooks' and click 'Create webhook'
4. 4Select 'Order creation' event and paste the N8n URL
5. 5Set format to JSON and click 'Save webhook'

N8n Workflow > Shopify Trigger Node > Execute

Test with a real order

Place a test order in your Shopify store to verify the webhook delivers order data to N8n correctly.

1. 1Place a $1 test order in your Shopify store
2. 2Return to N8n and check if the trigger node shows data
3. 3Click 'Execute Node' to see the received order payload
4. 4Verify fields like order_number, customer email, and line_items appear

Node Panel > Google Sheets > Append

Add Google Sheets node

Connect the Google Sheets node to write order data to your spreadsheet. This node will create a new row for each order.

1. 1Click '+' after the Shopify trigger to add another node
2. 2Search for 'Google Sheets' and select it
3. 3Choose 'Append' operation to add new rows
4. 4Select your target spreadsheet and worksheet

Google Sheets Node > Credentials > OAuth2

Authenticate Google Sheets

Grant N8n permission to write to your Google Sheets. This uses OAuth to connect securely without storing your Google password.

1. 1Click 'Create New' under Google Sheets credentials
2. 2Click 'Sign in with Google' and authorize N8n
3. 3Select your Google account from the list
4. 4Grant permissions for Google Sheets access

Google Sheets Node > Fields > Add Field

Map order fields to sheet columns

Tell N8n which Shopify order data goes into which spreadsheet columns. This creates the structured order log you want.

1. 1Click 'Add Field' for each column you want to populate
2. 2Map 'order_number' to your Order Number column
3. 3Map 'customer.email' to your Customer Email column
4. 4Map 'total_price' to your Order Total column
5. 5Add 'created_at' for the timestamp

Node Panel > Function > Code Editor

Handle line items data

Shopify sends line items as an array, but Google Sheets needs text. Add a function node to format product details into a readable string.

1. 1Add a 'Function' node between Shopify and Google Sheets
2. 2Use JavaScript to loop through line_items array
3. 3Format as 'Product Name (Qty: X) - $Price'
4. 4Join multiple items with semicolons

Workflow > Execute Workflow

Test the complete workflow

Run the entire automation end-to-end to make sure orders flow from Shopify to Google Sheets correctly.

1. 1Click 'Execute Workflow' to test with existing data
2. 2Check your Google Sheet for the new row
3. 3Verify all fields populated correctly
4. 4Place another test order to confirm real-time operation

Workflow Header > Activate Toggle

Activate the workflow

Turn on the workflow to start logging orders automatically. Once active, every new Shopify order creates a Google Sheets row within seconds.

1. 1Click the toggle switch at the top of the workflow
2. 2Confirm activation in the popup dialog
3. 3Check the status shows 'Active' with a green indicator

Drop this into an n8n Code node.

// Format line items array into readable string
const items = $node["Shopify Trigger"].json["line_items"];
const formatted = items.map(item => 

// Format line items array into readable string
const items = $node["Shopify Trigger"].json["line_items"];
const formatted = items.map(item => 
  `${item.title} (Qty: ${item.quantity}) - $${item.price}`
).join('; ');
return [{formatted_items: formatted}];