- Create a spreadsheet or open an existing one
- Get your spreadsheet id. If the spreadsheet has an url like
https://docs.google.com/spreadsheets/d/11KRGX-DKhJvWa3rJpVvjWtPQiGKUZnOkrlQ21HKjkU4/edit
, the id is11KRGX-DKhJvWa3rJpVvjWtPQiGKUZnOkrlQ21HKjkU4
- 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.
- Go to "Tools > Script Editor"
- Replace everything in the file;
Go from this:
function myFunction() {
}