{"product_id":"n8n-discord-help-digest-log-unanswered-questions-to-google-sheets","title":"n8n Discord Help Digest: Log Unanswered Questions to Google Sheets","description":"\u003ch3\u003eFind unanswered Discord help questions automatically—then log them in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eIf you run an n8n-powered community support channel, this workflow scans your Discord help channel daily for likely questions that haven’t been answered yet, sends a digest to your moderators, and appends each unanswered question (with jump links) to a Google Sheets log.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on a schedule:\u003c\/b\u003e executes every day at \u003cb\u003e09:00\u003c\/b\u003e to perform the scan.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads configuration:\u003c\/b\u003e reads Discord server\/channel IDs, a lookback window, and the Google Sheets destination.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eScans recent messages:\u003c\/b\u003e fetches the most recent messages from your specified Discord help channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDetects questions and filters answered items:\u003c\/b\u003e identifies messages that look like questions within the lookback window, then filters out cases that were replied to, received a later mention of the asker, or have an associated thread.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eComputes coverage notes:\u003c\/b\u003e includes a coverage note if message retrieval appears incomplete.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePosts to moderator Discord:\u003c\/b\u003e if unanswered questions exist, it posts a digest with \u003cb\u003ejump links\u003c\/b\u003e; otherwise, it posts an \u003cb\u003e“all clear”\u003c\/b\u003e scan receipt with the coverage note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs to Google Sheets:\u003c\/b\u003e appends each unanswered question as a new row in the configured Google Sheets tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n communities that want moderators to quickly triage unanswered help requests.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who manage support in Discord and need a searchable audit trail.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want reliable “question coverage” visibility across a lookback window.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e n8n \u003cb\u003eDiscord\u003c\/b\u003e nodes for reading help messages and posting moderator digests; \u003cb\u003eGoogle Sheets\u003c\/b\u003e (OAuth2) for logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBot setup:\u003c\/b\u003e create a Discord bot credential, grant \u003cb\u003eView Channel\u003c\/b\u003e\/\u003cb\u003eRead Message History\u003c\/b\u003e on the help channel and \u003cb\u003eSend Messages\u003c\/b\u003e on the moderator channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRequired Discord permissions:\u003c\/b\u003e enable the bot’s \u003cb\u003eMessage Content privileged intent\u003c\/b\u003e to evaluate question text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWorkflow logic:\u003c\/b\u003e uses nodes including \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003ediscord\u003c\/b\u003e, \u003cb\u003esplit out\u003c\/b\u003e, and \u003cb\u003esticky note\u003c\/b\u003e to implement filtering, digest formatting, and Google Sheets appends.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741408714931,"sku":"N8N-17613","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MYsVcUX1i2A0OGya81kVL_PmCNQIb9.png?v=1785315880","url":"https:\/\/buyflowscripts.com\/products\/n8n-discord-help-digest-log-unanswered-questions-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}