Row ID has an invalid format

(Ben Doe) #1

Hello everyone,

I am trying to update a row in a spreadsheet (the trigger is a simple message in messenger) but it does not work and the logs say “Row ID has an invalid format”.
What is the good format ?

Until now the format I used was simple numbers like 1,2,3…

Thanks in advance for your help.

Best,

Ben

(Kellsey Shaw) #2

Hi Ben,

It sounds like you might not be using the actual Row ID. Generally, the way to get the Row ID is by searching for it and then using the Row ID from the output.

If you’re still stuck, just let me know which spreadsheet integration you are using and we can help you.

(Ben Doe) #3

Hi @Kellsey ,

Thanks for your answer.
I thought I was able to chose any row without having to search for it.
I get it now.

Thanks

Ben

(Артём Морозов) #4

Hello. I have the same problem.

Where can I find the value of Row ID?

(Daniel Beckett) #5

Hi @Artemy,

To get the Row ID you would first need to search for content in that row to get the ID as an available output. So you’d do a search row action followed by an update row action.

The tutorial for Using Google Sheets in Flow XO has some more information that may help.

Hopefully that makes sense :slight_smile:

Thanks,
Dan