{"product_id":"n8n-workflow-paid-order-invoices-pick-lists-via-gmail","title":"n8n Workflow: Paid Order Invoices \u0026 Pick Lists via Gmail","description":"\u003ch3\u003eAutomatically send paid order invoices via Gmail—and push pick lists to Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow triggers when an order is paid, generates a PDF invoice and an Excel pick list using Cloud Office Print, emails the invoice through Gmail, archives it in Google Drive, and notifies Slack with low-stock warnings.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives payment events:\u003c\/strong\u003e Listens for a \u003cem\u003ePOST webhook\u003c\/em\u003e containing an \u003ccode\u003eorder_id\u003c\/code\u003e secured with header authentication.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls order + customer data:\u003c\/strong\u003e Fetches the order from your shop API, then retrieves each product’s SKU\/stock\/weight and loads the related customer record.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds invoice and fulfillment data:\u003c\/strong\u003e Computes totals and tax from the combined order information and flags \u003cem\u003elow-stock\u003c\/em\u003e items for visibility in the pick list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a PDF invoice from templates:\u003c\/strong\u003e Downloads a Word invoice template from \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e and uses \u003cstrong\u003eCloud Office Print\u003c\/strong\u003e to produce a PDF invoice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends invoice by email:\u003c\/strong\u003e Emails the generated PDF invoice to the customer via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack alerting + pick list delivery:\u003c\/strong\u003e If sending fails, \u003cstrong\u003eSlack\u003c\/strong\u003e is alerted. Otherwise, Slack receives the filled pick list, including low-stock warnings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eArchives the invoice:\u003c\/strong\u003e Uploads the PDF invoice to a specified \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e archive folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinalizes fulfillment:\u003c\/strong\u003e Downloads an Excel pick-list template from Google Drive, fills it via Cloud Office Print, posts it to Slack, and updates the shop API marking the order as invoiced.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFor e-commerce teams that need \u003cstrong\u003einstant invoice delivery\u003c\/strong\u003e after payment.\u003c\/li\u003e\n  \u003cli\u003eWarehouses that want \u003cstrong\u003eSlack-based pick list updates\u003c\/strong\u003e and \u003cstrong\u003elow-stock warnings\u003c\/strong\u003e without manual spreadsheet work.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators standardizing invoice\/pick-list generation with \u003cstrong\u003eGoogle Drive templates\u003c\/strong\u003e and automated record updates in the shop API.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/integrations: \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIncludes \u003cstrong\u003eCloud Office Print\u003c\/strong\u003e node setup via \u003cem\u003en8n-nodes-cloudofficeprint\u003c\/em\u003e and an API key credential.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Drive OAuth\u003c\/strong\u003e to fetch DOCX\/XLSX templates and to archive generated invoices.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46042472186035,"sku":"N8N-19627","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/wU1mRMrSHgEFUWN0Qsq9A_CWruUu5z.png?v=1789549824","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-paid-order-invoices-pick-lists-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}