Templates / Monitor changes in Google Sheets every 45 mins

Monitor changes in Google Sheets every 45 mins

Needs changes

by Harshil Agrawal ✓ · 2,132 views · created 2020-12-30 · Personal Productivity

Needs changes. This template uses 2 thing(s) that n8n 3.0 removes: Function (legacy), Interval. 2 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 4 nodes and runs on a fixed interval (legacy Interval node). Along the way it connects Mattermost and Google Sheets.

How it runs

Trigger: On a fixed interval (legacy Interval node).

  1. Read data (Google Sheets): uses Google Sheets
  2. Check if new data (Function): runs custom JavaScript (legacy Function node)
  3. Send message (Mattermost): uses Mattermost

Services it uses

MattermostGoogle Sheets

Before you upgrade to n8n 3.0

2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:

  • Function (legacy) in Check if new data: replace with Code node, mode 'Run Once for All Items'.
  • Interval in Execute every 45 mins: replace with Schedule Trigger.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
Function (legacy)
Check if new data
Code node, mode 'Run Once for All Items'
Interval
Execute every 45 mins
Schedule Trigger

Nodes used (4)

From the author

Based on your use case, you might want to trigger a workflow if new data gets added to your database. This workflow allows you to send a message to Mattermost when new data gets added in Google Sheets. The Interval node triggers the workflow every 45 minutes.…

Excerpt from Harshil Agrawal's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.