Discord and Google Analytics integration

Overview Fetch Multiple Google Analytics GA4 metrics daily, post to Discord, update previous day’s entry as GA data finalizes over seven days. Benefits Automates daily traffic reporting Maintains single message per day, avoids channel clutter Provides near–real-time updates by editing prior messages Use Case Teams tracking website performance via Discord (or any chat tool) without manual copy–paste. Marketing managers, community moderators, growth hackers. If your manager asks you for daily marketing report every morning, you can now automate it Notes google analytics node in n8n does not provide real time data. The node updates previous values for the next 7 days discord node on n8n does not have features to update an exisiting message by message id. So we have used the discord api for this most businesses use multiple google analytics properties across their digital platforms Core Logic Schedule trigger fires once a day. Google Analytics node retrieves metrics for date ranges (past 7 days) Aggregate node collates all records. Discord node fetches the last 10 messages in the broadcast channel Code node maps existing Discord messages by to the google analytics data using the date fields For each GA record: If no message exists → send new POST to the discord channel If message exists and metrics changed, send an update patch to the existing discord message Batch loops + wait nodes prevent rate-limit. Setup Instructions Import workflow JSON into n8n. Follow the n8n guide to Create Google Analytics OAuth2 credential with access to all required GA accounts. Follow the n8n guide to Create Discord OAuth2 credential for “Get Messages” operations. Follow the Discord guide to Create HTTP Header Auth credential named “Discord-Bot” with header Key: Authorization Value: Bot <your-bot-token> In the two Set nodes in the beginning of the flow, assign discord_channel_id and google_analytics_id. Get your discord channel id by sending a text on your discord channel and then copy message link Paste the text below and you will see your message link in the form of https://discord.com/channels/server_id/channel_id/message_id , you will want to get the channel_id which is the number in the middle Find your google analytics id by going to google analytics dashboard, seeing the properties in the top right and copy paste that number to the flow Adjust schedule trigger times to your preferred report hour. Activate workflow. Customization Replace Discord HTTP Request nodes with Slack, ClickUp, WhatsApp, Telegram integrations by swapping POST/PATCH endpoints and authentication.

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