Skip to content

Instantly share code, notes, and snippets.

@iaindooley
Created October 10, 2019 19:45
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 iaindooley/a2640a1ca4a3aa691b6cd85adf4c1e42 to your computer and use it in GitHub Desktop.
Save iaindooley/a2640a1ca4a3aa691b6cd85adf4c1e42 to your computer and use it in GitHub Desktop.
Create boards from spreadsheet
function createBoardsFromSpreadsheet()
{
var values = SpreadsheetApp.openByUrl("paste document URL here").getSheets()[0].getDataRange().getValues();
new IterableCollection(values).each(function(row)
{
//assume format is: name, email1,email2 etc.
var board = Board.create(row[0]);
for(i = 1;i < row.length;i++)
{
board.inviteMemberByEmail(row[i]);
}
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment