Discord daily digest for multiple Google Analytics accounts

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

1. Schedule trigger fires once a day. 2. Google Analytics node retrieves metrics for date ranges (past 7 days) 3. Aggregate node collates all records. 4. Discord node fetches the last 10 messages in the broadcast channel 5. Code node maps existing Discord messages by to the google analytics data using the date fields 5. For each GA record: 1. If no message exists → send new POST to the discord channel 2. If message exists and metrics changed, send an update patch to the existing discord message 8. Batch loops + wait nodes prevent rate-limit.

Setup Instructions

1. Import workflow JSON into n8n. 2. [Follow the n8n guide to Create Google Analytics OAuth2 credential](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googleanalytics) with access to all required GA accounts. 3. [Follow the n8n guide to Create Discord OAuth2 credential](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.discord) for “Get Messages” operations. 4. [Follow the Discord guide to Create HTTP Header Auth credential](https://discord.com/developers/docs/reference) named “Discord-Bot” with header