{"product_id":"n8n-weekly-google-sheets-topics-digest-to-slack-channel","title":"n8n Weekly Google Sheets Topics Digest to Slack Channel","description":"\u003ch3\u003eGet a weekly Google Sheets “Topics” snapshot in Slack—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your Google Sheets \u003cstrong\u003eTopics\u003c\/strong\u003e tab every Monday and posts a concise weekly digest to a chosen \u003cstrong\u003eSlack\u003c\/strong\u003e channel, including status totals and the \u003cstrong\u003elast five topics\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 on a schedule:\u003c\/strong\u003e executes every Monday at \u003cstrong\u003e09:00 (Asia\/Jerusalem)\u003c\/strong\u003e (or you can start it manually for testing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration:\u003c\/strong\u003e pulls the Google Sheets document ID, the \u003cstrong\u003eTopics\u003c\/strong\u003e tab name, and the \u003cstrong\u003eSlack channel ID\u003c\/strong\u003e from your n8n settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads the full topic queue:\u003c\/strong\u003e fetches all rows from the specified Google Sheets tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates status counts:\u003c\/strong\u003e summarizes totals by topic status, including \u003cstrong\u003epending\u003c\/strong\u003e, \u003cstrong\u003eapproved\u003c\/strong\u003e, \u003cstrong\u003erejected\u003c\/strong\u003e, \u003cstrong\u003edrafting\u003c\/strong\u003e, and any \u003cstrong\u003eother\u003c\/strong\u003e statuses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats “last 5 topics”:\u003c\/strong\u003e builds a list showing the most recent five topics for quick review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Slack:\u003c\/strong\u003e sends the weekly digest message to your configured Slack channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContent operations:\u003c\/strong\u003e keep editors and managers updated on topic pipeline progress without manually checking Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApproval workflows:\u003c\/strong\u003e monitor how many topics are pending approval or rejected each week.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTeam visibility:\u003c\/strong\u003e share a consistent weekly summary with stakeholders in Slack for faster triage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operations:\u003c\/strong\u003e track internal backlog items using a simple Google Sheets queue.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e cron-based weekly trigger (Monday 09:00 Asia\/Jerusalem) with optional manual trigger for testing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e reads all rows from a “Topics” tab (requires columns including \u003cstrong\u003etopic\u003c\/strong\u003e and \u003cstrong\u003estatus\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack:\u003c\/strong\u003e posts the formatted weekly digest to the specified Slack channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003egoogle sheets\u003c\/strong\u003e, \u003cstrong\u003emanual trigger\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup (quick overview)\u003c\/h3\u003e\n\u003cp\u003eCreate\/select a Google Sheets spreadsheet with a \u003cstrong\u003eTopics\u003c\/strong\u003e 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45945727189171,"sku":"N8N-19079","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/wfggZeNyXdtnGuY3HKeEf_ewHI3Vrs.png?v=1788426940","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-google-sheets-topics-digest-to-slack-channel","provider":"N8N Commerce","version":"1.0","type":"link"}