Skip to content

Instantly share code, notes, and snippets.

@mpmckenna8
Last active November 14, 2015 07:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mpmckenna8/b523696eb11143584d68 to your computer and use it in GitHub Desktop.
Save mpmckenna8/b523696eb11143584d68 to your computer and use it in GitHub Desktop.
To insert the countries with a script rather than as keybordists
function myFunction() {
// Made the countries into an array
var countries = ["Brazil", "Chile", "Colombia", "Uruguay", "France",
"Nigeria", "Germany", "Algeria", "Netherlands", "Mexico", "Costa Rica",
"Greece", "Argentina", "Switzerland", "Belgium", "United States"];
// grabbing the spreadsheed we're working with and naming it ss
var ss = SpreadsheetApp.getActiveSpreadsheet();
var SHEET_TEAMS = 'Teams';
var sheetControl = ss.getSheetByName(SHEET_TEAMS);
Logger.log(rangeTeams);
for(i in countries){
// cell = ranger.getCell(i+1 , 1);
// each column in the row is an array element, we just need one here and it's the country
sheetControl.appendRow([countries[i]]);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment