AcademyWorkflowsFinance

Invoices from Gmail to Drive and Google Sheets

Finance and admin teams that receive invoices by email and want them filed and logged without typing the data in by hand.

Use it nowWant it running at your company?
  • Recommendedour rating
  • 27,090views on n8n

Use it now

Open inClaudeChatGPTGeminiPerplexity
Open on n8n.io ↗

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

Third party software. By copying, downloading or installing it you accept the Academy legal notice: you are responsible for reviewing its code and permissions before use.

invoices-from-gmail-to-drive-and-google-sheets.json

Loading the file...

What it does

Watches Gmail for unread emails with attachments, saves the PDFs to a Google Drive folder, and uses OpenAI GPT-4o to read the invoice date, description and amount. The extracted data is added as a row in a Google Sheets spreadsheet.

Use cases

  1. 01File supplier invoices from email into one Drive folder
  2. 02Keep a spreadsheet log of invoice dates and amounts
  3. 03Remove manual data entry from invoice processing

Connects

Google Sheets · HTTP Request · Google Drive · Gmail · Basic LLM Chain · OpenAI Model · Structured Output Parser

Questions about
Invoices from Gmail to Drive and Google Sheets.

What is Invoices from Gmail to Drive and Google Sheets used for?

Finance and admin teams that receive invoices by email and want them filed and logged without typing the data in by hand. Watches Gmail for unread emails with attachments, saves the PDFs to a Google Drive folder, and uses OpenAI GPT-4o to read the invoice date, description and amount. The extracted data is added as a row in a Google Sheets spreadsheet.

How do I import Invoices from Gmail to Drive and Google Sheets 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 Invoices from Gmail to Drive and Google Sheets 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.

Related resources

Read the guide: AI for accounting firms and gestorías ↗

  1. 001Alpha Skills for quant factor researchQuantitative research and investment analysis teams that want to run factor research through natural language requests in Cursor.RecommendedRules file
  2. 002Fintech Engineer subagentFinance and product teams building or reviewing payment, banking or trading systems.RecommendedSubagent
  3. 003Payment Integration subagentFinance and engineering teams adding or reviewing payment flows in a product.RecommendedSubagent
  4. 004Invoice data extraction with LlamaParse and OpenAIFinance and accounting teams that receive supplier invoices by email and want the data in a spreadsheet.RecommendedWorkflow · 37k views
  5. 005Weekly stock analysis reports with GPT-4oFinance teams, investors and analysts who want a regular written stock summary that combines technical indicators with news sentiment.RecommendedWorkflow · 37k views
  6. 006Analyze TradingView charts with Chrome and OpenAIFinance and trading teams, and n8n builders, who want a quick written reading of a chart from their browser.RecommendedWorkflow · 33k views