Connect Google Drive with Google Sheets
Workflow Description
An automation that retrieves files from Google Drive, processes them using an intelligent AI agent powered by OpenAI, and saves structured results to Google Sheets in organized batches.
How it works
- 1.Trigger the automation manually and extract file contents from Google Drive
- 2.Process extracted data through an AI agent enhanced by OpenAI's language models
- 3.Divide results into batches and apply filtering based on defined criteria
- 4.Store processed data in Google Sheets in a structured, organized manner
Use cases
- Extract data from multiple documents in Google Drive and process them automatically
- Organize AI-processed results directly in Google Sheets for review and analysis
Requirements
- Google Cloud account connected to Google Drive and Google Sheets
- Valid OpenAI API key for accessing language models
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