I am trying to update rows of an existing Gsheet worksheet on receiving a trigger. Basically, I am sending a webhook which is captured by the trigger. The payload contains a list (array) of dictionary which contains two important items,
- `contactId` - this I need to match in the existing worksheet, it should be present in a column
- `outcome` - this is what I need to add to another col for the matching `contactid`
I tried using “Lookup Spreadsheet Rows” where I was trying to find all rows with matching `contactid`. I thought once I have the `rowsids`, I can use it in “Update Spreadsheet Row(s)...” with the `outcome` values. But it is not working - I am stuck on setting the “Lookup value” of “Lookup Spreadsheet Rows” which seems to be not accepting an array, but only a single value! Is there any other way to handle this?
Thanks!