I have a Google Sheets table, with data, the first column is the ID.
I have a website with a form, witha webhook.
After form is submitted, webhook triggered.
I lookup the “ID” with zapier from the Google Sheets table.
Then I want to update only those cells which contain data from the form, but leave untouched with the original data the other cells.
The table contains looooots of data and 500+ rows.
Do you have an idea how to do this?
Check this help article: https://zapier.com/help/doc/finding-and-updating-rows-in-google-sheets