AutomationMart
Home/Browse/Extract invoice data from PDFs with AI - Google Sheets Email alerts
n8n

Extract invoice data from PDFs with AI - Google Sheets Email alerts

n8nn8n10 modulesv1.0
GmailGoogle SheetsOpenAIGoogle Drive

Built by Setidure Technologies This smart n8n automation extracts invoice details from PDF files uploaded to Google Drive using AI, logs them to a Google Sheet, and notifies the billing team via email — all without manual intervention. ⚠️ Note: This workflow requires a self-hosted n8n instance with LangChain, LLM, and Google integrations configured. 📦 What This Workflow Does Monitors a Google Drive folder for new invoice uploads Extracts text and parses key invoice details using LLM via LangChai

At a glance

Extract invoice data from PDFs with AI - Google Sheets Email alerts is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, OpenAI, Google Drive
Modules
10
Price
Free
Version
v1.0
Extract invoice data from PDFs with AI - Google Sheets  Email alerts workflow diagram

About this workflow

Built by Setidure Technologies This smart n8n automation extracts invoice details from PDF files uploaded to Google Drive using AI, logs them to a Google Sheet, and notifies the billing team via email — all without manual intervention. ⚠️ Note: This workflow requires a self-hosted n8n instance with LangChain, LLM, and Google integrations configured. 📦 What This Workflow Does Monitors a Google Drive folder for new invoice uploads Extracts text and parses key invoice details using LLM via LangChain Logs extracted data into a Google Sheet (Invoice Database) Generates a summary email using GPT-4O-MINI (Greenie) Sends the email to the billing team via Gmail ✅ Prerequisites A Google Drive folder to monitor for PDF uploads A Google Sheet named Invoice Database with the following columns: Invoice Number, Client Name, Client Email, Client Address, Client Phone, Invoice Date, Due Date, Total Amount Service account or OAuth credentials for: Google Drive Google Sheets Gmail LangChain + Ollama integration for LLM responses 🔧 Step-by-Step Setup Instructions Clone this workflow into your self-hosted n8n instance Set up credentials: Google Drive (for folder trigger) Google Sheets (for data logging) Gmail (for sending email) Ollama (local LLM) or any connected LangChain provider Configure the trigger node to watch your specific Invoice Uploads folder Update the Google Sheet node with your Invoice Database sheet URL and column mapping Test with a sample invoice to validate the AI extraction and email generation 🔄 Workflow Steps Step 1: Trigger on New File in Google Drive Node Name: Watch for New Invoices Type: Google Drive Trigger Event: fileCreated Triggers when a new PDF file is uploaded to a designated folder Step 2: Download the Uploaded File Node Name: Download Invoice PDF Type: Download Binary Downloads the invoice file from Google Drive Step 3: Extract Raw Text from PDF Node Name: Extract PDF Text Type: Extract from File Extracts unstructured text content from the downloaded PDF Step 4: Parse Invoice Fields Using AI Node Name: Parse Invoice Data with LLM Type: LangChain Agent LLM is prompted to extract: Invoice Number Client Name, Email, Address, Phone Invoice Date, Due Date, Total Amount Fields not found are skipped Step 5: Log Extracted Data to Google Sheet Node Name: Log to Invoice Database Type: Google Sheets Appends a new row with the extracted fields to the Invoice Database spreadsheet Step 6: Create Email Notification via LLM Node Name: Generate Billing Email Summary Type: LangChain Agent (GPT-4O-MINI) Prompt instructs AI to: Act as “Greenie” from Green Grass Corp Inform billing that a new invoice was processed Confirm logging into the Invoice Database Step 7: Send the Email to Billing Team Node Name: Email Billing Team Type: Gmail Send To: billing@example.com Subject and body injected from LLM output Step 8: End Workflow Gracefully Node Name: End Type: No Operation Used to cleanly terminate the flow 🧠 Example Output (Email) Subject: New Invoice Logged – Client: ABC Corp Hi Billing Team, A new invoice has been received and processed automatically. The following details have been extracted and logged into the Invoice Database: - Invoice Number: INV-1024 - Client: ABC Corp - Amount: $1,450 - Due Date: July 15, 2025 Please review the Invoice Database for full details. Regards, Greenie Green Grass Corp

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

Add new incoming emails to a Google Sheets spreadsheet as a new row

Every time you receive a new email, Make will automatically add selected data from the email to a new row in a Google Sheets spreadsheet.

Free

Add Google Sheets rows for new Memberful subscriptions deactivated

Every time a new Memberful subscription is deactivated, Make will automatically add a Google Sheets row. Here's the [sheet](https://docs.google.com/spreadsheets/d/1BZovPC488MA1S_LPr5NSka_sCriS2vLL5UIivuSRemE/edit?usp=sharing) used in this scenario.

Free

AI agent : Google calendar assistant using OpenAI

This template is a simple AI Agent that acts as a Google Calendar Assistant. It is designed for beginners to have their "first AI Agent" performing common tasks and to help them understand how it works. For new users of n8n, AI Agents, and OpenAI: This template involves using an OpenAI API Key. If you are new to AI Agents, make sure to research and understand key concepts such as: - "Tokens" (used for API requests), - "Tool calling" (how the AI interacts with ext

Free

Create onboarding video quizzes using WayinVideo, GPT-4o-mini and Google Sheets

Description Paste any onboarding video URL into a simple form and the workflow handles everything automatically. It transcribes the video, sends the full transcript to an AI that writes the exact number of quiz questions you requested, and saves the complete quiz directly to your Google Sheet. Built for HR teams, L&D managers, and anyone who creates employee training content at scale. --- What This Workflow Does - Accepts video input via form — Collects the video URL, department topic, and desir

Free

Collect WhatsApp questionnaire responses in Postgres (Module "Anketa")

Who is this for? This workflow is designed for businesses or organizations looking to collect and store user responses from questionnaires via a WhatsApp bot, with data saved in a Postgres database. What problem is this workflow solving? This workflow streamlines the process of collecting and managing user responses to questionnaires. It helps automate data collection from multiple users and stores the responses in a centralized database for easy access and analysis. What this workflow does Basi

Free

WordPress blog to Google Sheets sync (posts, categories, tags, media)

WordPress Blog to Google Sheets Sync Posts • Categories • Tags • Media --- 🧩 Overview This n8n workflow automatically syncs your WordPress website content — including posts, categories, tags, and media — into Google Sheets. It helps automate content reporting, SEO analysis, and data backups. The workflow can run on schedule or on demand via a webhook. --- 💡 Use cases - Maintain a live database of blog posts in Google Sheets. - Create dashboards in Google Da

Free

Ssl expiry alert with SSL-Checker.io

Use Case Managing SSL certificates manually can be time-consuming and error-prone, often leading to unexpected downtime or security risks due to expired certificates. What This Workflow Does This workflow automatically monitors SSL certificates for a list of websites, checks their expiry status using SSL-Checker.io, and sends timely notifications if a certificate is about to expire. Setup Add your credentials for Google Sheets, Gmail, and SSL-Checker.io. Create a Google Sheet with a list of URLs

Free

Find and verify Linkedin profile with Airtop

Automating LinkedIn Profile Discovery with Verification Use Case Accurately identifying and verifying a person’s LinkedIn profile is essential for prospecting, recruiting, or contact enrichment. This automation ensures high accuracy by combining search logic with optional profile validation. What This Automation Does This automation locates and verifies a LinkedIn profile using the following inputs: - Personinfo: Any identifying information about the person (e.g., name, company, email). - Airtop

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