{"product_id":"n8n-monthly-google-sheets-invoice-pdfs-gmail-drive-slack","title":"n8n Monthly Google Sheets Invoice PDFs: Gmail, Drive \u0026 Slack","description":"\u003ch3\u003eAutomatically generate monthly Google Sheets invoice PDFs, archive them to Drive, email via Gmail, and notify Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads billable line items from your Google Sheets every month, creates one PDF invoice per client using Emitforge, stores each PDF in Google Drive, emails it to clients through Gmail, and posts a Slack summary for every invoice—fully automated, schedule-based, and audit-friendly.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns monthly on the 1st\u003c\/strong\u003e to process the previous month’s billable rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads invoice defaults\u003c\/strong\u003e (company name, tax rate, and payment terms) and reads line items from Google Sheets (e.g., \u003cem\u003eclient\u003c\/em\u003e, \u003cem\u003eclient_email\u003c\/em\u003e, \u003cem\u003edescription\u003c\/em\u003e, \u003cem\u003eqty\u003c\/em\u003e, \u003cem\u003eunit_price\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroups rows by client\u003c\/strong\u003e, then calculates subtotals, tax, and totals for each client’s invoice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds an invoice HTML table\u003c\/strong\u003e for each client and sends it to the \u003cstrong\u003eEmitforge PDF API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetrieves a signed URL\u003c\/strong\u003e for the rendered PDF, downloads it, and \u003cstrong\u003earchives the PDF to Google Drive\u003c\/strong\u003e in your selected folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the invoice PDF to each client\u003c\/strong\u003e using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a per-invoice message to Slack\u003c\/strong\u003e including invoice number, client, total, and line count.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eService businesses invoicing multiple clients from a shared Google Sheets timesheet or billing tracker.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want monthly recurring invoices without manually exporting PDFs.\u003c\/li\u003e\n  \u003cli\u003eTeams that need a consistent workflow: generate → store → email → Slack notify, all from Google Sheets data.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduler\u003c\/strong\u003e: runs on the \u003cstrong\u003e1st of each month\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes\u003c\/strong\u003e: \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003egoogle drive\u003c\/strong\u003e, and supporting elements like a \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePDF generation\u003c\/strong\u003e: \u003cstrong\u003eEmitforge PDF API\u003c\/strong\u003e (configured via HTTP Header Auth, e.g., \u003cem\u003eAuthorization: Bearer \u0026lt;API_KEY\u0026gt;\u003c\/em\u003e)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938244911283,"sku":"N8N-19015","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/VNap8fURLJVkl0lYYxk-h_TaO7qFgd.png?v=1788340707","url":"https:\/\/buyflowscripts.com\/products\/n8n-monthly-google-sheets-invoice-pdfs-gmail-drive-slack","provider":"N8N Commerce","version":"1.0","type":"link"}