Create a Google Analytics data report with AI and sent it to e m
What this workflow does This workflow retrieves Google Analytics data from the last 7 days and the same period in the previous year. The data is then prepare...
🔌 Nodes & Integrations Used (6)
📖 Implementation & Setup Guide
What this workflow does This workflow retrieves Google Analytics data from the last 7 days and the same period in the previous year. The data is then prepared by AI as a table, analyzed and provided with a small summary. The summary is then sent by email to a desired address and, shortened and summarized again, sent to a Telegram account.
This workflow has the following sequence:
- time trigger (e.g. every Monday at 7 a.m.)
- retrieval of Google Analytics data from the last 7 days
- assignment and summary of the data
- retrieval of Google Analytics data from the last 7 days of the previous year
- allocation and summary of the data
- preparation in tabular form and brief analysis by AI.
- sending the report as an email
- preparation in short form by AI for Telegram (optional)
- sending as Telegram message.
Requirements The following accesses are required for the workflow: - Google Analytics (via Google Analytics API): [Documentation](https://docs.n8n.io/integrations/builtin/credentials/google/) - AI API access (e.g. via OpenAI, Anthropic, Google or Ollama) - SMTP access data (for sending the mail) - Telegram access data (optional for sending as Telegram message): [Documentation](https://docs.n8n.io/integrations/builtin/credentials/telegram/)
Feel free to [contact me via LinkedIn](https://www.linkedin.com/in/friedemann-schuetz), if you have any questions!
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Create_a_Google_Analytics_data_report_with_AI_and_sent_it_to_e_m.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Email & Outreach Workflows
View All in Email & Outreach →Abandoned cart recovery for Shopify via Gmail Google Sheets T
Who is this for? This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to reco...
Add new leads in Lemlist from Airtable
This workflow allows you to add new leads in Lemlist from Airtable. !workflow-screenshot Airtable node: This node lists all the emails that are stored in you...
Add Subscriber and Send Email Campaign
Production-ready n8n automation template for Add Subscriber and Send Email Campaign built by AhiXLight. Seamlessly connects Sendy with 3 configured nodes.
Add new contacts from HubSpot to the email list in Mailchimp
This workflow adds new HubSpot contacts to the Mailchimp email list. Prerequisites - HubSpot account and HubSpot credentials - Mailchimp account and Mailchim...