n8n Weekly Google Sheets Topics Digest to Slack Channel

Get a weekly Google Sheets “Topics” snapshot in Slack—automatically

This n8n workflow reads your Google Sheets Topics tab every Monday and posts a concise weekly digest to a chosen Slack channel, including status totals and the last five topics.

What this workflow does

• Runs on a schedule: executes every Monday at 09:00 (Asia/Jerusalem) (or you can start it manually for testing).
• Loads configuration: pulls the Google Sheets document ID, the Topics tab name, and the Slack channel ID from your n8n settings.
• Reads the full topic queue: fetches all rows from the specified Google Sheets tab.
• Calculates status counts: summarizes totals by topic status, including pending, approved, rejected, drafting, and any other statuses.
• Formats “last 5 topics”: builds a list showing the most recent five topics for quick review.
• Posts to Slack: sends the weekly digest message to your configured Slack channel.

Use cases

• Content operations: keep editors and managers updated on topic pipeline progress without manually checking Sheets.
• Approval workflows: monitor how many topics are pending approval or rejected each week.
• Team visibility: share a consistent weekly summary with stakeholders in Slack for faster triage.
• SaaS operations: track internal backlog items using a simple Google Sheets queue.

Technical details

• Scheduling: cron-based weekly trigger (Monday 09:00 Asia/Jerusalem) with optional manual trigger for testing.
• Google Sheets: reads all rows from a “Topics” tab (requires columns including topic and status).
• Slack: posts the formatted weekly digest to the specified Slack channel.
• n8n nodes used: set, code, slack, sticky note, google sheets, manual trigger.

Setup (quick overview)

Create/select a Google Sheets spreadsheet with a Topics tab, add OAuth2 credentials in n8n, update the spreadsheet ID, then add Slack credentials and set the Slack channel ID where the digest should be posted.