Best answer adding new row when one does not exist

  • 15 July 2021
  • 2 replies

We have a key field with an ID (First column).  How do I can I look to see if there is a row in 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 by SamB 15 September 2021, 15:22

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +9

Hi @MortgageCompanyIT 

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:

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.

Userlevel 7
Badge +11

Just wanted to follow up here to add that the 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, 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 integration the column and values need to be set in JSON format. have written up examples of how to do that here: Zapier JSON Formatting Examples