{"product_id":"gmail-pdf-invoice-extractor-with-gemini-to-google-sheets","title":"Gmail PDF Invoice Extractor with Gemini to Google Sheets","description":"\u003ch3\u003eExtract Turkish invoice data from Gmail PDF attachments into Google Sheets—automatically with Gemini\u003c\/h3\u003e\n\u003cp\u003eIf your invoices arrive by email, this \u003cstrong\u003en8n workflow\u003c\/strong\u003e watches your \u003cstrong\u003eGmail\u003c\/strong\u003e inbox for \u003cstrong\u003ePDF attachments\u003c\/strong\u003e, checks whether each PDF is an invoice, and then uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract structured \u003cstrong\u003einvoice headers and line items\u003c\/strong\u003e into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—so you can stop manual copy\/paste.\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 triggers on new Gmail messages that match the filter: \u003cem\u003efilename:pdf has:attachment\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits email attachments\u003c\/strong\u003e into individual items and loops through each PDF attachment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads each PDF to Google Drive\u003c\/strong\u003e (target Drive folder ID you configure), then downloads it and \u003cstrong\u003eextracts text from the PDF\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to determine whether the extracted text is an \u003cstrong\u003einvoice\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf it’s \u003cstrong\u003enot\u003c\/strong\u003e an invoice, the workflow \u003cstrong\u003edeletes the uploaded file\u003c\/strong\u003e from Google Drive.\u003c\/li\u003e\n  \u003cli\u003eIf it \u003cstrong\u003eis\u003c\/strong\u003e an invoice, Gemini extracts invoice details and \u003cstrong\u003eline items\u003c\/strong\u003e using a \u003cstrong\u003estructured JSON schema\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends results to Google Sheets\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eInvoice headers to the sheet tab \u003cstrong\u003e“Faturalar”\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eEach invoice line item to the sheet tab \u003cstrong\u003e“Kalem Detay”\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate invoice intake for Turkish suppliers that email PDF invoices.\u003c\/li\u003e\n  \u003cli\u003eMaintain up-to-date invoice databases in Google Sheets for accounting review.\u003c\/li\u003e\n  \u003cli\u003eReduce manual data entry for SaaS operations and internal finance workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n scheduling \u0026amp; logic nodes:\u003c\/strong\u003e Runs every hour; uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth2), \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e (OAuth2), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2), and \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (via Google PaLM\/Gemini chat model nodes).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup required:\u003c\/strong\u003e Gmail OAuth2 + query filter, Drive folder ID, Gemini API credentials (for the two Gemini nodes), and your Google Sheets spreadsheet\/tab configuration.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172948529331,"sku":"N8N-20572","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/6VipepGlz8j6-TJeWcgz_UJBBCkU5.png?v=1791364709","url":"https:\/\/buyflowscripts.com\/products\/gmail-pdf-invoice-extractor-with-gemini-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}