I have two categories of Quizzes:
- Countries and Capitals - 196 countries
- Wonders of the World - 7 Wonders
Alexa starts with Country=1 (Andorra) (Set RowNumber=2) and keeps going until the last entry Zimbabwe = 196. At this point Alexa says - You have reached the end of Countries Quiz, Let us start with: Wonders of the World Quiz"
Everything works as expected, but currently I am hard coding the last row - :"If RowNumber=197 ., speak “End of Countries Quiz”,
To avoid hard coding the row number, I would like to get the last row of my sheet.
I tried the code block with:
var lastRow = sheet.getLastRow()
based on the Google Sheet method “getLastRow”.
But it returns an error. “Reference Error: .getLastRow is undefined:”
Any idea, how to get the last row of a particular sheet