Google Analytics and Slack integration

Who it's for This advanced n8n workflow is designed for SEO specialists, digital agency owners, webmasters, and marketing managers who need a comprehensive, automated solution to track and improve their website's search engine performance. It acts as a virtual SEO analyst, automatically gathering data from multiple sources (Google Analytics, Search Console, PageSpeed Insights, and technical audits), analyzing them with AI agents, and delivering actionable insights via various communication channels. Features Multi-Source Data Collection**: Automatically fetches data from Google Analytics (GA4), Google Search Console, PageSpeed Insights, and performs on-page technical audits. Dual Trigger Modes**: Run the report automatically on a monthly schedule or trigger it instantly via Telegram by sending an "SEO Analysis" command. AI-Powered Analysis**: Utilizes specialized LangChain Agents (Analytics, Performance, SEO, Technical) to analyze raw data and generate human-readable insights. History Tracking**: Reads and writes historical data to Google Sheets, allowing AI agents to compare current performance against past data for trend analysis. Technical SEO Audit**: Crawls the website homepage to extract meta tags, headings (H1), and image alt attributes to calculate an on-page SEO score. Executive Summaries**: Generates a comprehensive "Master Analyst" report that aggregates findings from all agents into a unified action plan. Multi-Channel Reporting**: Sends the final SEO report simultaneously to Slack, Microsoft Teams, Discord, WhatsApp (via Rapiwa), and Telegram. Smart Filtering**: Includes Telegram verification logic to restrict report generation to authorized admins or alert the admin when a user requests an analysis. Requirements Google APIs**: Credentials for Google Analytics (GA4), Google Search Console, and Google Sheets OAuth2. OpenAI API**: Required for the LangChain Agents (using models like gpt-4.1-mini and gpt-4.1-nano) to process data and generate insights. Telegram API**: For triggering the workflow and receiving the final report. Slack API**: To post messages to a specific Slack channel. Microsoft Teams API**: To send notifications to a Team or channel. Discord Bot API**: To post rich embed updates to a Discord server. Rapiwa (WhatsApp)**: To send the report via WhatsApp messages. Important Notes Permissions**: Ensure your Google Cloud Project has access to the specific View ID for Analytics and the Site URL for Search Console. Telegram Setup**: You must update the Chat ID in the "Send SEO Report Message" node to ensure the report goes to the correct recipient. The workflow includes a check to validate the user ID against an admin list. Data Aggregation**: The workflow uses a "Merge" node to combine outputs from four different AI agents. Ensure all agents complete successfully before the merge step. Sheet ID**: The Google Sheets nodes (Append row, Get GA History, etc.) require the specific Document ID and Sheet Name to be populated to read/write history correctly. Target Domain**: Update the Edit Fields (Add Your Target Website URL) node with your specific domain (e.g., https://yourwebsite.com) before activating. Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Automate and Distribute Weekly and Monthly Marketing Analytics Reports Who's it for? This workflow is designed for marketing teams, data analysts, and business owners who need to consistently track key performance indicators (KPIs). It saves hours of manual data collection and reporting, ensuring stakeholders receive timely updates automatically. What it does This workflow automates the entire process of creating and distributing regular analytics reports. On a recurring weekly and monthly schedule, it: Fetches Data: Gathers the latest data from Google Analytics (users, sessions, conversions), your advertising platform (ad spend), and your CRM (new customers, revenue). Calculates KPIs: Processes the raw data to calculate essential business metrics, including Monthly Active Users (MAU), Customer Acquisition Cost (CAC), Lifetime Value (LTV), LTV:CAC ratio, and conversion rates. Logs Historical Data: Appends the newly calculated KPIs to a Google Sheet, creating a historical record for trend analysis. Generates a Report: Creates a new Google Slides presentation to serve as the main report. Distributes the Report: Emails a summary of the key metrics to a predefined list of recipients, including a link to the full Google Slides report. Provides Error Alerts: If any step in the process fails, it sends an immediate notification to a designated Slack channel so you can address the issue quickly. How to set up Configure Credentials: Add your credentials for Google Analytics, Google Sheets, Google Slides, Gmail, Slack, and the HTTP Request nodes (for your ad platform and CRM). Fill in Placeholders: In the "Workflow Configuration" node, replace all placeholder values with your specific information: gaPropertyId: Your Google Analytics Property ID. adPlatformApiUrl: The API endpoint for your advertising platform. crmApiUrl: The API endpoint for your CRM. reportSpreadsheetId: The ID of the Google Sheet where data will be stored. slidesTemplateId: The ID of your Google Slides report template. reportRecipients: A comma-separated list of email addresses for report distribution. slackChannel: The Slack channel ID for error notifications. Activate Workflow: Turn the workflow on. It will now run based on the schedule defined in the "Weekly/Monthly Schedule" trigger node. How to customize the workflow Adjust Schedule:** Modify the "Weekly/Monthly Schedule" node to change the reporting frequency (e.g., daily, bi-weekly). Change Reporting Period:** In the "Workflow Configuration" node, change the reportPeriodDays value to adjust the lookback window (e.g., set to 30 for a monthly report). Customize KPIs:** Edit the Javascript in the "Calculate KPIs (MAU, LTV, CAC)" node to add or modify metrics. Enhance the Report:** Expand the "Create Google Slides Report" node to dynamically add charts and data from the calculated KPIs into the slides.

🟡 DESCRIPTION This n8n workflow automates the daily generation of comprehensive analytics reports from multiple websites, processes them using OpenAI's powerful language models, and then delivers the insights directly to your email and Slack channels. Designed for digital marketers, website administrators, and data analysts, this template streamlines the tedious process of manually collecting and interpreting website performance data, offering immediate, actionable intelligence. The core problem this workflow solves is the fragmentation and manual effort involved in monitoring numerous website analytics. Instead of logging into multiple Google Analytics accounts or properties daily, this workflow centralizes data extraction, enriches it with AI-powered summaries, and distributes it to your preferred communication platforms. This significantly reduces the time spent on routine reporting, allowing you to focus on strategy and decision-making. Users who would benefit most from this template include: Digital Marketing Agencies: Efficiently generate and share client reports across multiple properties. E-commerce Businesses: Monitor performance of various product sites or regional domains. Content Creators: Track the success of different blogs or content platforms. Anyone managing a portfolio of websites: Gain a unified view of their digital assets' performance. 🟡 SETUP Before importing and running this workflow, ensure you have the following prerequisites in place: ► Google Analytics API Setup: Go to the Google Cloud Console (https://console.cloud.google.com/). Create a new project or select an existing one. Navigate to "APIs & Services" > "Enabled APIs & services." Search for and enable the "Google Analytics Data API" (for GA4) or "Google Analytics Reporting API" (for Universal Analytics, if still in use). Go to "APIs & Services" > "Credentials." Create "OAuth client ID" credentials for a "Web application." Copy your client ID and client secret. In n8n, add a new Google Analytics credential using the "OAuth2" authentication method. Provide the Client ID and Client Secret. You will need to authorize n8n to access your Google Analytics data. Scopes https://www.googleapis.com/auth/analytics.readonly (read-only) or https://www.googleapis.com/auth/analytics (manage) OAuth Redirect URL Already pre-filled by n8n (copy this when creating the Google client) Click Sign in with Google, choose the GA account, and approve the requested scopes. Click Save – n8n tests the token and stores it encrypted. For each yourwebsite.com node, select these credentials and specify the correct Google Analytics View ID (for Universal Analytics) or Property ID (for GA4). ► Email Credentials (SMTP): In n8n, add a new SMTP credential. Provide your SMTP host, port, username, and password. This will be used to send the aggregated reports. ► Slack Credentials: In n8n, add a new Slack credential. Follow the instructions to create a Slack App and generate a Bot User OAuth Token. This token will allow n8n to post messages to your Slack channels. ► OpenAI Credentials: Sign up for an OpenAI account (https://platform.openai.com/). Generate an API Key from your account dashboard. In n8n, add a new OpenAI credential and paste your API Key. ► Website Configuration: The workflow currently includes nodes for yourwebsite.com (1 to 8). For each "Get Report" node (e.g., yourwebsite.com, yourwebsite.com 2, etc.), duplicate or remove them as needed to match the number of Google Analytics properties you wish to monitor. Replace the names and number of websites inside the report maker agent. 🟡 Usage Once you have configured the credentials, you can customize the workflow to fit your specific needs, including leveraging various alternative nodes for sending notifications and reports. This flexibility allows you to integrate seamlessly with your preferred communication tools such as Gmail, Telegram, Outlook, or any other service supported by n8n's extensive node library.