How to Sync Shopify Orders to HubSpot for Revenue Attribution with Power Automate

make.powerautomate.com > My flows > + New flow > Automated cloud flow

Create a new Automated cloud flow in Power Automate

Go to make.powerautomate.com and sign in. In the left sidebar click 'My flows', then click '+ New flow' at the top and select 'Automated cloud flow'. Give it a descriptive name like 'Shopify Order → HubSpot Revenue Attribution'. You will be prompted to choose a trigger — search for 'Shopify' in the trigger picker and select 'When an order is created'. This sets up the flow to fire the instant Shopify fires its order/paid webhook.

1. 1Click 'My flows' in the left sidebar
2. 2Click '+ New flow' then select 'Automated cloud flow'
3. 3Type a name: 'Shopify Order → HubSpot Revenue Attribution'
4. 4In the trigger search box type 'Shopify'
5. 5Select 'When an order is created' from the Shopify connector

Shopify Admin > Apps > Develop apps > Create app > API credentials

Authenticate the Shopify connection

Click 'Sign in' inside the trigger card. Power Automate will ask for your Shopify store URL (format: yourstore.myshopify.com) and an API access token. Generate a Custom App in Shopify Admin with read_orders scope, then paste that Admin API access token here. The connection will be saved under Connections in the left sidebar and reused across all steps.

1. 1In Shopify Admin, go to Settings > Apps and sales channels > Develop apps
2. 2Click 'Create an app', name it 'Power Automate Attribution'
3. 3Under 'Configuration', enable the 'read_orders' and 'read_customers' Admin API scopes
4. 4Click 'Install app' then copy the Admin API access token
5. 5Paste the store URL and token into the Power Automate connection prompt and click 'Create'

Flow canvas > + New step > Data Operation > Parse JSON

Add a Parse JSON action to extract UTM and order fields

Click '+ New step' below the trigger. Search for 'Parse JSON' and select the built-in Data Operation action. In the Content field, insert the dynamic value 'Body' from the Shopify trigger. Click 'Generate from sample' and paste in a real Shopify order JSON payload — specifically you need the note_attributes array where Shopify stores UTM parameters passed via the storefront. This step turns the raw webhook body into named, usable fields for downstream actions.

1. 1Click '+ New step'
2. 2Search 'Parse JSON' and select it under Data Operation
3. 3In the Content field, click the lightning bolt and select 'Body' from the Shopify trigger
4. 4Click 'Generate from sample' and paste a sample Shopify order JSON
5. 5Confirm the schema shows fields: id, email, total_price, note_attributes, created_at

Flow canvas > + New step > Control > Apply to each

Apply for each loop to extract UTM values from note_attributes

The note_attributes field is an array of name/value pairs like [{"name":"utm_source","value":"google"},{"name":"utm_campaign","value":"spring-sale"}]. Add an 'Apply to each' control action, setting the input to the note_attributes array from your Parse JSON step. Inside the loop, add a 'Condition' to check if the current item's name equals 'utm_source', 'utm_medium', or 'utm_campaign'. Use 'Set variable' actions to capture each value into flow-level variables you initialize before this loop.

1. 1Click '+ New step', select Control > Apply to each
2. 2In the 'Select an output from previous steps' field, select 'note_attributes' from Parse JSON
3. 3Inside the loop, add Control > Condition
4. 4Set the condition: items('Apply_to_each')?['name'] equals 'utm_source'
5. 5In the Yes branch, add Data Operation > Set variable and store items('Apply_to_each')?['value'] into a pre-initialized variable called varUTMSource

Flow canvas > + New step > Variables > Initialize variable

Initialize variables before the loop

Before the Apply to each loop, add three 'Initialize variable' actions — one for each UTM field. Set all three to Type: String and Value: empty string. Power Automate requires variables to be initialized at the top level of the flow, not inside a loop or condition branch. Name them varUTMSource, varUTMMedium, and varUTMCampaign. Add a fourth variable varOrderTotal of Type: Float to hold the Shopify order total_price value, set it immediately to the total_price from Parse JSON.

1. 1Click '+ New step' directly under Parse JSON (before the loop)
2. 2Search 'Initialize variable' and add it
3. 3Set Name: varUTMSource, Type: String, Value: (empty)
4. 4Repeat for varUTMMedium and varUTMCampaign
5. 5Add a fourth Initialize variable: varOrderTotal, Type: Float, Value: select total_price from Parse JSON dynamic content

Flow canvas > + New step > HubSpot CRM (V3) > Get contact by email

Search for the matching HubSpot contact by email

After the loop, add a new step using the HubSpot CRM (V3) connector. Select the action 'Search contacts by email' or use 'Get contact by property'. Pass in the email field from your Parse JSON output as the search value. This returns the HubSpot internal contact ID (hs_object_id) you need to update the right record. If no match is found, you will handle that in the next step with a condition.

1. 1Click '+ New step' after the Apply to each loop
2. 2Search 'HubSpot' and select the HubSpot CRM (V3) connector
3. 3Choose 'Get contact by email address' action
4. 4In the Email field, select 'email' from Parse JSON dynamic content
5. 5Leave additional properties blank for now

Flow canvas > + New step > Control > Condition

Add a condition to handle unmatched contacts

Add a Control > Condition step. Check whether the HubSpot Get contact action body contains a valid 'id' field — use the expression: empty(body('Get_contact_by_email_address')?['id']). In the 'Yes' branch (no contact found), add a HubSpot 'Create contact' action using the Shopify email, and optionally the customer first and last name from the Shopify order. In the 'No' branch (contact found), proceed to the update step. This prevents the flow from failing on first-time buyers.

