Web Automation
Extract and enhance Google Sheets data with AI processing
11 nodes
135
84
Automatic trigger
Workflow Description
This automation reads data from Google Sheets, processes it in batches through an advanced language model via OpenRouter, parses the structured results, and writes the enhanced data back to your spreadsheet automatically.
How it works
- 1.Trigger manually or on sheet changes
- 2.Fetch rows from Google Sheets and split into manageable batches
- 3.Send batches to OpenRouter's language model for intelligent processing
- 4.Parse and structure the AI responses using a data parser
- 5.Write processed results back to the spreadsheet in designated columns
Use cases
- Standardize customer and product data formats across large spreadsheets
- Auto-generate product descriptions, tags, or classification categories from raw text
- Extract structured information from unstructured content and populate new columns
Requirements
- Google Workspace account with edit permissions on target sheets
- OpenRouter API key for accessing advanced language models
- Pre-organized spreadsheet with source data in specific columns
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Lm Chat Open Router
Output Parser
Split In Batches
Google Sheets
LLM Chain
Details
Trigger
Automatic trigger
Nodes
11
Apps
5
Views
135
Downloads
84
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 (11)
/
OpenRouter Chat Model
Lm Chat Open Router
Structured Output Parser
Output Parser Structured
scrap url
HTTP Request
Sticky Note1
Sticky Note
When clicking ‘Test workflow’
Manual Trigger
url
Split In Batches
get urls to scrape
Google Sheets
clean html
Code
extract data
LLM Chain
add results
Google Sheets
Split items
Split Out