Create trackable campaign links with UTM tags, save them in Airtable, and get a QR code ready for print or ads. You also receive scheduled Google Analytics summaries by email so the team can see what is working. Built for marketing teams that want simple tracking without extra manual work.

A manual start collects your website URL and UTM fields. A code step builds the full UTM link, then n8n saves it to Airtable and calls QuickChart to generate a QR code. On a schedule, the flow pulls sessions by source and medium from Google Analytics 4. An AI agent using OpenAI reviews the data, writes a short executive summary, and Gmail sends it to your marketing manager.

You will need access to GA4, Gmail, Airtable, and an OpenAI key. Set your Airtable base and table, map the URL field, and replace the GA property ID with your own. Expect faster campaign launches, fewer typos in links, and weekly reporting done without copy and paste. It fits print flyers, store signage, events, and paid ads that need unique source and medium values.

• Manual start collects website URL and UTM fields for each campaign
• Code step builds a correct UTM link from your source, medium, name and term
• Airtable upsert stores the final URL in your chosen base and table
• HTTP request to QuickChart creates a ready to use QR code for the UTM link
• Scheduled Google Analytics 4 query pulls sessions by source and medium
• OpenAI agent with memory writes an executive summary and Gmail sends it

• Reduce UTM link creation time from 30 minutes to 2 minutes per link
• Eliminate manual reporting prep with scheduled email summaries
• Improve tracking accuracy by removing copy and paste errors
• Connect Gmail, Airtable, Google Analytics, OpenAI and QuickChart in one flow
• Scale to handle dozens of new campaign links without extra effort
• Keep a clean audit trail of every link in an Airtable table

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 Gmail, Airtable, Google Analytics, OpenAI and QuickChart. See the Tools Required section above for links to create accounts with these services.
3. Open the Gmail node. In the Credential to connect with dropdown, click Create new credential and follow the on screen steps to connect your Gmail account using OAuth2. Send a test email to confirm the connection works.
4. Open the Google Analytics node. Click Create new credential and connect your Google account with access to your GA4 property. Replace the property ID with your own GA4 property ID.
5. Open the Airtable node. Click Create new credential, choose API Token, and paste an Airtable personal access token from your Airtable account page. Name the credential clearly, then select your base and table.
6. Open the OpenAI Chat Model node. Click Create new credential and paste your OpenAI API key from the OpenAI dashboard. Save the credential and run a quick test if prompted.
7. No credential is needed for QuickChart. The HTTP Request node uses the public QuickChart endpoint. Keep the URL template intact so it embeds your UTM link correctly.
8. In Airtable, create a table with a URL field to store the final UTM link. In the Airtable node, map the URL column to the utmUrl field from the code step.
9. Open the Set node and update default values for website URL, campaign source, medium, name and term. Run the manual trigger path to verify a new Airtable row appears and the QR code URL is generated.
10. Update the Google Analytics node metrics and dimensions if needed. Run the scheduled path manually once to confirm data returns for your property.
11. Open the Gmail node and set the To address for your marketing manager. Send a test to make sure the summary email arrives.
12. Set the Schedule Trigger to your desired cadence such as weekly or daily. Enable the workflow so reports send automatically.
13. Troubleshooting: If Airtable is empty, check the base, table and URL column names. If GA returns no rows, verify the property ID and that data exists for the date range. If the email does not send, reauthorize Gmail. If the QR code fails, confirm the URL is not blank.