{"product_id":"n8n-workflow-draft-case-study-one-pagers-from-google-sheets-email","title":"n8n Workflow: Draft Case Study One-Pagers from Google Sheets \u0026 Email","description":"\u003ch3\u003eAutomatically draft case-study one-pagers from Google Sheets—and route review + client approvals via email\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs daily to detect newly \u003cstrong\u003eClosed Won\u003c\/strong\u003e deals in Google Sheets, match them with results, generate a \u003cstrong\u003ecase study one-pager draft\u003c\/strong\u003e, and send the right \u003cstrong\u003einternal review\u003c\/strong\u003e and \u003cstrong\u003eclient sign-off\u003c\/strong\u003e emails—with an optional compliance\/audit check and reminders for overdue reviews.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily deal detection:\u003c\/strong\u003e On a schedule, it reads a \u003cstrong\u003eGoogle Sheets Deals Tracker\u003c\/strong\u003e to find newly marked “Closed Won” deals, deduplicating anything already processed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResults matching:\u003c\/strong\u003e It then checks a \u003cstrong\u003eGoogle Sheets Results Tracker\u003c\/strong\u003e and matches by deal ID to pull before\/after metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInternal reviewer request (missing metrics):\u003c\/strong\u003e If no results entry exists, the workflow emails an internal reviewer requesting the missing metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOne-pager drafting (metrics found):\u003c\/strong\u003e When metrics exist, it calculates the strongest headline metric and assembles a draft case-study summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLedger logging + review routing:\u003c\/strong\u003e The draft and metadata are appended to a \u003cstrong\u003eGoogle Sheets Case Studies ledger\u003c\/strong\u003e, an internal review request email is sent, and the message is logged via an executed \u003cstrong\u003ecompliance\/audit\u003c\/strong\u003e sub-workflow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClient sign-off workflow (suppression supported):\u003c\/strong\u003e It builds a client approval request, runs it through the executed compliance check sub-workflow, and sends (or suppresses) the client email depending on approval.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReminder nudges:\u003c\/strong\u003e A separate daily scheduled branch checks for drafts pending review beyond a threshold and sends reminder emails to the internal reviewer.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eUpdate your marketing pipeline whenever sales deals move to \u003cem\u003eClosed Won\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eStandardize case-study drafting for SaaS operators and automation engineers using Google Sheets as the source of truth.\u003c\/li\u003e\n  \u003cli\u003eEnsure review and client communications follow a consistent compliance\/audit path.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (Deals Tracker, Results Tracker, Case Studies ledger) and email sending.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic shown:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eno op\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003eemail send\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, plus an executed compliance\/audit sub-workflow.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45974323658931,"sku":"N8N-19284","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RFIoi3fpJyeRmto0SXvX2_77wJtxdV.png?v=1788772487","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-draft-case-study-one-pagers-from-google-sheets-email","provider":"N8N Commerce","version":"1.0","type":"link"}