Start process from next empty cell

Hi, I am looking for the bot to open a google sheet document and be able to identify the next empty cell going down in column A to start running the process from here.

I am not sure how i can do this, i have installed the gsuite application but finding it difficult to code the bot to achieve the desired outcome.

can anyone help me here?

@nick.v If read the sheet and output is datatable then you can try like below.

  1. Find the the row index of empty row in ColumnA.
  2. Use above obtain index as starting range of for your operation.

Hi @Manjuts90

Unfortunately this will not work as the google sheet will be different everytime. i wouldn’t be opening the file i am using api’s.
Not sure if storing the output in a datatable would be a option