Get Started
Screenshot of n8n workflow
FREE TEMPLATE
Automate Google Analytics Weekly Reports
5
Views
0
Downloads
14
Nodes
Download Template
Free
Preview Template
Utility Rating
7 / 10
Business Function
Marketing
Automation Orchestrator
n8n
Integrations
Telegram
OpenAI
Google Analytics
Email SMTP
Trigger Type
Schedule
Approx setup time ≈ 55 min
Need help setting up this template?
Ask in our free Futurise community
About
Community
Courses
Events
Members
Templates

How to Automate Google Analytics Weekly Reports?

Leon Petrou
FREE TEMPLATE
Automate Google Analytics Weekly Reports
5
Views
0
Downloads
14
Nodes
Download Template
Free
Preview Template
Utility Rating
7 / 10
Business Function
Marketing
Automation Orchestrator
n8n
Integrations
Telegram
OpenAI
Google Analytics
Email SMTP
Trigger Type
Schedule
Approximate setup time ≈ 55 minutes
Need help setting up this template?
Ask in our free Futurise community

Description

Get a clear weekly view of website performance without manual work. The system collects key Google Analytics data, compares it with the same period last year, and sends a simple report by email and Telegram. It is great for marketing teams that need fast updates every Monday.

It runs on a weekly schedule at a set time. First it pulls the last seven days of GA4 metrics, then maps fields and sums the numbers. A code step calculates the matching seven day window from the previous year and triggers a second GA4 pull. Two summary steps aggregate totals and averages. An AI step builds an easy table with current values, last year values, and percent change. The email node sends the HTML report, and a second AI step turns it into short plain text for Telegram.

You will need access to Google Analytics, an OpenAI API key, SMTP email, and Telegram if you want chat updates. Expect to cut reporting time from hours to minutes while keeping a consistent year over year view. It fits teams that want weekly KPI tracking, leaders who want fast inbox updates, and anyone who likes quick chat summaries on the go.

Copy link

Tools Required

Telegram
Sign up
Free: $0, Telegram Bot API usage is free for developers
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
Email SMTP
Sign up

What this workflow does?

  • Weekly schedule trigger runs every Monday at a set hour
  • GA4 data pull for the last seven days with key metrics like page views, users, sessions, session duration, and purchases
  • Code step calculates the same seven day period from the previous year
  • Dual summary steps total and average metrics for both current and last year
  • AI formatting creates an HTML table with percent change for each metric
  • Email node sends the report with a clear subject and HTML body
  • AI converts HTML to short plain text for Telegram and sends it to a chosen chat

What are the benefits?

  • Reduce manual reporting from 2 hours to 5 minutes
  • Automate over 90 percent of weekly reporting steps
  • Improve data accuracy by removing copy and paste errors
  • Connect Google Analytics, OpenAI, email, and Telegram in one flow
  • Send a consistent year over year KPI report every Monday at the same time
  • Give managers fast inbox and chat summaries without dashboards

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, OpenAI, Telegram and Email SMTP. See the Tools Required section above for links to create accounts with these services.
  3. Open the Schedule Trigger node and set the day and hour you want. Make sure the time zone in n8n matches your reporting time zone.
  4. Connect Google Analytics: double click each Google Analytics node, select Credential to connect with, click Create new credential, choose Google Analytics OAuth2, and follow the on screen steps to grant property access.
  5. In the Google Analytics nodes, pick the correct GA4 property. Keep the metrics as provided or adjust them if your team tracks different KPIs.
  6. Leave the date code as is unless you have a special calendar. The Calculation same period previous year node already computes the correct last year window.
  7. Connect OpenAI: double click the Processing for email and Processing for Telegram nodes, create a new OpenAI API Key credential, and paste your key from the OpenAI API page.
  8. Set up email: open the Send Email node, create a new SMTP credential, and enter host, port, username, and password. Set from and to addresses and test your SMTP with a simple email if needed.
  9. Optional Telegram: create a bot with BotFather to get a token. In the Telegram node, create a new Telegram credential with that token, and set the chat ID where messages should go.
  10. Run a manual test: click Execute workflow. Check the Processing for email output for a clean HTML table and confirm you receive the email. If using Telegram, verify the short text message arrives.
  11. Troubleshoot common issues: ensure the GA property ID is correct, verify account permissions, check that the OpenAI key is valid, confirm SMTP settings, and make sure the Telegram chat ID belongs to your bot.
  12. When tests pass, activate the workflow so it runs on schedule and monitor the first few runs in the n8n execution list.

Need help or want to customize this?

Ask in the Free Futurise Community.

Similar Templates

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.
59 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
n8n
Marketing
Automate Google Sheets Company Enrichment
Turn a basic company list in Google Sheets into rich profiles ready for outreach and segmentation. The flow reads each website, scrapes the homepage, and writes clear fields like offer, value proposition, business model, and ICP. It suits marketing teams that need fast research at scale. A webhook starts the run. Rows are pulled from your sheet, then handled one by one using a loop. An AI agent calls a helper workflow that uses ScrapingBee to fetch the page, converts HTML to markdown to lower token use, then sends the text to an OpenAI chat model. A structured parser returns clean fields that map back to the same row so your sheet stays updated without copy and paste. The agent also flags missing or mismatched content so you know what to review. You will need a Google service account with access to the sheet, an OpenAI key, and a ScrapingBee key. Expect research time per company to drop from minutes to seconds while keeping data consistent across the list. Use it to qualify leads, segment accounts, and prepare outreach without manual browsing. Make sure your sheet has Company and Website columns and confirm the document ID and tab configured in the nodes.
3 views
view
See More Templates

Credits: Friedemann Schuetz on LinkedIn - 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.