Join Scott Simpson for an in-depth discussion in this video Storing data for your script, part of Up and Running with Google Apps Script.
- Google offers two primary ways…of storing persistent data for your script.…Properties service and JDBC.…The Properties Service offers simple key-value storage…scoped to your script, the document containing the script,…or individual users of the script.…It's not a bulk storage service,…but rather a place to store settings…or preferences or other small strings of information.…The other service at the complete opposite end…of the storage spectrum is the JDBC service,…which stands for Java Database Connectivity…and allows you to connect to Google Cloud SQL,…Microsoft SQL Server, MySQL, and Oracle databases.…
Since working with database servers and SQL queries…are beyond the scope of this course,…I recommend that you take a look at the guide for connecting…to external databases via JDBC.…You can find that here.…It tells you what IP ranges you need…to whitelist on your firewall…and gives you some sample code to get started.…But for now let's take a brief look…at using the Properties Service…to store some information for a script.…
First, learn how to use simple scripts to edit documents and spreadsheets, work with files in Drive, and find and send messages in Gmail. Then find out how to add custom functionality to your spreadsheets, and build user interface elements for your scripts, using menus, alerts, and dialogs. Finally, Scott shows how to share your work with others by publishing scripts as web apps.
- What is Google Apps Script?
- Understanding script types
- Logging and debugging your scripts
- Scripting common tasks
- Building custom spreadsheet functions
- Creating add-on functionality such as dialogs and sidebars
- Sharing your script as a web app