{"product_id":"n8n-workflow-email-pdf-invoices-from-google-sheets-orshot-gmail","title":"n8n Workflow: Email PDF Invoices from Google Sheets (Orshot + Gmail)","description":"\u003ch3\u003eAutomatically email PDF invoices from Google Sheets—every 15 minutes\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically finds invoices marked \u003cstrong\u003eReady\u003c\/strong\u003e in your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculates totals from matching line items, renders a professional \u003cstrong\u003ePDF invoice\u003c\/strong\u003e with \u003cstrong\u003eOrshot\u003c\/strong\u003e, emails it via \u003cstrong\u003eGmail\u003c\/strong\u003e, saves a copy to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and writes delivery status + links back into 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 a schedule\u003c\/strong\u003e every 15 minutes to process new invoices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads invoice rows\u003c\/strong\u003e from your Invoices sheet where the \u003cstrong\u003eStatus\u003c\/strong\u003e column is set to \u003cstrong\u003eReady\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads line items\u003c\/strong\u003e from a second sheet and \u003cstrong\u003ematches by invoice number\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates totals\u003c\/strong\u003e (subtotal\/tax\/total) and determines the \u003cstrong\u003edue date\u003c\/strong\u003e. If required data is missing or invalid, the workflow flags the invoice as \u003cstrong\u003eError\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRenders a PDF\u003c\/strong\u003e using an \u003cstrong\u003eOrshot Studio template\u003c\/strong\u003e populated with the calculated invoice fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the PDF\u003c\/strong\u003e to the client using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads the PDF\u003c\/strong\u003e to a chosen \u003cstrong\u003eGoogle Drive folder\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e with \u003cstrong\u003eSent\u003c\/strong\u003e or \u003cstrong\u003eError\u003c\/strong\u003e status, timestamps, and the \u003cstrong\u003eOrshot PDF\u003c\/strong\u003e + \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e links.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend invoices automatically when an order is finalized and marked \u003cem\u003eReady\u003c\/em\u003e in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eGenerate consistent invoice PDFs for recurring SaaS billing or service businesses without manual formatting.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable record by storing every PDF in Google Drive and tracking status in the same spreadsheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eScheduling: runs every \u003cstrong\u003e15 minutes\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eOrshot\u003c\/strong\u003e (Studio template + API key), \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic\/nodes referenced: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup (high level)\u003c\/h3\u003e\n\u003cp\u003eAdd your invoice template to your \u003cstrong\u003eOrshot\u003c\/strong\u003e workspace, configure Orshot API credentials, connect Google Sheets (Invoices + Line items sheet names and Spreadsheet ID), then set \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e credentials and the destination folder for uploaded PDFs.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244508401843,"sku":"N8N-21163","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/1ucs849i7jGVg9pZkhXLV_5kZ6y5W3.png?v=1792400991","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-email-pdf-invoices-from-google-sheets-orshot-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}