Hi - I set up a zap that sends a slack notification whenever a notion database item is updated. This helps keep my team updated on new information regarding our customers.
I’d like to suppress the notifications to only send 1 per database item per day (in the case that an item is updated multiple times in a day).
Is this possible?
Thank you!
Best answer by Troy Tessalone
View original
+14
Hi
Good question
You’ll have to add more advanced logic to achieve this.
That means logging the updates per day. (find/create + update)
Then you have to have another Zap that runs on a schedule to find all the applicable records to send to Slack.
Airtable could be used for this, but not if there are lots of items updated per day (e.g. 100+), then even more logic has to be applied.
Thanks, I think this is worth looking into. Would this work with Google Sheets? There won’t be more than 10-20 items per day.
If you’re able to point me in the right direction to get up to speed on find/create + update I would really appreciate it, haven’t used that logic before.
+14
GSheets has these Zap actions for getting 1+ rows.
You’ll need to add a Date column (e.g. YYYY-MM-DD) to use to group the item changes by date.
You’d use the Date as the lookup field in the GSheet Zap action. (e.g. find all rows that have 2023-08-15)
+14
For the logging/updating of the GSheet data, try these Zap steps:
Action: GSheets - Lookup Row
Check the checkbox to create a row if not found
If you need to update the row, then add this Zap action: GSheets - Update Row
Awesome thank you! I think I have the gsheet and logging zap set up. It creates a row if the notion item name doesn’t exist in the sheet and creates a “pretty date” that zapier can read.
Now I’m creating the find zap and have been able to pull through, but the notion action looks like it only supports looking up one item at a time, would you mind discussing how to create an output of links to multiple notion database items based on output from the gsheet lookup?
+14
You would include the Notion link and other desired data point in other columns when the GSheet row is initially created.
That way you have all the data you need when finding multiple rows later on a schedule.
If you need to format the returned data, look into using the Formatter > Utilities > options for line items
This is so helpful, thank you. I’m just about there and got the utilities formatter where I want it, but the line item formatting doesn’t copy over to the slack message. Ideally I want a semicolon and space in between the Customer and Notes and a line break for each line item.
utilities output
slack input
slack output
That is absolutely savage, thank you so much!
Here’s the link if helpful: https://zapier.com/shared/7f959533dc762ecb16a0c021e5578a5f7337fd91
+6
That’s awesome! I’m glad Troy was able to help and point you to the right direction
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
