As this is the first question about Google Apps Script, here is a very brief description: it is a platform that helps people easily get programmatic access to Google apps data like Gmail messages, Google Drive files, etc. and also to certain elements that can't be accessed through one of the Google APIs. It offers a web-based IDE and has its own API.

The Google Apps Script API docs include a quickstart section, having subsections for different languages / platforms including JavaScript.

I thoroughly reviewed the quickstart overview and the JavaScript subsection and got it to work, but when trying the "How too... Execute a function" I got stuck; more specifically, I'm getting 404 errors.

References:

• Google Apps Script REST API overview page: https://developers.google.com/apps-script/api/concepts.
• JavaScript quickstart instructions: https://developers.google.com/apps-script/api/quickstart/js
• The How To... Execute a function: https://developers.google.com/apps-script/api/quickstart/target-script

This is my environment:

• Google Workspace account. I'm the domain administrator.
• New Google Cloud project, created following the quickstart instructions
• New Google Apps Script project, created using the quickstart instructions

Hardware and Installed Software

• Mac Mini Apple M1, MacOS Ventura 13.4.1.
• Google Chrome
• Visual Studio Code

Steps to reproduce the problem

1. Read the links included above.
2. Create the target script.
3. Create the file from the JavaScript quickstart. Default name index.html.
4. Create the file from the How to... Execute function. Default name index.js
5. Modify index.html to load index.js.
6. Modify index.html in such a way that instead of calling createScript() call callScriptFunction().
7. Create the Google Cloud standard project.
8. Enable the Apps Script API.
9. In the API section of the Cloud project, go to credentials.
10. Add the ApiKey. Take note of it.
11. Add the Web client
12. Add the allowed URI. If you will run this locally add http://localhost:8080.
13. Create the OAuth consent screen
14. Grab the Google Cloud project id and add it to the Google Apps Script project on Project settings.
15. Deploy Google Apps Script as API executable
16. Get the script Id.
17. Add the ApiKey, Client Id to the index.html file.
18. Add the script Id to the index.js file.
19. Open index.html using Google Chrome.
20. Click the button Authorize and follow the OAuth authorization flow.
21. Open the Google Chrome DevTools Console.
    Here you will find the error message.

posted 11 months ago

CC BY-SA 4.0

11mo ago

Wicket‭

201 reputation 7 4 31 26