2

What's the best potential way to find the next empty row using the Google Sheets API V4? I've done some research and found some very insightful answers from Omiod's post about the issue, however presumably in V3 or potentially even V2.

Since V4's introduction, the API has undergone a seemingly difficulty-enhancing upgrade, and I can't seem to figure it out using the new libraries and their functions.

Any and all help is appreciated! Thanks.

Josh Creighton
  • 21
  • 2

1 Answers1

1

Sheetsv4 API ignores empty rows. So there's no ad-hoc method to detect if the row is empty. What you can do is read the entire range and perform an if statement to see if a certain cell has value or not.

ReyAnthonyRenacia
  • 17,219
  • 5
  • 37
  • 56
  • What do you think would be the best way to do this? Was hoping this wasn't the answer but reading the entire range of all rows seems rather slow. – Josh Creighton Dec 28 '17 at 08:51
  • let me see if i can share my snippet on how i handle 'empty cells'. it's more of a workaround than an ad-hoc function from sheets api – ReyAnthonyRenacia Dec 28 '17 at 13:06