AcademyWorkflowsFinance

Extract and organize Colombian invoices from Gmail

Individuals or finance staff in Colombia who keep a record of invoices received by email.

Use it nowWant it running at your company?
  • Recommendedour rating
  • 2,536views 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.

extract-and-organize-colombian-invoices-with-gmail-gpt-4o-google-workspace.json

Loading the file...

What it does

Checks a Gmail inbox every 30 minutes for emails with ZIP attachments of invoices. It unpacks them, keeps the PDF and XML files, and uses GPT-4o-mini to read fields such as invoice number, date, issuer, subtotal, IVA and total. A calculator confirms that the total matches, the PDF is renamed and saved to Google Drive, and the details go to Google Sheets without duplicates.

Use cases

  1. 01Keep a sheet of received invoices up to date
  2. 02Check that each total equals subtotal plus IVA
  3. 03Save invoice PDFs by date and invoice number

Connects

Google Sheets · Google Drive · Compression · Code · AI Agent · OpenAI Chat Model · Structured Output Parser · Calculator

Questions about
Extract and organize Colombian invoices from Gmail.

What is Extract and organize Colombian invoices from Gmail used for?

Individuals or finance staff in Colombia who keep a record of invoices received by email. Checks a Gmail inbox every 30 minutes for emails with ZIP attachments of invoices. It unpacks them, keeps the PDF and XML files, and uses GPT-4o-mini to read fields such as invoice number, date, issuer, subtotal, IVA and total. A calculator confirms that the total matches, the PDF is renamed and saved to Google Drive, and the details go to Google Sheets without duplicates.

How do I import Extract and organize Colombian invoices from Gmail 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 and organize Colombian invoices from Gmail 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