workflows.fit
Back to n8n workflows
n8n templateFreeBy Intuz

Automate data extraction from faxes & PDFs using Google Gemini and Google Sheets

This n8n template from [Intuz](https://www.intuz.com/) 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 m...

Data & StorageProductivityDevelopmentCore NodesAILangchainExtract From FileGoogle Drive
Loading interactive preview...

Template notes

This n8n template from [Intuz](https://www.intuz.com/) 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, and organize the data into a structured format, saving it directly to a Google Sheet.

Who's this workflow for? - Healthcare Administrators - Medical Billing Teams - Legal Assistants - Data Entry Professionals - Office Managers

How it works 1. Upload via Web Form: The process starts when a user uploads a fax (as a PDF file) through a simple, secure web form generated by n8n.

2. AI Document Analysis: The PDF is sent directly to Google Gemini's advanced multimodal model, which reads the entire document—including text, tables, and form fields. It extracts all relevant information based on a detailed prompt.

3. AI Data Structuring: The raw extracted text is then passed to a second AI step. This step cleans the information and strictly structures it into a predictable JSON format (e.g., Patient ID, Name, DOB, etc.).

4. Save to Google Sheets: The final, structured data is automatically appended as a new, clean row in your designated Google Sheet, creating an organized and usable dataset from the unstructured fax.

Key Requirements to Use This Template 1. n8n Instance & Required Nodes: - An active n8n account (Cloud or self-hosted). - This workflow uses the official n8n LangChain integration (@n8n/n8n-nodes-langchain). If you are using a self-hosted version of n8n, please ensure this package is installed.