Extract and organize Drive files into Sheets with AI intelligence
Workflow Description
Automation that uses an intelligent agent to read files from Google Drive, analyze their content via OpenAI, then automatically organize extracted data into structured Google Sheets tables, with batch processing for large files.
How it works
- 1.Trigger the automation manually or by schedule to select files from Google Drive
- 2.Read file contents and extract essential data from documents
- 3.Send data to an AI agent that analyzes it using OpenAI's language model
- 4.Split results into batches and apply filters for valid data
- 5.Write organized data directly into Google Sheets tables
Use cases
- Convert invoices and contracts from Drive into organized spreadsheets
- Automatically extract data from PDF reports and text files
- Sort and organize documents based on intelligent criteria
- Build dynamic databases from multiple files
Requirements
- Google account with Drive and Sheets permissions
- OpenAI API key
- Files in Google Drive in readable formats (PDF, text documents)
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (19)
When clicking ‘Test workflow’
Manual Trigger
Extract from File
Extract From File
If is archived is false
If
OpenAI Chat Model
OpenAI
If extension is json
Filter
Sticky Note
Sticky Note
Search in "Keep" folder
Google Drive
Loop every 10 items
Split In Batches
Download the files
Google Drive
Put some AI treatment here if you need it
Agent
Set the fields for export
Set
Add to google sheet
Google Sheets
Filter
If
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note