Track policy and meeting minutes acknowledgments with Gmail and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 18 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Gmail and Google Sheets.
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- Workflow Configuration (Edit Fields (Set)): sets 4 fields: publicBaseUrl, hmacSecret, apiSharedSecret…
- Route and Authorize Request (Switch): routes items into 3 branches
- Fan Out Audience (Split Out): splits a list into separate items
- Look Up Ledger Row (Data table): get
- Fetch Ledger Rows (Data table): get
- Respond Rejected Request (Respond to Webhook): sends the response back to the webhook caller
- Sign Recipient Token (Crypto): hashes or encrypts values
- Classify Ack Request (Switch): routes items into 2 branches
- Build Chase Table Page (Code): runs custom JavaScript code
- Record Ledger Row (Data table): uses Data table
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Split Out
n8n-nodes-base.splitOut - Crypto
n8n-nodes-base.crypto - Data table
n8n-nodes-base.dataTable - Gmail
n8n-nodes-base.gmail - Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code
From the author
Quick overview This workflow uses a single n8n webhook to email policy or meeting-minute links via Gmail, track per-recipient acknowledgments in an n8n Data Table, and mirror completed acknowledgments to Google Sheets, while also serving a secret-protected…