{"product_id":"gmail-pdf-invoice-extractor-to-google-sheets-telegram-alerts-n8n","title":"Gmail PDF Invoice Extractor to Google Sheets + Telegram Alerts (n8n)","description":"\u003ch3\u003eTurn Gmail invoice PDFs into clean Google Sheets rows—automatically, with Telegram alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your \u003cstrong\u003eGmail\u003c\/strong\u003e for unread emails with \u003cstrong\u003ePDF invoice attachments\u003c\/strong\u003e, extracts key invoice fields from the PDF text, checks for duplicates in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and uses \u003cstrong\u003eTelegram\u003c\/strong\u003e to flag issues like duplicates or unreadable invoices.\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 and searches Gmail for \u003cstrong\u003eunread\u003c\/strong\u003e emails containing \u003cstrong\u003ePDF attachments\u003c\/strong\u003e, then downloads the attachment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts invoice data from the PDF\u003c\/strong\u003e by parsing the PDF text to identify supplier, invoice number, dates, totals, VAT details, and currency—handling both \u003cstrong\u003eUK and EU number formats\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects incomplete invoices\u003c\/strong\u003e: if required fields can’t be read, it sends a \u003cstrong\u003eTelegram message\u003c\/strong\u003e listing what couldn’t be extracted and stops without writing to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates\u003c\/strong\u003e: reads existing rows from the \u003cstrong\u003eInvoices\u003c\/strong\u003e sheet in Google Sheets and compares against the parsed invoice using \u003cstrong\u003esupplier + invoice number + total\u003c\/strong\u003e as the matching key.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles duplicates safely\u003c\/strong\u003e: if a duplicate is found, it sends a Telegram alert explaining which invoice was blocked and \u003cstrong\u003edoes not append\u003c\/strong\u003e a new row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends valid invoices\u003c\/strong\u003e: when the invoice is complete and non-duplicate, it formats a single clean record and \u003cstrong\u003eadds it to the Invoices sheet\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAccounts teams who receive monthly vendor invoices via email and want structured \u003cstrong\u003einvoice tracking\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators consolidating vendor spend data while getting real-time \u003cstrong\u003eTelegram alerts\u003c\/strong\u003e for duplicates or parsing failures.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing a practical \u003cstrong\u003eGmail → PDF parsing → Google Sheets\u003c\/strong\u003e pipeline with safeguards.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/stack used\u003c\/strong\u003e: \u003cem\u003eGmail Trigger\u003c\/em\u003e, \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003etelegram\u003c\/em\u003e, and a \u003cem\u003esticky note\u003c\/em\u003e for workflow context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Gmail (unread PDF invoice detection), Google Sheets (Invoices sheet lookup + append), Telegram (alerts for missing fields and duplicates).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements\u003c\/strong\u003e: connect Gmail, update the Google Sheets URL to your spreadsheet with an \u003cstrong\u003eInvoices\u003c\/strong\u003e sheet, and connect Telegram credentials.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869896106163,"sku":"N8N-18431","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/e_vxS88IOYZ5tpwwigwLN_3QNoK7pP.png?v=1787130673","url":"https:\/\/buyflowscripts.com\/products\/gmail-pdf-invoice-extractor-to-google-sheets-telegram-alerts-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}