Get a weekly marketing report without manual work. It gathers data from Google Analytics, Google Ads, and Meta Ads, compares it to the same week last year, and sends a clear summary by email and Telegram. Great for marketing teams and agencies that need quick and reliable updates.

A Monday 7 a.m. schedule starts the run. Subflows fetch Analytics for multiple domains, plus Google Ads and Meta Ads. Date tools pull the last 7 days and match the same period from the previous year. The flow formats metrics, then an AI model builds a short table and plain language summary. An agent composes the final email and an optional short Telegram update so leaders can act fast.

Setup needs accounts for Google Analytics, Google Ads, Facebook Graph API, OpenAI, SMTP, and Telegram. Expect reporting time to drop from hours to minutes, with consistent comparisons across channels. This helps brands with several sites and agencies with many clients track ROAS and traffic in one place, and make weekly changes sooner.

• Weekly schedule runs every Monday at 7 a.m. to keep reporting consistent.
• Subflows pull Google Analytics for several domains to cover all sites.
• Google Ads and Meta Ads data is fetched for the last 7 days and the same week last year.
• Date calculators align current and previous year periods for fair comparisons.
• Formatting nodes prepare clean input so the AI can summarize clearly.
• OpenAI GPT 4o creates a concise table and a plain language summary.
• SMTP node sends the full email report to your chosen recipients.
• Telegram node posts a short update for quick team visibility.
• Calculator tools support simple ratios like ROAS or CTR if needed.

• Reduce manual reporting from 3 hours to 10 minutes each week
• Streamline weekly report prep by about 80 percent
• Improve date accuracy by using matched periods year over year
• Unify Google Analytics, Google Ads, and Meta Ads into one view
• Scale to multiple domains without extra effort
• Deliver insights by email and Telegram so teams act faster

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 Google Analytics, Google Ads, Facebook Graph API, OpenAI, Telegram and SMTP. See the Tools Required section above for links to create accounts with these services.
3. Open the Schedule Trigger node and confirm the time zone and the Monday 7 a.m. setting. Adjust day and hour if your team needs a different schedule.
4. Set Google Analytics credentials: double click the Google Analytics nodes, choose 'Credential to connect with', click 'Create new credential', then follow the on screen steps. Ensure your user has read access to the correct properties.
5. Set Google Ads credentials: open the Google Ads nodes, create credentials for Google OAuth and Google Ads. Follow the prompts. Make sure the linked Google Ads account has permission to read reporting data.
6. Connect Facebook Graph API for Meta Ads: open the Meta Ads nodes, create a new Facebook Graph API credential, and follow the steps to grant access to the right ad accounts.
7. Add your OpenAI key: open each OpenAI node, create a new credential, paste your API key from your OpenAI account, and set the model to gpt-4o.
8. Configure SMTP: open the Send mail report node, add your SMTP host, port, username, and password. Set From, To, and Subject. Send a test message to confirm delivery.
9. Set up Telegram (optional): open the Telegram node, create a new Telegram credential with your bot token, and enter the chat ID. Send a test message to verify.
10. Review tool workflow nodes that fetch subflow data for Analytics, Google Ads, and Meta Ads. If you use your own subflows, open each tool node and select the correct workflow ID.
11. Check date calculation nodes for last 7 days and same period last year. Confirm the format matches your data sources and your time zone.
12. Run the workflow once manually and confirm the email includes a current vs last year table and a short summary. If any section is empty, check credentials and property or account IDs.
13. Troubleshoot common issues: if analytics returns no rows, verify property and view settings. If ads data fails, confirm API permissions. If emails go to spam, review your SMTP domain settings. If AI calls fail, check your API key and usage limits.