Get Started
Screenshot of n8n workflow
FREE TEMPLATE
Automate Google Analytics and Ads Reporting
9
Views
0
Downloads
51
Nodes
Download Template
Free
Preview Template
Utility Rating
8 / 10
Business Function
Marketing
Automation Orchestrator
n8n
Integrations
Telegram
SMTP
OpenAI
Google Analytics
Google Ads
Facebook Graph API
Trigger Type
Schedule
Other
Approx setup time ≈ 75 min
Need help setting up this template?
Ask in our free Futurise community
About
Community
Courses
Events
Members
Templates

How to Automate Google Analytics and Ads Reporting?

Leon Petrou
FREE TEMPLATE
Automate Google Analytics and Ads Reporting
9
Views
0
Downloads
51
Nodes
Download Template
Free
Preview Template
Utility Rating
8 / 10
Business Function
Marketing
Automation Orchestrator
n8n
Integrations
Telegram
SMTP
OpenAI
Google Analytics
Google Ads
Facebook Graph API
Trigger Type
Schedule
Other
Approximate setup time ≈ 75 minutes
Need help setting up this template?
Ask in our free Futurise community

Description

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.

Copy link

Tools Required

Telegram
Sign up
Free: $0, Telegram Bot API usage is free for developers
SMTP
Sign up
OpenAI
Sign up
Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens
n8n
Sign up
$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.
Google Analytics
Sign up
Free (GA4 standard): $0; API access included and subject to quotas
Google Ads
Sign up
Basic Access (free): $0, up to 15,000 operations/day; no API usage fees
Facebook Graph API
Sign up
Free: $0 (no direct API charges; usage subject to rate limits)

What this workflow does?

  • 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.

What are the benefits?

  • 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

How to set this up?

  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.

Need help or want to customize this?

Ask in the Free Futurise Community.

Similar Templates

n8n
Marketing
Generate YouTube Shorts from Google Sheets
Create short videos for YouTube by pulling a quote and creative prompts from Google Sheets, building the background image and video with AI, adding ambient sound, and publishing the final clip to your channel. Great for social teams and creators who want steady content without manual editing. A manual start reads one row from Google Sheets with the quote, author, and scene prompts. The flow calls an image model to render a vertical image, waits, then writes the image link back to the sheet. It then sends that image to a video model to produce a cinematic vertical clip, waits again, downloads the file, and records the video link in the sheet. Audio is generated with a voice and sound service, stored to Google Drive, and the drive link is saved. A code node formats overlay text, then FFmpeg merges video, audio, and on screen text into a final MP4. The clip uploads to YouTube with a resumable upload, and the sheet is updated with status and the YouTube link. You will need API keys for the AI services, Google and YouTube OAuth, and FFmpeg installed on the n8n host. Expect one run to replace hours of editing with a repeatable system managed from a spreadsheet. Ideal for daily quotes, quick tips, or listicle shorts driven by your sheet.
13 views
view
n8n
Marketing
Automate Google Drive Resume Q&A
Turn a resume in Google Drive into a smart chat that answers questions and sends a daily email report. Ideal for personal sites, career pages, or portfolios that want simple Q&A and clear insights without manual updates. When a file is added or changed in a chosen Google Drive folder, the text is split into chunks, embedded with Google Gemini, and stored in Pinecone. A public chat webhook lets visitors ask questions. The agent uses the vector store, a memory buffer, and the Gemini chat model to give grounded answers. A separate webhook can save conversation logs to NocoDB. Each day on schedule, the workflow pulls today’s conversations, groups them by session and email, formats them as HTML, and emails a summary from Gmail. Setup needs Google Drive, Gmail, Pinecone, Google Gemini, and NocoDB credentials in n8n. Expect less manual work, faster updates when the resume changes, and one clear email summary at the end of the day. Use it for personal branding, HR portfolios, or team pages that need quick, accurate answers based on the latest resume content.
60 views
view
n8n
Marketing
Sync WordPress to Google Drive Content Reports
Content teams often need a fresh list of live posts for reports and audits. This setup pulls all published posts from WordPress and saves a clean CSV file straight to Google Drive. It is ideal for marketers, editors, and agencies that want quick exports without copy and paste. Under the hood, a manual trigger starts the run. The workflow fetches all published posts from WordPress, then uses a field mapping step to keep only the columns you want, like id and title. Next it turns the result into a CSV file and uploads it to your chosen Google Drive folder using a service account. You get a consistent file that is ready for Google Sheets, with only live content included, and the same format every time. You will need WordPress access and a Google Drive account with a service account set up. Connect both in n8n, select the fields you care about in the Adjust Fields step, and click Test to generate your first export. Expect a ready file in minutes and a big cut in manual work. This is great for monthly content reviews, SEO audits, campaign summaries, and client deliverables.
11 views
view
See More Templates

Credits: Author: Friedemann Schuetz - 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. If you are the author and would like this template removed from the template library, email us at info@futurise.com and we will remove it promptly.