Interact with the sheet in local env

[jsmeng324]

Hi there, thanks for this awesome project!

This is more of a question than an issue - do you have any recommendation for how to interact with the sheet during local development? I am running npm run dev to start the local server, and getting the ReferenceError: google is not defined error when the home page tries to fetch data from the sheet.

It works fine when I deploy the whole thing to GAS though, so not a big deal if there's not a way to interact with the backend locally. Thanks again!

[ilias777]

Hi @jsmeng324.

I'm glad that you find this project helpful. 😊

Unfortunately the Google object is only available if the project is accessed via the Apps Script Web App (e.g. https://script.google.com/macros/{script-id}/exec) because Google then connects the corresponding script.

Follow these steps to test your app before deploy:

1. Run in the terminal:

clasp open

and the script opens in the browser.

2. Press Deploy and then Test Deployment.
3. Now click the URL to open the Web-App.
   The Web-App opens in a new tab.
   Keep the tab open in your browser.
4. Go to your editor and make the needed changes.
5. Push the files to Google Script to see the changes:

npm run build

6. Reload the page in your browser and now all the changes are applied.

With this method you can test your Web-App before creating a new deployment.

If you don't read this already, look here → How to deploy and test your app.

[jsmeng324]

Thank you so much for the reply! Appreciate your help!