{"product_id":"gmail-invoice-pdf-extractor-openai-to-google-sheets-slack","title":"Gmail Invoice PDF Extractor: OpenAI to Google Sheets + Slack","description":"\u003ch3\u003eTurn Gmail PDF invoices into structured rows—and Slack alerts\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eGmail Invoice PDF Extractor\u003c\/strong\u003e n8n workflow automatically scans your \u003cstrong\u003eGmail\u003c\/strong\u003e inbox for unread emails with \u003cstrong\u003ePDF invoice attachments\u003c\/strong\u003e, extracts the invoice text, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to structure key fields, saves them to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and posts a concise summary to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors Gmail every minute\u003c\/strong\u003e for unread emails that include a \u003cstrong\u003ePDF attachment\u003c\/strong\u003e, downloads the attachment, and prepares it for extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts invoice text from the PDF\u003c\/strong\u003e into a single combined text output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI\u003c\/strong\u003e to extract structured invoice fields from the PDF text, including:\n    \u003cul\u003e\n      \u003cli\u003evendor\u003c\/li\u003e\n      \u003cli\u003einvoice number\u003c\/li\u003e\n      \u003cli\u003einvoice date\u003c\/li\u003e\n      \u003cli\u003edue date\u003c\/li\u003e\n      \u003cli\u003ecurrency\u003c\/li\u003e\n      \u003cli\u003etotal amount\u003c\/li\u003e\n      \u003cli\u003etax amount\u003c\/li\u003e\n      \u003cli\u003ea short summary\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdds metadata\u003c\/strong\u003e such as the sender email address (\u003cem\u003eemail_from\u003c\/em\u003e) and the current timestamp (\u003cem\u003ereceived_at\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends one new row per invoice\u003c\/strong\u003e to a selected \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e worksheet (e.g., columns: vendor, invoice_number, invoice_date, due_date, currency, total_amount, tax_amount, summary, email_from, received_at).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a formatted notification to Slack\u003c\/strong\u003e with the invoice details in a chosen channel (optional—can be disabled).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAccounts teams capturing invoice data from supplier emails without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators monitoring recurring billing invoices and receiving instant Slack alerts for new documents.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing inbound invoice intake pipelines using n8n + OpenAI + Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Gmail Trigger\u003c\/strong\u003e (runs every minute for unread emails with PDF attachments)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eextract from file\u003c\/strong\u003e to convert PDF content into text\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e to structure invoice fields from extracted text\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration to append rows to the specified spreadsheet\/worksheet\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e node to send a concise invoice summary\u003c\/li\u003e\n  \u003cli\u003eIncludes setup via \u003cstrong\u003eOAuth2\u003c\/strong\u003e for Gmail, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and \u003cstrong\u003eSlack\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916233367731,"sku":"N8N-18810","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0n23FyE5bRimRLz3pcxM_ZxAgW8fG.png?v=1788013237","url":"https:\/\/buyflowscripts.com\/products\/gmail-invoice-pdf-extractor-openai-to-google-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}