{"product_id":"cma-merger-case-timeline-automation-gov-uk-sheets-email","title":"CMA Merger Case Timeline Automation (GOV.UK → Sheets + Email)","description":"\u003ch3\u003eAutomate CMA merger case timelines from GOV.UK straight into Google Sheets—plus an emailed HTML report\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eCMA Merger Case Timeline Automation (GOV.UK → Sheets + Email)\u003c\/strong\u003e workflow pulls Competition and Markets Authority (CMA) merger case updates from \u003cstrong\u003eGOV.UK\u003c\/strong\u003e, extracts dated milestones into a \u003cstrong\u003eGoogle Sheets Timeline\u003c\/strong\u003e, and generates an \u003cstrong\u003eemail-friendly summary\u003c\/strong\u003e with an attached \u003cstrong\u003e.html timeline report\u003c\/strong\u003e via \u003cstrong\u003eSMTP\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 demand\u003c\/strong\u003e or on \u003cstrong\u003eweekday mornings at 08:00 (workflow timezone)\u003c\/strong\u003e (Monday–Friday).\u003c\/li\u003e\n  \u003cli\u003eBuilds a list of \u003cstrong\u003eGOV.UK CMA case API URLs\u003c\/strong\u003e from your configured case paths, validating uniqueness and format.\u003c\/li\u003e\n  \u003cli\u003eFetches each case’s \u003cstrong\u003eGOV.UK JSON\u003c\/strong\u003e content and extracts \u003cstrong\u003edated milestones\u003c\/strong\u003e from:\n    \u003cul\u003e\n      \u003cli\u003echange history,\u003c\/li\u003e\n      \u003cli\u003eattachments, and\u003c\/li\u003e\n      \u003cli\u003edated HTML entries—marking \u003cstrong\u003edeadlines as planned\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eCreates a status row per case, including \u003cstrong\u003eparse errors\u003c\/strong\u003e or \u003cstrong\u003e“needs review”\u003c\/strong\u003e flags, and generates stable `Row Key` values for upserts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts\u003c\/strong\u003e status and milestone rows into the Sheets \u003cstrong\u003e“Timeline”\u003c\/strong\u003e tab using the \u003cstrong\u003eRow Key\u003c\/strong\u003e column to update existing entries \u003cem\u003ewithout deleting history\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eGenerates an \u003cstrong\u003eHTML email digest\u003c\/strong\u003e and a \u003cstrong\u003efull HTML timeline report\u003c\/strong\u003e, then prepares it as an attached \u003cstrong\u003e.html\u003c\/strong\u003e file for sending via SMTP (when enabled).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack CMA merger milestones for your team’s internal schedule directly from GOV.UK updates.\u003c\/li\u003e\n  \u003cli\u003eMaintain a continuously updated timeline in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eSend stakeholders a consistent weekly email report with an attached HTML timeline.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e used include: \u003cstrong\u003eSet\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and \u003cstrong\u003eEmail Send (SMTP)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSetup requires a Google Sheet with a \u003cstrong\u003e“Timeline”\u003c\/strong\u003e tab and exact headers (including \u003cstrong\u003eRow Key\u003c\/strong\u003e) from the “Google Sheets Headers and First Run” sticky note.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46160841113779,"sku":"N8N-20424","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ccwJLUw9TBBvcyZTME67N_GzkVvEZD.png?v=1791191023","url":"https:\/\/buyflowscripts.com\/products\/cma-merger-case-timeline-automation-gov-uk-sheets-email","provider":"N8N Commerce","version":"1.0","type":"link"}