Template description
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.
This template will help you:
- Automatically retrieve UTM parameters from Shopify orders using the Shopify Admin API
- Process marketing data through n8n
- 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?
- Create a custom app in Shopify get the credentials needed to connect n8n to Shopify
This is needed for the Shopify Trigger - Create Shopify Acces Token API credentials n n8n for the Shopify trigger node
- Create Header Auth credentials:
Use X-Shopify-Access-Token as the name and the Acces-Token from the Shopify App you created as the value.
The Header Auth is neccessary for the GraphQL nodes. - You will need a running Baserow instance for this. You can also sign up for a free account at 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
Share Template
More Marketing workflow templates
+4
OpenAI GPT-3: Company Enrichment from website content
Enrich your company lists with OpenAI GPT-3 ↓
You’ll get valuable information such as:
Market (B2B or B2C)
Industry
Target Audience
Value Proposition
This will help you to:
add more personalization to your outreach
make informed decisions about which accounts to target
I've made the process easy with an n8n workflow.
Here is what it does:
Retrieve website URLs from Google Sheets
Extract the content for each website
Analyze it with GPT-3
Update Google Sheets with GPT-3 data
Lucas Perret
+5
Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel
How it works:
The workflow starts by sending a request to a website to retrieve its HTML content.
It then parses the HTML extracting the relevant information
The extracted data is storted and converted into a CSV file.
The CSV file is attached to an email and sent to your specified address.
The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use.
Set-up steps:
Change the website to scrape in the "Fetch website content" node
Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node)
Configure Google Cloud credentials with access to Google Drive, Google Sheets and Gmail APIs (the latter is required for the Send CSV via e-mail node).
Mihai Farcas
+5
Personalize marketing emails using customer data and AI
This workflow uses AI to analyze customer sentiment from product feedback. If the sentiment is negative, AI will determine whether offering a coupon could improve the customer experience.
Upon completing the sentiment analysis, the workflow creates a personalized email templates. This solution streamlines the process of engaging with customers post-purchase, particularly when addressing dissatisfaction, and ensures that outreach is both personalized and automated.
This workflow won the 1st place in our last AI contest.
Note that to use this template, you need to be on n8n version 1.19.4 or later.
n8n Team
