Skip to content

Instantly share code, notes, and snippets.

@idaWHALE

idaWHALE/increment.gs

Last active March 22, 2018 22:34
Show Gist options
  • Save idaWHALE/512d38f2cd3478aeacfecead568050ec to your computer and use it in GitHub Desktop.
Save idaWHALE/512d38f2cd3478aeacfecead568050ec to your computer and use it in GitHub Desktop.
Download ZIP
This script increments A1 value. I use this with a trigger to auto-update CRYPTOFINANCE add-on. 1.- Tools -> Script Editor 2.- Paste script (rename file if desired) and run the script with play button. 3.- Give Google App Script access to sheets 4.- Edit -> Current project's triggers 5.- Choose script and set as time-driven. Choose frequency.
Raw
increment.gs
// increment.gs
function increment() {
var s = SpreadsheetApp.getActive().getSheetByName('Sheet1').getRange('A1');
var cur = parseInt(s.getValue());
s.setValue(cur + 1);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment