Track CMA merger case timelines with GOV.UK, Google Sheets and email
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 10 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Set Email and Sheet Config (Edit Fields (Set)): sets 5 fields: spreadsheetId, sheetName, senderEmail…
- Prepare API Case Requests (Code): runs custom JavaScript code
- Fetch GOV UK Case Details (HTTP Request): calls an HTTP API
- Extract Case Milestones (Code): runs custom JavaScript code
- Upsert Sheets Timeline Rows (Google Sheets): append or update
- Build Timeline Summary Report (Code): runs custom JavaScript code
- Format Timeline as HTML (Code): runs custom JavaScript code
- Email Timeline Digest (Send Email): sends an email over SMTP
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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Send Email
n8n-nodes-base.emailSend
From the author
Quick overview This workflow runs on demand or on weekday mornings to pull Competition and Markets Authority (CMA) merger case updates from GOV.UK, write a dated timeline into Google Sheets, and generate an email-friendly summary plus an attached HTML…