Hello,
i would like to make a workflow so i can update rows in google sheets.
whenever i get a whatsapp in a specific group.
ive setup the whatscale and find rows.
this outputs the right row data from google sheets.
but when i want to “update row” it updates the wrong data and i dont know if i can set it up to add 1 or minus 1 value.
below is my work flow.
if any more information or screenshots are needed please let me know.
Hi @Rilizaka Welcome to the community
,
Find Rows returns an array — [{ row: 26, values: {...} }] — but you’ve dragged the entire step into Row Number, which expects a plain number. That’s exactly what the error says: Expected number, received: [object Object].
In the Data Selector, drill in to Find Rows → Find Rows [1] → row and click Insert
thank you, i changed that to test something.
but that error is not the problem.
the problem is that when it goes trough ( see screen below )
it updates the cell with the number in it. not the rext row.
example:
cell 1 : 2730
cell 2 : 10
i want to change 10 to 9 with the trigger from the whatsapp.
but it changed 2730 to 10.
how can i do this?