1. 1Click '+ New step', choose Control > Condition
2. 2In the left field, paste expression: empty(body('Get_contact_by_email_address')?['id'])
3. 3Set operator to 'is equal to' and right value to 'true'
4. 4In the Yes branch, add HubSpot CRM (V3) > Create contact with email from Parse JSON
5. 5In the No branch, leave empty for now — this is where the update action goes in Step 8

Flow canvas > Condition No branch > + Add an action > HubSpot CRM (V3) > Update contact

Update the HubSpot contact with Shopify revenue and attribution fields

Inside the No branch of your condition (and after the Create contact in the Yes branch), add a HubSpot CRM (V3) 'Update contact' action. In the Contact ID field, use the expression: body('Get_contact_by_email_address')?['id']. Map the custom HubSpot properties you've pre-created for attribution: last_order_revenue, last_utm_source, last_utm_medium, last_utm_campaign, and last_order_date. Use your flow variables (varUTMSource, etc.) and the Parse JSON total_price field for these values.

1. 1In the No branch, click '+ Add an action'
2. 2Search HubSpot and select 'Update contact' from HubSpot CRM (V3)
3. 3In Contact ID, click the expression tab and type: body('Get_contact_by_email_address')?['id']
4. 4Click '+ Add new property', select 'last_order_revenue' and set value to varOrderTotal
5. 5Repeat for last_utm_source (varUTMSource), last_utm_campaign (varUTMCampaign), last_order_date (Parse JSON created_at)

HubSpot action card > Sign in > HubSpot OAuth screen

Authenticate the HubSpot connection

When you first add any HubSpot action, Power Automate prompts you to sign in. Click 'Sign in' in the action card and authenticate with the HubSpot account that has Super Admin or Marketing Access permissions. Power Automate uses OAuth2 — it will redirect you to HubSpot's authorization screen. After granting access, the connection is saved and reused across all HubSpot actions in this flow.

1. 1Click 'Sign in' in any HubSpot action card
2. 2You are redirected to HubSpot's OAuth2 authorization page
3. 3Select the correct HubSpot portal from the account picker if you manage multiple portals
4. 4Click 'Grant access'
5. 5Return to Power Automate — the connection now shows your HubSpot account email

Flow canvas > Save > Test > Manually > Trigger now

Test the flow end-to-end with a real Shopify order

Click 'Save' in the top toolbar, then click 'Test' in the upper right and choose 'Manually' to trigger a test run. Place a real test order in Shopify (use a discount code for $0 if needed) from an email address that already exists as a HubSpot contact. Watch the flow run in the 'Run history' panel — each step turns green on success or red on failure with an error message. Verify the HubSpot contact record was updated by opening it in HubSpot and checking the custom attribution properties.

1. 1Click 'Save' in the top right toolbar
2. 2Click 'Test', select 'Manually', click 'Test flow'
3. 3Place a test order in Shopify using an email that exists in HubSpot
4. 4Return to Power Automate and watch the run history — each step shows green/red status
5. 5Open HubSpot, find the contact by email, and verify last_order_revenue and UTM fields are populated

My flows > Flow detail page > Toggle On / Edit > + New step > Send an email (V2)

Turn on the flow and configure error notifications

Toggle the flow from Off to On using the toggle at the top of the flow detail page. Then go to 'My flows', find your flow, click the three-dot menu and select 'Edit'. Add a final 'Send an email (V2)' action configured to run after failure on any key step — specifically the HubSpot Update contact action. Set the recipient to your operations or marketing ops email so you know when an order fails to attribute. Power Automate does not retry failed webhook-triggered flows automatically.

1. 1On the flow detail page, click the toggle to set flow status to 'On'
2. 2Click 'Edit' to return to the canvas
3. 3Click the three dots on the HubSpot Update contact action and select 'Configure run after'
4. 4Check 'has failed' so this notification fires on failure
5. 5Add 'Send an email (V2)' with subject 'Attribution flow failed for order [order id]' and your ops team email as recipient

Paste this expression into the Value field of the 'Initialize variable' action for varOrderTotal, or directly into the HubSpot Update contact property value field for last_order_revenue. It converts Shopify's string price to a float and rounds to 2 decimal places, then formats the order date to a HubSpot-compatible YYYY-MM-DD string — both in one expression block. Use the Expression tab (not Dynamic content) in the field picker to enter these.

// Expression 1: Convert Shopify total_price string to float for HubSpot Number property
float(body('Parse_JSON')?['total_price'])
// Expression 2: Format Shopify created_at ISO timestamp to HubSpot date format (YYYY-MM-DD)

// Expression 1: Convert Shopify total_price string to float for HubSpot Number property
float(body('Parse_JSON')?['total_price'])

// Expression 2: Format Shopify created_at ISO timestamp to HubSpot date format (YYYY-MM-DD)
formatDateTime(body('Parse_JSON')?['created_at'], 'yyyy-MM-dd')

// Expression 3: Safely extract UTM source from note_attributes without looping
// Use this in a Select action to build a name-value dictionary first
json(string(body('Parse_JSON')?['note_attributes']))

// Expression 4: Null-safe UTM source extraction after Apply to each loop
if(empty(variables('varUTMSource')), 'direct', variables('varUTMSource'))

// Expression 5: Build a composite attribution label for a single HubSpot text field
concat(variables('varUTMSource'), ' / ', variables('varUTMMedium'), ' / ', variables('varUTMCampaign'))