Automate data extraction from faxes & PDFs using Google Gemini and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs when someone submits an n8n form (“Fax File”). Along the way it connects Google Drive, Google Sheets and Google Gemini Chat Model. It also calls generativelanguage.googleapis.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Fax File”).
- Upload file (Google Drive): uses Google Drive
- Define Prompt (Edit Fields (Set)): sets 1 field: prompt
- Google Drive: download
- Extract from File: extracts data from a file (binary to propery)
- Call Gemini 2.0 Flash with PDF Capabilities (HTTP Request): calls generativelanguage.googleapis.com (POST)
- Code: runs custom JavaScript code
- Basic LLM Chain: sends a prompt to an LLM, with model: Google Gemini Chat Model; output parser: Structured Output Parser
- Append row in sheet (Google Sheets): append
Services it uses
HTTP calls to: generativelanguage.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Extract from File
n8n-nodes-base.extractFromFile - Google Drive
n8n-nodes-base.googleDrive - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code
From the author
This n8n template from Intuz provides a complete solution to automate the extraction of critical information from PDF documents like faxes, or any PDFs. It uses the power of Google Gemini's multimodal capabilities to read the document, identify key fields,…