Retrieve Number Of Rows In Google Sheets

I need a JavaScript method for my webpage to count how many rows are in a Google sheet (it's used as a response sheet for a form). I've been scouring the web for easy tutorials on

Solution 1:

Here is what you can do

Write a simple Apps script using ContentService that will return a JSON with the number of rows in the spreadsheet (and any other info you need). To get the number of rows, you can use the getLastRow() function

Publish your script as a service(web app) and make an AJAX call from your JS code.