n8n Workflow: Automate Your UTM Campaign Tracking (Shopify to Baserow)

This n8n workflow is designed to automate the process of tracking UTM campaign data from a source (likely Shopify, given the directory name) and storing it in a Baserow database. It provides a flexible structure to handle incoming data, process it, and then persist it for analysis.

What it does

This workflow provides a foundational structure for data processing, including conditional logic, data manipulation, and integration with a GraphQL API and Baserow.

1. Triggers on a Schedule: The workflow is initiated on a predefined schedule, indicating it's designed for periodic data collection or processing.
2. Performs a GraphQL Query: It executes a GraphQL query, likely to fetch data from a source system (e.g., Shopify for orders, products, or marketing data).
3. Splits Out Data Items: The results from the GraphQL query are then split into individual items, allowing for per-item processing.
4. Edits Fields (Set): For each item, it allows for the manipulation and transformation of data fields, such as renaming, adding, or removing properties.
5. Applies Conditional Logic (If): It includes an "If" node to introduce conditional branching, allowing different actions based on specific data criteria.
6. Handles True/False Branches:
   • True Branch: If the condition evaluates to true, the workflow proceeds to a "No Operation" node, which acts as a placeholder or a point where further actions could be added.
   • False Branch: If the condition evaluates to false, the workflow proceeds to update or create records in a Baserow database.

Prerequisites/Requirements

• n8n Instance: A running n8n instance (cloud or self-hosted).
• GraphQL Endpoint: Access to a GraphQL API endpoint for data retrieval (e.g., Shopify GraphQL API).
• Baserow Account: A Baserow account with a database and table configured to store your UTM campaign data.
• Baserow API Token: An API token for Baserow to allow n8n to interact with your database.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • GraphQL: Set up a new GraphQL credential with the URL of your GraphQL API and any required authentication (e.g., API keys, headers).
   • Baserow: Set up a new Baserow credential with your Baserow API token.
3. Configure the Schedule Trigger node: Adjust the schedule to your desired frequency for running the workflow (e.g., daily, hourly).
4. Configure the GraphQL node:
   • Update the GraphQL query to fetch the specific data you need (e.g., Shopify orders with UTM parameters).
   • Ensure the query returns the necessary fields for your tracking.
5. Configure the Edit Fields (Set) node:
   • Map and transform the incoming data from the GraphQL query to match the structure required by your Baserow table.
   • This is where you would extract and format UTM parameters (e.g., utm_source, utm_medium, utm_campaign).
6. Configure the If node:
   • Define the conditions for your branching logic. For example, you might check if certain UTM parameters exist or if a record already exists in Baserow.
7. Configure the Baserow node (False Branch):
   • Select your Baserow credential.
   • Specify the Database ID and Table ID where you want to store the data.
   • Map the fields from the Edit Fields (Set) node to the corresponding columns in your Baserow table.
   • Choose the operation (e.g., "Create" to add new records, or "Update" if you have a unique identifier to check for existing records).
8. Activate the workflow: Once configured, activate the workflow to start automated tracking.