How to Create Daily Sales Reports from Shopify in Google Sheets with N8n

Dashboard > New workflow

Create new N8n workflow

Start a fresh workflow for your daily sales summary automation. You'll build a scheduled workflow that runs once per day at a specific time.

1. 1Click 'New workflow' from the N8n dashboard
2. 2Click the default 'Start' node to delete it
3. 3Drag the 'Schedule Trigger' node from the left panel onto the canvas

Schedule Trigger > Parameters

Configure daily schedule trigger

Set the trigger to fire once per day after business hours when all orders are finalized. This ensures you capture the complete day's sales data.

1. 1Double-click the Schedule Trigger node
2. 2Set 'Trigger Interval' to 'Days'
3. 3Set 'Days Between Triggers' to 1
4. 4Set 'Trigger at Hour' to 23 (11 PM)
5. 5Set 'Trigger at Minute' to 30

Nodes > Shopify > Order > Get All

Add Shopify node for orders

Connect to Shopify to pull yesterday's orders. You'll filter by date to get only the previous day's completed orders.

1. 1Click the '+' button on the Schedule Trigger node
2. 2Search for 'Shopify' and select it
3. 3Choose 'Order' as the resource
4. 4Select 'Get All' as the operation

Shopify node > Credentials > Create New

Configure Shopify credentials

Connect N8n to your Shopify store using a private app API key. This gives the workflow permission to read order data.

1. 1Click 'Create New' next to Credentials
2. 2Enter your Shopify store URL (yourstore.myshopify.com)
3. 3Paste your Admin API access token
4. 4Click 'Save' and then 'Test' to verify connection

Shopify node > Additional Fields

Filter orders by yesterday's date

Add date filters to only grab orders from the previous day. This prevents pulling your entire order history every time the workflow runs.

1. 1Scroll to 'Additional Fields' in the Shopify node
2. 2Click 'Add Field' and select 'Created At Min'
3. 3Set value to {{$now.minus({days: 1}).startOf('day').toISO()}}
4. 4Add 'Created At Max' field
5. 5Set value to {{$now.minus({days: 1}).endOf('day').toISO()}}

Nodes > Function

Add Function node for calculations

Create a JavaScript function to calculate your three key metrics from the order data. This node will process all orders and output summary statistics.

1. 1Click '+' on the Shopify node
2. 2Search for 'Function' and select it
3. 3Replace the default code with calculation logic
4. 4Add variables for totalRevenue, orderCount, and averageOrderValue

Function node > Code Editor

Write calculation JavaScript code

Add the specific code to sum revenue, count orders, and calculate averages. This handles the math for your daily summary metrics.

1. 1Clear the existing code in the Function node
2. 2Paste the sales calculation JavaScript
3. 3Verify the code references correct Shopify field names
4. 4Click 'Test step' to validate the calculation logic

Drop this into an n8n Code node.

const orders = $input.all()[0].json;
const validOrders = orders.filter(o => o.financial_status === 'paid' && !o.test);
const totalRevenue = validOrders.reduce((sum, o) => sum + parseFloat(o.total_price || 0), 0);

const orders = $input.all()[0].json;
const validOrders = orders.filter(o => o.financial_status === 'paid' && !o.test);
const totalRevenue = validOrders.reduce((sum, o) => sum + parseFloat(o.total_price || 0), 0);
return [{
  reportDate: $now.minus({days: 1}).toISODate(),
  totalRevenue: Math.round(totalRevenue * 100) / 100,
  orderCount: validOrders.length,
  averageOrderValue: validOrders.length > 0 ? Math.round((totalRevenue / validOrders.length) * 100) / 100 : 0
}];

Nodes > Google Sheets > Append

Add Google Sheets node

Connect to your tracking spreadsheet to append the daily summary. You'll write a new row with yesterday's date and calculated metrics.

1. 1Click '+' on the Function node
2. 2Search for 'Google Sheets' and select it
3. 3Choose 'Append' as the operation
4. 4Select your existing sales tracking spreadsheet

Google Sheets node > Credentials > OAuth2

Configure Google Sheets credentials

Authenticate with Google to allow N8n to write to your spreadsheet. Use OAuth for the most reliable connection.

1. 1Click 'Create New' next to Credentials
2. 2Choose 'OAuth2' authentication method
3. 3Click 'Sign in with Google'
4. 4Grant permissions to access Google Sheets
5. 5Test the connection

Google Sheets node > Column Mapping

Map calculation results to sheet columns

Tell N8n which calculated values go in which spreadsheet columns. Map your Function node outputs to the correct column headers.

1. 1Select your target spreadsheet and worksheet
2. 2Choose 'Define Below' for column mapping
3. 3Map 'Date' to {{$now.minus({days: 1}).toISODate()}}
4. 4Map 'Revenue' to the totalRevenue from Function node
5. 5Map 'Orders' to orderCount and 'AOV' to averageOrderValue

Workflow > Test workflow

Test the complete workflow

Run the entire automation to verify it pulls orders, calculates correctly, and writes to your sheet. This catches any connection or logic issues.

1. 1Click 'Test workflow' in the top toolbar
2. 2Watch each node execute and show green checkmarks
3. 3Check your Google Sheet for the new row
4. 4Verify the calculated numbers match your Shopify admin

Workflow > Active toggle

Activate the workflow

Turn on the automation so it runs automatically every day at your scheduled time. Your daily sales summary will now generate without manual work.

1. 1Click 'Save' to store your workflow
2. 2Toggle the 'Active' switch in the top right
3. 3Confirm the workflow shows 'Active' status
4. 4Note the next scheduled execution time