{"product_id":"n8n-workflow-sequential-pdf-invoices-from-google-sheets","title":"n8n Workflow: Sequential PDF Invoices from Google Sheets","description":"\u003ch3\u003eAutomatically generate, number, and email gapless PDF invoices from your Google Sheets ledger\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Google Sheets invoice ledger every 15 minutes, verifies sequential \u003cstrong\u003eInvoice No\u003c\/strong\u003e numbering with no gaps or duplicates, fills a Google Docs invoice template, exports it to a PDF from Google Drive, and emails it to customers via Gmail—while updating each row status as it goes.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every 15 minutes\u003c\/strong\u003e and reads all rows from your Google Sheets invoice spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAudits Invoice No sequences\u003c\/strong\u003e to ensure each series is sequential with \u003cem\u003eno gaps, duplicates, or invalid formats\u003c\/em\u003e. If issues are detected, processing stops.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an alert email via Gmail\u003c\/strong\u003e listing numbering problems so you can correct the ledger immediately.\u003c\/li\u003e\n  \u003cli\u003eFor rows marked \u003cstrong\u003eStatus = Ready\u003c\/strong\u003e (and missing invoice numbers), it calculates \u003cstrong\u003esubtotal, tax, and total\u003c\/strong\u003e, validates required fields, and either:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eReserves the next sequential invoice number\u003c\/strong\u003e by writing \u003cem\u003eInvoice No\u003c\/em\u003e, \u003cem\u003eIssued at\u003c\/em\u003e, \u003cem\u003eTotal\u003c\/em\u003e, and \u003cem\u003eNumbered\u003c\/em\u003e back to Google Sheets, or\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eFlags the row as incomplete\u003c\/strong\u003e with \u003cem\u003eNeeds details\u003c\/em\u003e and the validation reason—without consuming an invoice number.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates the invoice PDF\u003c\/strong\u003e: copies a Google Docs invoice template from Google Drive, replaces placeholders with invoice data, exports it as a PDF, and emails it as an attachment via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates status to Sent\u003c\/strong\u003e in Google Sheets and stores a link to the generated document.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn a Google Sheets ledger into a reliable, sequential invoice system with automated PDF delivery.\u003c\/li\u003e\n  \u003cli\u003ePrevent numbering mistakes by enforcing gapless Invoice No sequences and alerting on ledger inconsistencies.\u003c\/li\u003e\n  \u003cli\u003eHandle “Ready” invoices continuously without manual template editing or export steps.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow category:\u003c\/strong\u003e n8n automation workflow\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ integrations:\u003c\/strong\u003e \u003cem\u003eif, code, gmail, google docs, sticky note, google drive\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e connect \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eGoogle Docs\u003c\/strong\u003e, and \u003cstrong\u003eGmail credentials\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46094092140723,"sku":"N8N-19952","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Lgl9QbY23aU7K7QOSvu73_fnDGktPx.png?v=1790413458","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-sequential-pdf-invoices-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}