Google Apps Script + basic knowledge of [[JavaScript]] feels like a superpower. You can easily and for free create custom web apps that you can then use to do all sorts of things. It sounds complicated, but it's really not bad & once you get over that hump it's a **very handy tool for your toolbelt**. You can also just set scripts to automatically trigger every so often, or on specific events (e.g. [[spreadsheet]] opened) For my [[PDW|Data Journal]] I use it to: - Automatically create new rows for each day, week, month, & year - POST requests to write new rows to a dataset - GET requests to return today's data from every dataset - GET backups of the data For [[Aaron's Puzzles]] I use it to: - GET high scores for a given game - GET backups of the data - POST new scores **** # More ## Source - [[Myself]]