Developer & DevOps

Connect Google Sheets with Slack

13 nodes 231 118 Scheduled trigger
Download

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. 1.Schedule trigger executes automation at configured intervals
  2. 2.Query and retrieve data from connected Google Sheets
  3. 3.Process and format retrieved data using code and merge nodes
  4. 4.Send formatted message to selected Slack channels
  5. 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. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (13)

/

Add your competitors here

Code

#1

Sticky Note

Sticky Note

#2

Sticky Note1

Sticky Note

#3

Execute workflow every day

Schedule Trigger

#4

Get G2 data with ScrapingBee

HTTP Request

#5

Get review section HTML

HTML Page

#6

Iterate on reviews

Item Lists

#7

Extract structured data

HTML Page

#8

Convert Review HTML to Markdown

Markdown

#9

Get all past reviews

Google Sheets

#10

Continue only if review is new

Merge

#11

Send new review to Slack

Slack

#12

Add new review to Google Sheets

Google Sheets

#13