{"product_id":"gmail-invoice-auto-classification-with-openai-google-sheets-n8n","title":"Gmail Invoice Auto-Classification with OpenAI \u0026 Google Sheets (n8n)","description":"\u003ch3\u003eAuto-classify your Gmail invoices and book entries into Google Sheets—powered by OpenAI (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eGmail Invoice Auto-Classification with OpenAI \u0026amp; Google Sheets (n8n)\u003c\/strong\u003e workflow scans your inbox every hour, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to classify unread emails (sales, expense, settlement, transaction, notification, other), extracts key invoice\/payout fields, stores PDFs in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and logs everything into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—then labels and marks messages as read.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly\u003c\/strong\u003e: fetches all \u003cstrong\u003eunread Gmail\u003c\/strong\u003e messages on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies each email with OpenAI\u003c\/strong\u003e based on the email \u003cem\u003esubject and body\u003c\/em\u003e into:\n    sales, expense, settlement, transaction, notification, or other.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpense emails\u003c\/strong\u003e: extracts invoice fields (e.g., vendor, invoice number, GST split, amounts, and payment details). It also fetches any \u003cstrong\u003ePDF attachment\u003c\/strong\u003e from Gmail, uploads it to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and appends a linked row to the \u003cstrong\u003eExpense\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSales emails\u003c\/strong\u003e: extracts order details, generates an \u003cstrong\u003eHTML sales confirmation\u003c\/strong\u003e, renders it to PDF with \u003cstrong\u003ePDFBolt\u003c\/strong\u003e, uploads the PDF to Google Drive, and appends a linked row to the \u003cstrong\u003eSales\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSettlement emails\u003c\/strong\u003e: extracts payout details, uploads any PDF attachment to Google Drive, and appends a linked row to the \u003cstrong\u003eSettlement\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTransaction\/notification\/other\u003c\/strong\u003e: applies the corresponding \u003cstrong\u003eGmail label\u003c\/strong\u003e and marks the message as read.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling\u003c\/strong\u003e: on failures, an \u003cem\u003eerror trigger\u003c\/em\u003e uses OpenAI to translate the technical error, and alerts via \u003cstrong\u003eDiscord\u003c\/strong\u003e and Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically turn vendor invoice emails into structured rows for accounting visibility in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eTrack sales confirmations by generating and storing PDFs while keeping order data synchronized in Sheets.\u003c\/li\u003e\n  \u003cli\u003eCentralize settlement documentation (with PDFs) for easier monthly reconciliation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations\/nodes: \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eDiscord\u003c\/strong\u003e, \u003cstrong\u003ePDFBolt\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eFlow building blocks: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132892336307,"sku":"N8N-20154","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/NngQxSfUQKVd6zdTdS_Zp_mB9ItbS6.png?v=1790759953","url":"https:\/\/buyflowscripts.com\/products\/gmail-invoice-auto-classification-with-openai-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}