Extract Google Docs content and distribute via Slack and Gmail
Workflow Description
This automation reads Google Docs content, analyzes it using OpenAI to extract key information, then automatically distributes results across Slack channels and email recipients in organized batches.
How it works
- 1.Receive webhook request to read the document
- 2.Extract Google Docs content and process with OpenAI
- 3.Split results into separate batches
- 4.Send summaries to selected Slack channels
- 5.Distribute details via Gmail messages to recipients
Use cases
- Distribute monthly report summaries to team instantly
- Send updated project documentation to all members automatically
- Process group notes and send them to stakeholders efficiently
Requirements
- Google account with access permissions to specific Docs
- OpenAI API key for content analysis
- Slack channel or workspace for receiving messages
- Gmail addresses for final recipients
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 (23)
Get RFP Data
Extract From File
Item List Output Parser
Output Parser Item List
For Each Question...
Split In Batches
Sticky Note
Sticky Note
Set Variables
Set
Sticky Note1
Sticky Note
Create new RFP Response Document
Google Docs
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
OpenAI Chat Model
OpenAI
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Send Chat Notification
Slack
Send Email Notification
Gmail
Add Metadata to Response Doc
Google Docs
Sticky Note6
Sticky Note
Record Question & Answer in Response Doc
Google Docs
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note
Answer Question with Context
OpenAI
Wait for Request
Webhook
Extract Questions From RFP
LLM Chain
Sticky Note9
Sticky Note