How to detect property changes in GAS and notify Slack
Posted: Wed Dec 11, 2024 5:13 am
Implementation flow
In order to achieve the above, the following is required:
Create a Marumi bot for Slack.
Create an integration to run Notion's API.
Create a program to detect updates to morocco phone number library articles in Notion. (Articles have statuses of "In Progress" and "Completed," so we will detect when an article becomes "Completed.")
Run the above program periodically, or when an article is published.
The results will be sent from Marumi bot.
It's not that difficult to create a SlackBot or two.
For 3 and 4, the important points are how to detect the status change from "writing" to "completed" and where to run the program .
Utilizing GAS (Google Apps Script)
This time, we will run it using GAS (Google Apps Script) for the following reasons .
You can run a script every hour without preparing an execution environment.
A spreadsheet can be used to keep track of article status.
It is easy to integrate with other Google services.
You don't have to send a notification immediately after completing an article; it's fine if there's a slight time lag before the notification arrives (patching every hour is sufficient).
In addition, it is ideal to be able to save the results of the previous execution in a spreadsheet to capture the status change from "Writing" to "Completed" . The Google integration service will be used to add new features to Marubi Bot in the future.
In order to achieve the above, the following is required:
Create a Marumi bot for Slack.
Create an integration to run Notion's API.
Create a program to detect updates to morocco phone number library articles in Notion. (Articles have statuses of "In Progress" and "Completed," so we will detect when an article becomes "Completed.")
Run the above program periodically, or when an article is published.
The results will be sent from Marumi bot.
It's not that difficult to create a SlackBot or two.
For 3 and 4, the important points are how to detect the status change from "writing" to "completed" and where to run the program .
Utilizing GAS (Google Apps Script)
This time, we will run it using GAS (Google Apps Script) for the following reasons .
You can run a script every hour without preparing an execution environment.
A spreadsheet can be used to keep track of article status.
It is easy to integrate with other Google services.
You don't have to send a notification immediately after completing an article; it's fine if there's a slight time lag before the notification arrives (patching every hour is sufficient).
In addition, it is ideal to be able to save the results of the previous execution in a spreadsheet to capture the status change from "Writing" to "Completed" . The Google integration service will be used to add new features to Marubi Bot in the future.