Connect Google Sheets with OpenAI andSlack
Workflow Description
This template integrates Google Sheets with OpenAI to analyze data intelligently, then automatically sends results to Slack channels. It processes large datasets in batches and applies conditional filters to ensure only relevant outputs are delivered.
How it works
- 1.Trigger automation when new rows are added to sheets or on a scheduled interval
- 2.Split incoming data into manageable batches for efficient OpenAI processing
- 3.Apply filters and conditional logic, then send analyzed results to Slack
Use cases
- Automatic content analysis and insights extraction from spreadsheet data using AI
- Real-time Slack notifications for critical results without manual intervention
Requirements
- Active Google Sheets account with write permissions configured
- Valid OpenAI API key and properly configured Slack workspace
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 (35)
Google Sheets Trigger
Google Sheets Trigger
Apollo Organization Enrichment
HTTP Request
Create Apollo People Search URL
Code
Loop Over Items (1000 per Batch)
Split In Batches
Apollo Find Decision Makers
HTTP Request
Add Contacts
Google Sheets
Apollo Enrich Decision Makers
HTTP Request
Create Apollo People Enrichment Payload
Code
Enrich Contacts
Google Sheets
Loop Over Items For Bulk Enrichment (10 per batch)
Split In Batches
Determine Contact's Department
OpenAI
Apollo Organization Search
HTTP Request
Add Company Website
Google Sheets
Approve Company Website
Slack
Add Company Details
Google Sheets
Select Unprocessed Companies
Filter
Is Domain Already Provided?
If
Summarize Core Business
OpenAI
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Split Out Batched Decision Maker Response
Split Out
Split Out Batched Enrichment Response
Split Out
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Send Weekly Report
Slack
Retrieve Verified Leads
Google Sheets
Derive Past Week's Lead Gen. Metrics
Code
Weekly Report Trigger
Schedule Trigger
Sticky Note8
Sticky Note
Sticky Note9
Sticky Note
Merge Rows Which Now All Contain Domains
Merge