{"product_id":"n8n-workflow-send-quotes-invoices-from-google-sheets-via-gmail","title":"n8n Workflow: Send Quotes \u0026 Invoices from Google Sheets via Gmail","description":"\u003ch3\u003eSend quotes, invoices, and receipts from Google Sheets—automatically with Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your Google Sheets jobs tracker and, based on each row’s stage, generates the correct document PDF via Koutei and emails it through Gmail—also sending overdue invoice reminders and writing back delivery\/validation issues to the sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule:\u003c\/strong\u003e a manual trigger, every \u003cstrong\u003e30 minutes\u003c\/strong\u003e, and an additional run \u003cstrong\u003eevery morning at 9:00\u003c\/strong\u003e to handle reminder emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your Google Sheets tab:\u003c\/strong\u003e loads all rows, evaluates each row’s \u003cem\u003estage\u003c\/em\u003e and required fields, and decides whether to send a quote, deposit invoice, balance invoice, or receipt.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate sends:\u003c\/strong\u003e when a document is requested, it marks the row as \u003cstrong\u003e“Sending…”\u003c\/strong\u003e before processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates PDFs via Koutei:\u003c\/strong\u003e validates document data with Koutei, then requests the final PDF using an \u003cstrong\u003eidempotency key\u003c\/strong\u003e to avoid duplicate document creation on retries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends emails using Gmail:\u003c\/strong\u003e emails the generated PDF to the appropriate recipient in the correct mode (owner in preview mode; client in final mode).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates tracking in Google Sheets:\u003c\/strong\u003e writes back the new stage, totals, due date, email ID, and other status fields for auditing and workflow continuity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomated overdue reminders:\u003c\/strong\u003e on the daily reminder run, finds overdue deposit or balance invoices, re-downloads the \u003cstrong\u003eoriginal sent attachment\u003c\/strong\u003e from Gmail, and emails a reminder with the same PDF—updating reminder tracking fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling with visibility:\u003c\/strong\u003e if validation, PDF generation, emailing, or sheet updates fail, it records an actionable status note in the relevant row and emails the owner.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eYour operations team updates a “jobs” Google Sheet stage, and the system sends the right quote\/invoice\/receipt without manual steps.\u003c\/li\u003e\n  \u003cli\u003eInvoices that become overdue automatically trigger reminder emails using the original PDF attachment from Gmail.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers want reliable idempotency and traceable status notes when Koutei validation or Gmail delivery fails.\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 \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003ccode\u003efilter\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets for the jobs tracker, Gmail for sending and retrieving attachments, and Koutei for document generation and validation.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46289268506803,"sku":"N8N-21533","price":27.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/3FcIE7qVjrC3nSOkNdmDS_RAVjOXIO.png?v=1793006779","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-send-quotes-invoices-from-google-sheets-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}