We have a key field with an ID (First column). How do I can I look to see if there is a row in Monday.com with the same ID and update the row OR if there is no row add a new one? Detailed zap steps would be appreciated.
Best answer
Monday.com adding new row when one does not exist
Best answer by SamBBest answer by SamB
Just wanted to follow up here to add that the monday.com integration now has a few different search actions, like Get Item by Column Value for example, which could be used to search for a specific column value (ID).
Next you’d add a Filter or Paths step to check whether the _zap_search_was_found_status field on the search action step had a value of “true” - meaning that a match for that ID was found. You’d then follow up the Filter/Path step with either a Create Item action to add a new item (row) or a Change Multiple Columns Value action to update the existing item that was found.
If you’re using a Filter step for the workflow you’d need to set up two Zaps. One to handle cases where a match wasn’t found and to create a new item in monday.com, and another Zap to update an existing item. You can find out more about working with Filters and Paths in this way here:
One thing to note, is that when working with the monday.com integration the column and values need to be set in JSON format. Monday.com have written up examples of how to do that here: Zapier JSON Formatting Examples
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+9- Zapier Expert
- 617 replies
Hi
Unfortunately, monday has no native integration with Zapier that allows checking whether an item exists. Although here’s a process you use to get it working using Monday’s API: https://community.monday.com/t/zapier-find-item-by/12627/13
It’s better to use other platforms such as Clickup or Airtable so that you don’t run into various issues that you do with Monday.
+11- Community Manager
- 7779 replies
- Answer
Just wanted to follow up here to add that the monday.com integration now has a few different search actions, like Get Item by Column Value for example, which could be used to search for a specific column value (ID).
Next you’d add a Filter or Paths step to check whether the _zap_search_was_found_status field on the search action step had a value of “true” - meaning that a match for that ID was found. You’d then follow up the Filter/Path step with either a Create Item action to add a new item (row) or a Change Multiple Columns Value action to update the existing item that was found.
If you’re using a Filter step for the workflow you’d need to set up two Zaps. One to handle cases where a match wasn’t found and to create a new item in monday.com, and another Zap to update an existing item. You can find out more about working with Filters and Paths in this way here:
One thing to note, is that when working with the monday.com integration the column and values need to be set in JSON format. Monday.com have written up examples of how to do that here: Zapier JSON Formatting Examples
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.