How to Update a row based on cell contents

How To
1

I have a webhook that creates a row of data and when that row of data would be updated at it’s source the update webhook is sent. When that update webhook is sent I would like to be able to search for the row that has the correct value in the A column so that the correct row is updated. I tried to put something in there however I don’t believe that I have the correct formula for finding the correct cell.
blueprint.json (33.5 KB)

2

Hello,

You could use a Google Sheets Search Rows module before your Add a Row module.
Once your row is located, map that row number into the Add a Row module.

3 Likes
3

That’s kind of what I thought, just seemed like I could go one less. Thank you for the help.

2 Likes