Connect Google Drive with Google Sheets
Workflow Description
An automated workflow that retrieves files from Google Drive, analyzes them using AI, and automatically organizes extracted data into Google Sheets on a scheduled basis, enabling intelligent document processing and real-time data consolidation.
How it works
- 1.Trigger the workflow on a scheduled interval to ensure regular processing
- 2.Fetch files from designated Google Drive folders and directories
- 3.Process files using Gemini AI for advanced content analysis and data extraction
- 4.Split results into manageable batches for parallel processing
- 5.Transform and structure extracted data into a consistent format
- 6.Write consolidated data to Google Sheets and update tracking information
Use cases
- Extract invoice and contract data from Drive documents and populate organized Sheets for financial tracking
- Monitor Linear projects by analyzing related documents and automatically logging project progress updates
- Compile daily work reports from multiple files and generate executive summaries in Sheets
Requirements
- Google Workspace account with access to Drive and Sheets APIs
- Gemini API key from Google Cloud Console
- Read and write permissions on target folders and spreadsheets
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 (34)
Base Image
Google Drive
Google Gemini Chat Model
Gemini Model
Structured Output Parser
Output Parser Structured
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Loop Over Items
Split In Batches
Wait
Wait
Download Screenshot
HTTP Request
Upload to Drive
Google Drive
Update Base Image
Google Sheets
Merge
Merge
Schedule Trigger
Schedule Trigger
Get URLs with Missing Base Images
Google Sheets
Run Webpage Screenshot
HTTP Request
Run Webpage Screenshot1
HTTP Request
Has Changes
Filter
Combine Row and Result
Set
Wait1
Wait
Aggregate
Aggregate
Create Report
Linear
When clicking ‘Test workflow’
Manual Trigger
Get Webpages List
Google Sheets
For Each Webpage...
Split In Batches
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Download New Screenshot
HTTP Request
Combine Screenshots
Merge
Sticky Note8
Sticky Note
Sticky Note9
Sticky Note
Visual Regression Agent
LLM Chain