Skip to content

Instantly share code, notes, and snippets.

View bacanu's full-sized avatar

Cosmin Bacanu bacanu

View GitHub Profile
@bacanu
bacanu / Instructions.md
Last active June 19, 2020 21:25
Read a random value from a google spreadsheet:
  1. Create a spreadsheet or open an existing one
  2. Get your spreadsheet id. If the spreadsheet has an url like https://docs.google.com/spreadsheets/d/11KRGX-DKhJvWa3rJpVvjWtPQiGKUZnOkrlQ21HKjkU4/edit, the id is 11KRGX-DKhJvWa3rJpVvjWtPQiGKUZnOkrlQ21HKjkU4
  3. Select what data you want to use by picking a range. I suggest a column and the range notation is A:A for column A, B:B for column B and so on.
  4. Go to "Tools > Script Editor"
  5. Replace everything in the file;
    Go from this:
function myFunction() {
  
}