How to Log new orders with Power Automate

My flows > + New flow > Automated cloud flow

Create automated flow

Go to make.powerautomate.com and sign in with your Microsoft account. Click 'My flows' in the left sidebar, then the blue '+ New flow' button at the top. Select 'Automated cloud flow' from the dropdown menu.

1. 1Click '+ New flow' in the top navigation
2. 2Select 'Automated cloud flow'
3. 3Name your flow 'Shopify Orders to Google Sheets'
4. 4Click 'Skip' to choose trigger later

Flow canvas > Choose trigger > Shopify

Add Shopify trigger

Click the trigger box and search for 'Shopify' in the connector search bar. Select the Shopify connector, then choose 'When an order is created' as your trigger event. This fires immediately when customers complete checkout.

1. 1Click 'Choose your flow's trigger'
2. 2Type 'Shopify' in the search box
3. 3Select the Shopify connector
4. 4Choose 'When an order is created' trigger

Shopify trigger > Sign in

Connect Shopify account

Click 'Sign in' and enter your Shopify store URL (like yourstore.myshopify.com) followed by your admin credentials. Power Automate needs admin access to read order webhooks. If you see a permissions screen, click 'Install' to authorize the connection.

1. 1Click 'Sign in to Shopify'
2. 2Enter your store URL ending in .myshopify.com
3. 3Log in with your Shopify admin account
4. 4Click 'Install app' to authorize Power Automate

Flow canvas > + New step > Google Sheets

Add Google Sheets action

Click the '+ New step' button below the Shopify trigger. Search for 'Google Sheets' and select it from the results. Choose 'Insert row' as your action - this adds new rows without overwriting existing data.

1. 1Click '+ New step' below the Shopify trigger
2. 2Search for 'Google Sheets' in the connector list
3. 3Select the Google Sheets connector
4. 4Choose 'Insert row' action

Google Sheets action > Sign in

Connect Google account

Click 'Sign in' and authenticate with the Google account that owns your target spreadsheet. Grant permissions when prompted - Power Automate needs read/write access to modify your sheets. The connection saves for future flows.

1. 1Click 'Sign in to Google Sheets'
2. 2Select your Google account
3. 3Click 'Allow' to grant spreadsheet permissions
4. 4Wait for the green connection confirmation

Google Sheets action > File selection

Select target spreadsheet

Set Location to 'Google Drive', leave Document Library as 'Google Drive', then click the File dropdown to see your spreadsheets. Pick your order tracking sheet or create a new one. Choose the specific worksheet tab where orders should appear.

1. 1Set Location to 'Google Drive'
2. 2Leave Document Library as 'Google Drive'
3. 3Click the File dropdown and select your spreadsheet
4. 4Choose the worksheet tab from the Worksheet dropdown

Google Sheets action > Column mapping

Map order number and date

Click in the first column field and select 'Order number' from the Shopify dynamic content panel. This unique identifier helps track individual orders. In the next column, add 'Created at' for the order timestamp. Power Automate formats dates automatically.

1. 1Click in the first empty column field
2. 2Select 'Order number' from Shopify dynamic content
3. 3Click the second column field
4. 4Add 'Created at' from the dynamic content

Google Sheets action > Customer fields

Map customer information

Add customer data in the next columns by selecting 'Customer: Name' and 'Customer: Email' from the dynamic content. These fields pull from the billing information entered during checkout. If customers don't provide names, the email address becomes the primary identifier.

1. 1Click the third column field
2. 2Select 'Customer: Name' from dynamic content
3. 3Click the fourth column field
4. 4Add 'Customer: Email' from the options

Google Sheets action > Financial data

Add order total and line items

Map 'Total price' to capture the final order value including taxes and shipping. For line items, select 'Line items' from dynamic content - this creates an array of all products ordered. Power Automate automatically formats the product list as readable text.

1. 1Click the fifth column field
2. 2Select 'Total price' from Shopify dynamic content
3. 3Click the sixth column field
4. 4Add 'Line items' to capture all products

Flow canvas > Save > Test

Test the flow

Click 'Save' in the top right, then 'Test' to run a live test. Choose 'Manually' and click 'Test' again. Place a test order in your Shopify store or use an existing recent order. Check your Google Sheet within 2-3 minutes to verify the data appears correctly.

1. 1Click 'Save' in the top toolbar
2. 2Click 'Test' next to the Save button
3. 3Select 'Manually' trigger option
4. 4Place a test order in Shopify
5. 5Check Google Sheets for the new row

Flow header > Turn on

Enable the flow

After successful testing, click 'Turn on' in the flow header to activate automatic processing. The flow runs continuously, processing new orders as they arrive. Monitor the run history for the first few days to catch any authentication or mapping issues.

1. 1Click 'Turn on' in the flow header
2. 2Confirm activation in the popup
3. 3Monitor 'Run history' for successful runs
4. 4Check Google Sheets after real orders

Add this expression in a Compose action to format line items as readable text instead of raw JSON. Paste it in the expression builder when setting up the Compose action.

join(
  map(
    triggerBody()?['line_items'],

join(
  map(
    triggerBody()?['line_items'],
    lambda('item', concat(
      item()?['title'], 
      ' (', 
      string(item()?['quantity']), 
      ')'
    ))
  ),
  ', '
)