Monitor changes in Google Sheets every 45 mins
Needs changesWhat 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).
- Read data (Google Sheets): uses Google Sheets
- Check if new data (Function): runs custom JavaScript (legacy Function node)
- Send message (Mattermost): uses Mattermost
Services it uses
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.0 | Replace 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)
- Mattermost
n8n-nodes-base.mattermost - Function
n8n-nodes-base.function - Google Sheets
n8n-nodes-base.googleSheets - Interval
n8n-nodes-base.interval
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.…