Google Sheet Read Range Activity doesn't read empty range

I’m having issue with reading a Google Sheet. My code is not read the empty range. I have a spreedsheet which contains 11 colummns, but the last 3 are empty. I want to read the entire range.

image

The required cells begins on cell B9 and has no limited end

Hi @JOAO_VSOUZA ,

Are you including those in headers?

If so then it will not going to read as their will be a duplicate column in that case.

Thank you for the reply @ermanoj3101,

I’m not including those in headers. I’ve been testing and icluded, manualy and before run the process a word in the last empty colummn and it worked, but i need to read even when it is empty.

You mean you are including some word in empty headers manually to run the bot.

Is it ?