{"product_id":"archive-discord-audit-logs-to-google-sheets-weekly-slack-digests-n8n","title":"Archive Discord Audit Logs to Google Sheets + Weekly Slack Digests (n8n)","description":"\u003ch3\u003eArchive Discord Audit Logs to Google Sheets + Auto-Post Weekly Slack Digests (n8n)\u003c\/h3\u003e\n\u003cp\u003eKeep a searchable record of your Discord server’s moderation activity by automatically archiving new \u003cstrong\u003eDiscord audit log entries\u003c\/strong\u003e into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then summarizing key trends in a \u003cstrong\u003eweekly Slack digest\u003c\/strong\u003e—all powered by an \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e at \u003cstrong\u003e3 AM\u003c\/strong\u003e to fetch only audit log entries you haven’t archived yet.\u003c\/li\u003e\n  \u003cli\u003eLoads configuration values such as \u003cstrong\u003eDiscord guild ID\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheet URL\u003c\/strong\u003e, \u003cstrong\u003eSlack channel\u003c\/strong\u003e, paging limits, and digest settings.\u003c\/li\u003e\n  \u003cli\u003eReads a stored “watermark” (\u003cstrong\u003elast archived audit log entry ID\u003c\/strong\u003e) from an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalls the \u003cstrong\u003eDiscord API\u003c\/strong\u003e to retrieve \u003cstrong\u003enew audit log entries\u003c\/strong\u003e after the watermark, paging through results up to your configured maximum.\u003c\/li\u003e\n  \u003cli\u003eConverts Discord \u003cstrong\u003eaction type IDs\u003c\/strong\u003e into readable action names and resolves moderator\/target names from the API’s users list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends rows\u003c\/strong\u003e to the \u003cstrong\u003eaudit_log\u003c\/strong\u003e tab in Google Sheets, then updates the stored watermark to the highest entry ID archived.\u003c\/li\u003e\n  \u003cli\u003eOn the configured weekday, it pulls recent rows from Google Sheets, computes \u003cstrong\u003etop counts by moderator\u003c\/strong\u003e and \u003cstrong\u003eby action\u003c\/strong\u003e for the lookback window, and posts the \u003cstrong\u003eweekly digest\u003c\/strong\u003e to your chosen \u003cstrong\u003eSlack\u003c\/strong\u003e channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOperational transparency for SaaS communities: track moderator actions with an auditable ledger.\u003c\/li\u003e\n  \u003cli\u003eWeekly review for admins: spot which moderators take which actions most often.\u003c\/li\u003e\n  \u003cli\u003eCompliance-style recordkeeping: maintain structured audit data in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDiscord\u003c\/strong\u003e (Audit Log): requires a bot with \u003cstrong\u003eView Audit Log\u003c\/strong\u003e permission.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: writes to the \u003cstrong\u003eaudit_log\u003c\/strong\u003e tab with columns such as entry_id, created_at, guild_id, action, moderator_name, reason, changed_keys, and archived_at.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: posts a weekly moderator\/action summary.\u003c\/li\u003e\n  \u003cli\u003eBuilt with n8n nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003edata table\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Create your Discord bot, connect a Discord Bot API credential in n8n, and ensure your Google Sheet has an \u003cstrong\u003eaudit_log\u003c\/strong\u003e tab with the expected columns.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761014169779,"sku":"N8N-17808","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MFJApSjWyAUBJeEHl-qup_qhsthJxS.png?v=1785921511","url":"https:\/\/buyflowscripts.com\/products\/archive-discord-audit-logs-to-google-sheets-weekly-slack-digests-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}