Get a daily snapshot of which marketing campaigns drive orders. The workflow pulls yesterday’s Shopify orders and saves the campaign details into a Baserow table. It suits online stores that need clean attribution data without manual exports.

At midnight, a schedule starts the run. A Set node stores your Shopify subdomain, and a GraphQL call reads orders from the Shopify Admin API with customer journey data. The flow splits each order, reshapes the fields to simple values like order name, campaign, source, and content, then filters out records that have no campaign. Qualified rows are written to Baserow for reporting, while non campaign orders go to a no operation branch.

You only need a Shopify Admin API token and a Baserow API key, plus a table ready to receive the fields. Expect to cut weekly reporting time by at least an hour and gain a consistent view of campaign performance for every order with UTM data. It works well for daily dashboards, promo tracking, and month end summaries without manual CSV work.

• Scheduled run at 00:00 pulls yesterday’s orders automatically
• GraphQL request reads Shopify Admin API with customer journey summary
• Set node stores the Shopify subdomain used in the API endpoint
• SplitOut node turns the orders list into single items for clean processing
• Data transform maps order name and UTM fields like campaign, source, and content
• If node keeps only orders that include a campaign value
• Baserow node creates a new row for each qualified order
• No operation branch safely ignores items that do not meet the condition

• Reduce manual exports from 60 minutes to 5 minutes per day
• Improve attribution data quality by 90 percent by pulling UTM values from customer journeys
• Connect Shopify and Baserow seamlessly for one source of truth
• Automate 100 percent of daily order attribution capture
• Handle higher order volume without extra work as the store grows

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Shopify and Baserow. See the Tools Required section above for links to create accounts with these services.
3. In Shopify, create or use an app that has read access to orders and customer data, then copy your Admin API access token.
4. Open the Get orders from Shopify node, choose Credential to connect with, click Create new credential, pick HTTP Header Auth, and add a header named X Shopify Access Token with your token value. Save the credential.
5. In Baserow, create a database and table with columns for order, campaign, source, medium, and content. Generate a personal API token in your Baserow profile.
6. Open the Baserow node in n8n, create a new Baserow credential, paste your API token, and set the correct Baserow API base URL if self hosted. Save the credential.
7. Open the Set Shopify Subdomain node and replace the Shopify Subdomain value with your store subdomain without the myshopify part.
8. In the Baserow node, select your database and table, then map each incoming field from the If node to the matching Baserow column.
9. Click Execute once to test. Confirm the run completes and new rows appear in your Baserow table with order and campaign values.
10. If no rows appear, check that there were orders yesterday with UTM parameters, confirm your Shopify token has the right scopes, and verify the subdomain and API version in the endpoint.
11. Adjust the schedule time if your store uses a different timezone, and consider adding pagination if you often exceed 100 orders per day.