Question about posting project files (.aia) containing "secure" information

[TIMAI2]

Some guides for you:

Everything you wanted to know about Google Apps Script, but were afraid to ask

Well, not quite "everything", but enough to help create a script, deploy it, update it and approve permissions for it, to begin with. Of course, there is the official documentation: Google Apps Script First two guides to deploy a google apps script, standalone and one that is bound to a spreadsheet: Second a guide to update your google apps script to a new version after editing the script: Third a guide to correctly reviewing permissions for a script (this is also covered in the second …

Simple CRUD with Google Sheets and Apps Script (fixes Hay Kel flaws...)

I have lost count of the number of times the community has received requests for help from developers, after following the Hay Kel series of videos on CRUD with google sheets. The videos are well produced, and offer the viewer a good insight to creating the app-sheet-script ensemble required for CRUD activities. However, the script is flawed: a bound to sheet script, with code that only allows the bound spreadsheet and use of the first sheet; hard-coded columns and hard-coded row data for upda…

Google Sheet - CRUDQII - create/read/update/delete/query - using google web app

An updated and revised version of my original CRUD guide [crudqIIdata]

Use gviz to get and query google sheet data

[gvizscreen1] Guide on how to use the google visualization API to get and query "public" google sheet data Note: this approach has been knocking around for years, e.g. App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps, but I have never seen it "properly" explained like this...

Use gviz to get or query PRIVATE google sheet data

[restricted] This guide demonstrates how to use the gviz query language on a private google sheet, with use of an intermediary web app. Note: this guide comes with a health warning for developers. It is strongly recommended that developers DO NOT provide users with the option to add a spreadsheet ID in their apps. Spreadsheet IDs should be hard coded into the web app. Failure to do so may provide others with access to your private google sheets.

If you really want a deep dive into Google Apps Script & Web Apps, here is the canonical from Tanaike:

GitHub - tanaikech/taking-advantage-of-Web-Apps-with-google-apps-script: This is a report to take advantage of Web Apps...