{"product_id":"n8n-policy-meeting-minutes-acknowledgements-tracker-gmail-sheets","title":"n8n Policy \u0026 Meeting Minutes Acknowledgements Tracker (Gmail+Sheets)","description":"\u003ch3\u003eAutomated policy \u0026amp; meeting-minute acknowledgements—sent by Gmail, tracked in n8n, and mirrored to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow sends each recipient a unique acknowledgment link for a policy or meeting minutes, records who has confirmed in an n8n Data Table, updates a Google Sheets “Ack Log,” and provides a secret-protected HTML status page showing who’s still outstanding.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives requests via a single n8n webhook\u003c\/strong\u003e on \u003ccode\u003e\/policy-ack-tracker\u003c\/code\u003e and routes by the request \u003ccode\u003eaction\u003c\/code\u003e parameter.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDistributes acknowledgements securely (action=distribute)\u003c\/strong\u003e by splitting the provided audience email list into individual recipients.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates per-recipient tokens\u003c\/strong\u003e using \u003cstrong\u003eHMAC-SHA256\u003c\/strong\u003e derived from the document ID and recipient email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates one pending ledger record per person\u003c\/strong\u003e in the n8n Data Table “Policy Ack Ledger,” then sends a \u003cstrong\u003eGmail\u003c\/strong\u003e message containing the document link and each recipient’s unique acknowledgment URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents link-scanner false records (action=ack)\u003c\/strong\u003e by validating docId + email + token, then serving a confirmation landing page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecords confirmations (confirm=yes)\u003c\/strong\u003e by updating the ledger row to \u003cem\u003eacknowledged\u003c\/em\u003e with a timestamp, appending to the Google Sheets \u003cstrong\u003e“Ack Log”\u003c\/strong\u003e, and returning a confirmation page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDisplays live completion status (action=status)\u003c\/strong\u003e via a \u003cstrong\u003esecret-protected HTML status page\u003c\/strong\u003e grouped by document, including outstanding recipients and completion counts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend new compliance policies and track acknowledgements across teams.\u003c\/li\u003e\n  \u003cli\u003eCollect meeting-minute confirmations after leadership or governance sessions.\u003c\/li\u003e\n  \u003cli\u003eProvide auditors an at-a-glance status page and a row-level audit log 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\u003eWebhook routing\u003c\/strong\u003e: \u003ccode\u003eaction=distribute\u003c\/code\u003e, \u003ccode\u003eack\u003c\/code\u003e, \u003ccode\u003estatus\u003c\/code\u003e, with shared secret enforcement for sensitive requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSecurity\u003c\/strong\u003e: HMAC-SHA256 token generation and validation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n components\u003c\/strong\u003e: \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003ecrypto\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e, \u003ccode\u003ewebhook\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage\u003c\/strong\u003e: n8n Data Table “Policy Ack Ledger,” mirrored to Google Sheets “Ack Log.”\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSetup requires environment variables such as \u003ccode\u003ePUBLIC_BASE_URL\u003c\/code\u003e, \u003ccode\u003eHMAC_SECRET\u003c\/code\u003e, \u003ccode\u003eAPI_SHARED_SECRET\u003c\/code\u003e, and \u003ccode\u003eACK_LOG_SH\u003c\/code\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837455065267,"sku":"N8N-18263","price":60.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Ds7JTM1wnNLfJOSWe2kX3_RVWn3FaU.png?v=1786794500","url":"https:\/\/buyflowscripts.com\/products\/n8n-policy-meeting-minutes-acknowledgements-tracker-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}