Analyze Google Sheets data with AI and save to Drive
Workflow Description
Automation that reads data from Google Sheets, processes it through OpenAI language models to generate professional content, and automatically saves results as files in Google Drive. Combines intelligence with document management for seamless workflows.
How it works
- 1.Read rows and data from your specified Google Sheets spreadsheet
- 2.Process data through LLM chains and generate insights using OpenAI models
- 3.Merge results, convert to file format, and store automatically in Google Drive
Use cases
- Generate market analysis reports from product inventory lists automatically
- Rewrite and refine marketing copy extracted from spreadsheet data
- Convert meeting notes into formatted documents and archive them in Drive
Requirements
- Active Google account with Sheets and Drive permissions
- Valid API key from OpenAI account
- Ready-to-use Google Sheets containing source data for processing
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 (18)
OpenAI Chat Model
OpenAI
Merge
Merge
Read Image URLs
Google Sheets
Download Images
HTTP Request
Analyze Images
OpenAI
Product Photography Prompt
LLM Chain
Send Image with Prompt to OpenAI
HTTP Request
Convert Base64 to File
Convert To File
Upload to Drive
Google Drive
Insert Image URL in Table
Google Sheets
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
When clicking 'Test workflow'
Manual Trigger
Convert to File
Convert To File
Sticky Note4
Sticky Note
Generate Image
HTTP Request