Developer & DevOps
Connect Google Sheets with Slack
13 nodes
231
118
Scheduled trigger
Workflow Description
Automate periodic monitoring of Google Sheets data and automatically send updates to designated Slack channels, providing instant team notifications of any changes without manual intervention.
How it works
- 1.Schedule trigger executes automation at configured intervals
- 2.Query and retrieve data from connected Google Sheets
- 3.Process and format retrieved data using code and merge nodes
- 4.Send formatted message to selected Slack channels
- 5.Log each monitoring and notification operation
Use cases
- Alert team of sales updates and new orders from a centralized spreadsheet
- Monitor project lists and tasks, notifying managers of overdue items
- Track performance metrics and statistics, distributing them to analytics team
Requirements
- Google Workspace account with access permissions to target spreadsheets
- Slack workspace with admin privileges and channels dedicated for notifications
- Basic knowledge of Google Sheets formulas and Slack message formatting
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Google Sheets
Slack
Details
Trigger
Scheduled trigger
Nodes
13
Apps
2
Views
231
Downloads
118
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 (13)
/
Add your competitors here
Code
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Execute workflow every day
Schedule Trigger
Get G2 data with ScrapingBee
HTTP Request
Get review section HTML
HTML Page
Iterate on reviews
Item Lists
Extract structured data
HTML Page
Convert Review HTML to Markdown
Markdown
Get all past reviews
Google Sheets
Continue only if review is new
Merge
Send new review to Slack
Slack
Add new review to Google Sheets
Google Sheets