How to Automate Google Analytics Campaign Tracking?
Description
Turn campaign links into trackable assets and get clear email summaries on a schedule. Marketers enter a website and UTM details once, then the system saves the link, makes a QR code, and later reports results from Google Analytics. This is helpful for teams that run ads, print pieces, events, or partner promos.
On a manual run, inputs flow through a set step and a code step that build a clean UTM URL. The link is upserted into an Airtable table for easy logging, and a QR image is created through a simple HTTP call. A schedule trigger then queries GA4 for sessions by sourceMedium using your property. An AI agent powered by OpenAI turns the dataset into a short executive summary, and Gmail delivers it to your marketing lead.
Set up an Airtable base with a URL field, connect your Google Analytics property, and choose the recipient email. Expect faster launch of campaigns, fewer tagging mistakes, and clear feedback on what channels drive visits. This setup works well for flyers, events, billboards, and any campaign that needs a QR code and proof of traffic. Many teams see link build time drop from minutes to seconds and save about an hour each reporting cycle.
Tools Required
What this workflow does?
- Manual start collects website and UTM values through a set step
- Code step builds a standard UTM URL from your inputs
- Airtable upsert stores the final link for a clean audit trail
- HTTP request generates a QR code for the UTM link via QuickChart
- Schedule trigger runs GA4 queries on a set interval
- Google Analytics node tracks sessions by sourceMedium for your property
- OpenAI agent turns raw numbers into an executive summary
- Gmail sends the summary to your marketing lead
What are the benefits?
- Reduce manual work from 30 minutes per link to 2 minutes
- Automate weekly reporting and save about 1 hour per week
- Improve UTM data quality by 90 percent with a standard format
- Handle up to 10 times more campaign links without extra staff
- Connect Airtable, Google Analytics, OpenAI, and Gmail in one flow
How to set this up?
- 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.
- You'll need accounts with Google Analytics, Airtable, Gmail and OpenAI. See the Tools Required section above for links to create accounts with these services.
- In the n8n credentials manager, open the OpenAI credential. If it does not exist, double click the OpenAI node, choose Create new credential, and follow the on screen steps to add your API key. Name it clearly, for example OpenAI Prod.
- In the credentials manager, set up Google Analytics. If unsure, double click the Google Analytics node, choose Create new credential, and complete the OAuth flow with the Google account that has access to your GA4 property.
- In the credentials manager, set up Gmail. Double click the Gmail node, choose Create new credential, and finish the OAuth flow. Use the account you want to send reports from.
- In the credentials manager, add Airtable. Double click the Airtable node, choose Create new credential, and paste a Personal Access Token from your Airtable account. Give it a clear name such as Airtable PAT Prod.
- In Airtable, create a base and a table with a field named URL as a single line text field. Copy the base and table IDs if needed.
- Open the Set UTM Parameters For Link node in n8n and enter default values for website_url, campaign_source, campaign_medium, campaign_name, and campaign_term. You can update these before each manual run.
- Open the Create UTM Link With Parameters node to confirm the UTM format. Run a manual test and check that the utmUrl field looks correct.
- Run the manual trigger. Confirm a new record appears in Airtable with the URL value. Open the HTTP request node output and test the QR image to ensure it scans to the same UTM link.
- Open the Google Analytics node and set your property ID. Keep the Sessions metric and sourceMedium dimension or adjust as needed. Test the node and verify rows are returned.
- Open the Google Analytics Data Analysis Agent node, make sure the OpenAI credential is selected, and run a test. Then open the Gmail node and send a test message to confirm delivery.
- Set the schedule interval in the Schedule Google Analytics Report node. Save and activate the workflow. Check your time zone to ensure reports arrive when expected.
- If something fails, check permissions on the GA4 property, confirm the Airtable table and field names match, verify the Gmail account can send messages, and ensure your OpenAI key has quota.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
