Archive Discord Audit Logs to Google Sheets + Weekly Slack Digests (n8n)

Archive Discord Audit Logs to Google Sheets + Auto-Post Weekly Slack Digests (n8n)

Keep a searchable record of your Discord server’s moderation activity by automatically archiving new Discord audit log entries into Google Sheets, then summarizing key trends in a weekly Slack digest—all powered by an n8n automation workflow.

What this workflow does

• Runs daily at 3 AM to fetch only audit log entries you haven’t archived yet.
• Loads configuration values such as Discord guild ID, Google Sheet URL, Slack channel, paging limits, and digest settings.
• Reads a stored “watermark” (last archived audit log entry ID) from an n8n Data Table.
• Calls the Discord API to retrieve new audit log entries after the watermark, paging through results up to your configured maximum.
• Converts Discord action type IDs into readable action names and resolves moderator/target names from the API’s users list.
• Appends rows to the audit_log tab in Google Sheets, then updates the stored watermark to the highest entry ID archived.
• On the configured weekday, it pulls recent rows from Google Sheets, computes top counts by moderator and by action for the lookback window, and posts the weekly digest to your chosen Slack channel.

Use cases

• Operational transparency for SaaS communities: track moderator actions with an auditable ledger.
• Weekly review for admins: spot which moderators take which actions most often.
• Compliance-style recordkeeping: maintain structured audit data in Google Sheets.

Technical details

• Discord (Audit Log): requires a bot with View Audit Log permission.
• Google Sheets: writes to the audit_log tab with columns such as entry_id, created_at, guild_id, action, moderator_name, reason, changed_keys, and archived_at.
• Slack: posts a weekly moderator/action summary.
• Built with n8n nodes including if, set, code, slack, data table, and sticky note.

Setup tip: Create your Discord bot, connect a Discord Bot API credential in n8n, and ensure your Google Sheet has an audit_log tab with the expected columns.