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!

Best answer

Pass List/Array to "Lookup Value" param of "Lookup Spreadsheet Rows" Action

Forum|Forum|1 year ago
April 15, 2024
1 reply
64 views

MohitMayank
Beginner

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?