Analyze ad performance from Meta, Google and Microsoft using Groq Llama 3.3 and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 10 nodes and runs on a schedule (every month at 09:00). Along the way it connects Gmail and Google Sheets. It also calls api.groq.com over HTTP.
How it runs
Trigger: On a schedule (every month at 09:00).
- Read - Google ads (Google Sheets): uses Google Sheets
- Read - Meta ads (Google Sheets): uses Google Sheets
- Read - Microsoft ads (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Calculate - KPIs & Build Prompt (Code): runs custom JavaScript code
- Groq - Generate Insights (HTTP Request): calls api.groq.com (POST)
- Merge: merges the data from its input branches
- Build - HTML Report (Code): runs custom JavaScript code
- Send a message (Gmail): uses Gmail
Services it uses
HTTP calls to: api.groq.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
How it works This workflow automatically generates a detailed AI-powered campaign performance report across Meta, Google and Microsoft Ads and emails it to your team every month. It reads campaign data from three tabs in a Google Sheet (Google, Meta,…