How to Log Shopify Orders to Google Sheets with Zapier

Dashboard > Create Zap

Create New Zap

Start a fresh Zap to connect Shopify orders to Google Sheets. This sets up the automation framework.

1. 1Click 'Create Zap' from your Zapier dashboard
2. 2Name it 'Shopify Orders to Sheets'
3. 3Leave it in draft mode for now

Trigger > App & Event

Set Shopify Trigger

Configure the New Order trigger to catch every order immediately when placed. This fires within 60 seconds of order completion.

1. 1Click 'Choose App & Event' in Step 1
2. 2Search and select 'Shopify'
3. 3Choose 'New Order' as the trigger event
4. 4Click 'Continue'

Trigger > Account

Connect Shopify Account

Link your Shopify store to allow Zapier to monitor new orders. You'll authenticate through Shopify's admin panel.

1. 1Click 'Sign in to Shopify'
2. 2Enter your shop name (yourstore.myshopify.com)
3. 3Click 'Install app' in the Shopify admin popup
4. 4Return to Zapier when redirected

Trigger > Set up trigger

Configure Trigger Settings

Set which order types to capture and any filters needed. Most setups capture all paid orders regardless of fulfillment status.

1. 1Leave 'Financial Status' as 'Any' to catch all orders
2. 2Set 'Fulfillment Status' to 'Any'
3. 3Click 'Continue'

Trigger > Test

Test Shopify Trigger

Pull a recent order to verify the connection works and see what data is available. This becomes your sample data for mapping.

1. 1Click 'Test trigger'
2. 2Select a recent order from the dropdown
3. 3Click 'Continue with selected record'

Action > App & Event

Add Google Sheets Action

Set up the action that writes order data to your spreadsheet. Each new order creates one new row.

1. 1Click the + button below the trigger
2. 2Search and select 'Google Sheets'
3. 3Choose 'Create Spreadsheet Row' action
4. 4Click 'Continue'

Action > Account

Connect Google Account

Authenticate with Google to grant Zapier write access to your sheets. This uses OAuth for secure connection.

1. 1Click 'Sign in to Google Sheets'
2. 2Choose your Google account
3. 3Click 'Allow' for Zapier permissions
4. 4Return to Zapier

Action > Set up action

Select Target Spreadsheet

Choose which Google Sheet and worksheet will receive the order data. Create the sheet first if it doesn't exist.

1. 1Select your spreadsheet from the 'Spreadsheet' dropdown
2. 2Choose the specific worksheet (usually 'Sheet1')
3. 3Click 'Continue'

Action > Set up action > Field mapping

Map Order Fields

Connect Shopify order data to specific columns in your sheet. This determines what information gets logged for each order.

1. 1Map 'Order Number' to Column A
2. 2Map 'Customer Name' to Column B
3. 3Map 'Email' to Column C
4. 4Map 'Total Price' to Column D
5. 5Map 'Line Items Name' to Column E

Action > Test

Test Google Sheets Action

Send your sample order to the sheet to verify the mapping works correctly. Check that all data appears as expected.

1. 1Click 'Test step'
2. 2Wait for the success message
3. 3Open your Google Sheet in a new tab
4. 4Verify the new row contains correct order data

Zap Editor > Publish

Turn On Zap

Activate the automation to start logging all future orders. The Zap runs automatically from this point forward.

1. 1Click 'Publish Zap' in the top right
2. 2Confirm by clicking 'Turn on Zap'
3. 3Check that status shows as 'On'

Zap > Task History

Verify Live Orders

Place a test order or wait for a real customer order to confirm the automation works end-to-end in production.

1. 1Place a small test order in your Shopify store
2. 2Wait 2-3 minutes for processing
3. 3Check your Google Sheet for the new row
4. 4Review Zap history for successful runs

Drop this into a Zapier Code step.

Add this filter after the Shopify trigger to avoid logging test orders:
{{email}} does not contain "test"
AND

Add this filter after the Shopify trigger to avoid logging test orders:

{{email}} does not contain "test"
AND
{{total_price}} > 0
AND
{{financial_status}} equals "paid"