AutomationMart
Home/Browse/Extract and organize Colombian invoices with Gmail, GPT-4o & Google Workspace
n8n

Extract and organize Colombian invoices with Gmail, GPT-4o & Google Workspace

n8nn8n22 modulesv1.0
agentaggregatecodecompressionextractFromFilefiltergmailTriggergoogleDrivegoogleSheetslmChatOpenAimergenoOpoutputParserStructuredsplitInBatchesswitchtoolCalculatorxml

Personal Invoice Processor This N8N workflow automates the extraction and organization of personal invoices in Colombia received via Gmail. It includes the following key steps: 🔁 Flow Summary 1. Email Trigger - Polls Gmail every 30 minutes for emails with .zip attachments (assumed to contain invoices). - Expects ZIP file following DIAN standards. 2. ZIP File Handling - Extracts all files. - Filters only PDF and XML files for processing. 3. Data Extraction & Processing - Uses LangChain Agent

At a glance

Extract and organize Colombian invoices with Gmail, GPT-4o & Google Workspace is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects agent, aggregate, code, compression. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
agent, aggregate, code, compression, extractFromFile, filter
Modules
22
Price
Free
Version
v1.0
Extract and organize Colombian invoices with Gmail, GPT-4o & Google Workspace workflow diagram

About this workflow

Personal Invoice Processor This N8N workflow automates the extraction and organization of personal invoices in Colombia received via Gmail. It includes the following key steps: 🔁 Flow Summary 1. Email Trigger - Polls Gmail every 30 minutes for emails with .zip attachments (assumed to contain invoices). - Expects ZIP file following DIAN standards. 2. ZIP File Handling - Extracts all files. - Filters only PDF and XML files for processing. 3. Data Extraction & Processing - Uses LangChain Agent + OpenAI (GPT-4o-mini) to extract: - Tipo de documento (Factura / Nota Crédito) - Número de factura - Fecha de emisión (YYYY-MM-DD) - NIT emisor y receptor (sin dígito de verificación) - Razón social del emisor - Subtotal, IVA, Total - CUFE - Resumen de compra (max 20 words, formatted sentence) 4. Validation - Ensures Total = Subtotal + IVA using a calculator node. 5. Storage - Uploads the original PDF to Google Drive. - Renames the file to: YYYY-MM-DD-NUMEROFACTURA.pdf. - Inserts or updates invoice details in Google Sheets using a unique Key (NITEmisor + NumeroFactura) to prevent duplication. --- > ⚙️ Designed for personal use with minimal latency tolerance and high automation reliability.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Automate Morning Brew–style Reddit Digests and Publish to DEV using AI

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Who’s it for Community managers, content marketers, and builders who want a daily, skimmable update from a subreddit—automatically summarized, formatted, and cross-posted to DEV Community. Here is a Link to video hackathon detailing this build. What it does Collects fresh posts from a subreddit (seeded via RSS). Uses the Bright Data node to batch-scrape each post for richer fields (upvotes, co

Free

Scrape, search and browse the web with a Firecrawl AI agent webhook

Turn any prompt into structured web data. Send a POST request with a natural language prompt and an optional JSON schema, and get back clean, structured results scraped from the web by an AI agent powered by Firecrawl. Use Cases - Data Enrichment: Feed company names or URLs from your CRM and get back structured firmographic data (industry, funding, team size, tech stack). - Lead Generation: Ask the agent to find pricing, contact pages, or product details for a list of competitors. -

Free

Extract business leads from Google Maps with Dumpling AI to Google Sheets

Who is this for? This workflow is built for marketers, sales teams, agencies, virtual assistants, and anyone who regularly researches or contacts local businesses. It's ideal for building lead lists, tracking competitors, or creating location-specific outreach campaigns. --- What problem is this workflow solving? Instead of manually searching Google Maps and copying business info into spreadsheets, this automation pulls structured business data (e.g. restaurants, gyms, service provid

Free

5 ways to process images & PDFs with Gemini AI in n8n

How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workflow answers that question by demonstrating five different approaches: - Single image with auto binary passthrough - The simplest approach using AI Agent's automatic binary handling - Multiple images with predefined prompts - For customized analysis with different instructions per image - Native n8n item-by-item processing - For handling

Free

E-commerce product fine-tuning with Bright Data and OpenAI

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automates the process of scraping product data from e-commerce websites and using it to fine-tune a custom OpenAI GPT model for generating high-quality marketing copy and product descriptions. Main Use Cases Fine-tune OpenAI models with real product data from hundreds of supported e-commerce websites for marketing content generation. Create custom AI models specialized in writing

Free

Monitor marketing job boards with Bright Data & GPT-4o for growing companies

This workflow automatically monitors marketing job boards to identify growing companies and potential business opportunities. It saves you time by eliminating the need to manually check job listings and provides insights into which companies are actively hiring and expanding their marketing teams. Overview This workflow automatically scrapes marketing job listings from Indeed and other job boards to extract company information, job details, and growth indicators. It uses Bright Data to access jo

Free

Form-based X/Twitter poster

Form-Based X/Twitter Poster (v2) A user-friendly n8n workflow that enables users to submit tweets through a simple web form — with optional image, video, or GIF uploads — and posts them to a connected X/Twitter account. Designed for ease of use, this workflow handles both media and text-only posts, providing clear feedback upon submission. --- 🧭 Overview Workflow Name: Form-Based X/Twitter Poster (v2) Goal: Provide a web form for users to create tweets, upload optional media, and post directly

Free

AI prompt hub (Notion + ChatGPT): auto-find the right prompt with embeddings

Overview Build your own AI Prompt Hub inside n8n. This template lets ChatGPT automatically search your saved prompts in Notion using semantic embeddings from HuggingFace. Each time a user sends a message, the workflow finds the most relevant prompt based on meaning - not keywords. Perfect for developers who maintain dozens of prompts and want ChatGPT to pick the right one automatically. Key Features - 🔍 Semantic Prompt Search - Finds the best prompt using HuggingFace embeddings - 🧠 AI Agent In

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free