AcademyWorkflowsFinance

Extract invoice data from Gmail to Google Sheets with GPT-4o

Finance and accounting teams that receive invoices by email and want the data collected in a structured sheet.

  • Recommendedour rating
  • 7,131views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

extract-invoice-data-from-email-to-google-sheets-using-gpt-4o-ai-automation.json

Loading the file...

What it does

An n8n workflow that watches Gmail for labelled emails with PDF attachments, converts each invoice to text and asks GPT-4o to pull out the key fields. These include company details, invoice numbers, dates, line items, taxes and payment terms, which are then written to Google Sheets.

Use cases

  1. 01Log invoice numbers, dates and totals from email PDFs
  2. 02Capture line items and tax amounts into a sheet
  3. 03Keep supplier invoice details in one place

Connects

Google Sheets · Google Drive · Code · AI Agent · OpenAI Chat Model

Questions about
Extract invoice data from Gmail to Google Sheets with GPT-4o.

What is Extract invoice data from Gmail to Google Sheets with GPT-4o used for?

Finance and accounting teams that receive invoices by email and want the data collected in a structured sheet. An n8n workflow that watches Gmail for labelled emails with PDF attachments, converts each invoice to text and asks GPT-4o to pull out the key fields. These include company details, invoice numbers, dates, line items, taxes and payment terms, which are then written to Google Sheets.

How do I import Extract invoice data from Gmail to Google Sheets with GPT-4o into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Extract invoice data from Gmail to Google Sheets with GPT-4o safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.