Extract and summarize company data with Airtable and Gemini
Workflow Description
An automation that retrieves company data from multiple sources, processes it in batches, and generates summaries using Google Gemini's AI capabilities. Results are automatically organized and stored in Airtable for review and analysis.
How it works
- 1.Trigger the workflow manually and send an HTTP request to fetch company data from your data sources
- 2.Process the retrieved data in separate batches using the Split In Batches node
- 3.Route each batch through an intelligent agent with LLM Chain to extract key information
- 4.Apply Gemini model to automatically summarize the extracted data and insights
- 5.Store the extracted data and summaries in dedicated Airtable tables for centralized access
Use cases
- Collect company information from web pages and automatically store summaries in a unified database
- Monitor competitor and customer data updates, organizing them in Airtable without manual effort
- Generate executive summaries from multi-source data collection automatically each day
Requirements
- Active Google Gemini account with API credentials properly configured
- Airtable database prepared with structured tables ready to receive data and summaries
- External data sources or accessible API endpoints configured for data extraction
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 (19)
When clicking ‘Test workflow’
Manual Trigger
Google Gemini Chat Model For Summarization
Gemini Model
Webhook HTTP Request
HTTP Request
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Perform Indeed Web Request
HTTP Request
Indeed Expert AI Agent
Agent
Google Gemini Chat Model
Gemini Model
Markdown to Textual Data Extractor
LLM Chain
Convert Markdown to HTML
Markdown
Initiate a Webhook Notification for Markdown to HTML Response
HTTP Request
Set Bright Data Zone
Set
Loop Over Items
Split In Batches
Airtable
Airtable
If Link field is not empty
If
Wait
Wait
Indeed Summarizer
Chain Summarization
Sticky Note2
Sticky Note
Google Gemini Chat Model for AI Agent
Gemini Model