Optimise Google Spreadsheets with multiple editors.
If you are the only editor of a gSheet, it is easy to control any changes, or restore to a previous version in case something goes wrong. What happens, though, when multiple users are updating the spreadsheet at the …
Plot shape in Google Spreadsheets with Apps Script
Recently I came across with a problem. How could one create a plot with given points in Google Sheets using Google Apps Scripts?
The first thought that came up was to use a Scatter type of …
Track Daily Runtime Quota of Google Sheets
Google Apps Scripts have limitations regarding the daily runtime of the scripts in a single account.
As of today, the quotas are:
- 90 min/day (Gmail account)
- 6 hours/day (G Suit account)
Unfortunately, there isn’t an easy way …
Logging in Google Sheets
How to create a log report inside your gSheet.
Let’s say your shared google spreadsheet uses multiple scripts to automate processes and you need a way to notify its users of the status of each …
Track Binance Cryptocurrency Price Movements with Google Sheets
Well, it looks like it’s hot season in cryptocurrency trading. So, how about a simple tool to keep you updated on price changes from Binance platform and provide some quick statistics?
Using the …