How to only insert a new row in G-Sheet if ID does not exist in G-Sheet column with ID?

I fetch rows from a Gravityform on a daily basis.
I want to insert new entries as rows in a Google Sheet.
I have an EntryID which is unique to the submissions, and would like to check for that on the Google Sheet, before updating/inserting a row.

How can I do this ?

Hi @Karmu

Please use the Google sheet module “Search Rows” to check if ID exists or not. Then with appropriate filtering, you can add row if it does not exist.

Best Regards,

Msquare Automation
:point_right: Visit our website | :spiral_calendar: Book a free consult

1 Like