Auto-update Google Sheets titles and descriptions with AI
Workflow Description
Reads rows from Google Sheets and generates optimized titles and descriptions using OpenAI, then updates them back in batches. Processes data in parallel for speed and efficiency.
How it works
- 1.Read rows from your designated Google Sheets spreadsheet
- 2.Process data in parallel batches to maximize performance
- 3.Send each row to OpenAI for intelligent title and description generation
- 4.Update spreadsheet rows with the newly generated content
Use cases
- Enhance product descriptions for e-commerce businesses
- Update project metadata and task summaries intelligently
- Bulk-improve database records with professional descriptions
Requirements
- Google account with a spreadsheet containing text data
- OpenAI API key to access language models
- Read and write permissions on the target spreadsheet
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 (26)
When clicking ‘Test workflow’
Manual Trigger
Printify - Get Shops
HTTP Request
Printify - Get Products
HTTP Request
Split Out
Split Out
Loop Over Items
Split In Batches
Split - id, title, desc
Split Out
Calculator
Tool Calculator
Wikipedia
Tool Wikipedia
Printify - Update Product
HTTP Request
Brand Guidelines + Custom Instructions
Set
Sticky Note9
Sticky Note
Sticky Note10
Sticky Note
Google Sheets Trigger
Google Sheets Trigger
Printify - Get Shops1
HTTP Request
GS - Add Product Option
Google Sheets
Update Product Option
Google Sheets
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note11
Sticky Note
If1
If
Number of Options
Set
Calculate Options
Code
Remember Options
Set
Sticky Note
Sticky Note
Generate Title and Desc
OpenAI
If
If