Update spreadsheet titles and descriptions with AI enhancement
Workflow Description
Automation that reads data from Google Sheets and processes it through OpenAI to generate improved titles and descriptions, then automatically updates them in the spreadsheet. Uses batch processing to efficiently handle large datasets while maintaining quality and consistency across your content.
How it works
- 1.Retrieve rows from Google Sheets
- 2.Process data in batches for efficiency
- 3.Send content to OpenAI for enhancement
- 4.Update spreadsheet with improved results
Use cases
- Automatically enhance product listings in e-commerce platforms
- Improve content metadata for SEO optimization
- Bulk update blog post titles and meta descriptions
Requirements
- Google account with Google Sheets edit permissions
- Valid OpenAI API key with sufficient quota
- Spreadsheet containing content data to be enhanced
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