Question

Google Sheets update from webhook/form - update only cells if there is data in form

  • 25 November 2021
  • 1 reply
  • 23 views

Userlevel 1

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?

 


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

1 reply

Userlevel 7
Badge +14

Hi @mihalytoth 

Check this help article: https://zapier.com/help/doc/finding-and-updating-rows-in-google-sheets