FM
FlowMarket
Ecommerce & Sales Intermediate ⚡ 12 n8n Nodes

Automate your UTM campaign tracking Shopify n8n to Baserow

Campaign tracking is pivotal; it enables marketers to evaluate the efficacy of various strategies and channels. UTM parameters are particularly essential as ...

🔌 Nodes & Integrations Used (2)

Baserow Graphql

📖 Implementation & Setup Guide

Campaign tracking is pivotal; it enables marketers to evaluate the efficacy of various strategies and channels. UTM parameters are particularly essential as they provide granular details about the source, medium, and campaign effectiveness. However, when this data is not automatically integrated into a centralized system, it can become a tedious and error-prone process to manually collate and analyze it.

Retrieving UTM data from Shopify and storing it in Baserow enables oy to do more with this data. For example you could build a campaign database in Baserow and automatically add campaign revenue to it using this workflow template.

![20240223_11h48m44s_grim.png](fileId:744)

This template will help you:

  1. Automatically retrieve UTM parameters from Shopify orders using the Shopify Admin API
  2. Process marketing data through n8n
  3. Store this data into Baserow, providing you with a dynamic, responsive base for campaign tracking and decision-making

This template will demonstrate the follwing concepts in n8n:

  • use the **Schedule trigger node**
  • use the **GraphQL node** to call the Shopify Admin API
  • split larger incoming datasets into n8n items with the **Split node**
  • transform the data structure with the **Set node**
  • control flow with the **If node**
  • store data in Baserow with the **Baserow node**

How to get started?

  1. Create a custom app in Shopify get the credentials needed to connect n8n to Shopify
  2. This is needed for the Shopify Trigger
  3. Create **Shopify Acces Token API** credentials n n8n for the Shopify trigger node
  4. Create **Header Auth** credentials:
  5. Use **X-Shopify-Access-Token** as the name and the Acces-Token from the Shopify App you created as the value.
  6. The Header Auth is neccessary for the GraphQL nodes.
  7. You will need a running Baserow instance for this. You can also sign up for a free account at [https://baserow.io/](https://baserow.io/)

Please make sure to read the notes in the template.

For a detailed explanation please check the corresponding video: [https://youtu.be/VBeN-3129RM](https://youtu.be/VBeN-3129RM)

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Automate_your_UTM_campaign_tracking_Shopify_n8n_to_Baserow.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related Ecommerce & Sales Workflows

View All in Ecommerce & Sales →