Skip to content

Instantly share code, notes, and snippets.

@iaindooley

iaindooley/gist:b09e1b3fc25b6bd6b005cffd49b5fc27

Created September 22, 2020 00:17
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iaindooley/b09e1b3fc25b6bd6b005cffd49b5fc27 to your computer and use it in GitHub Desktop.
Save iaindooley/b09e1b3fc25b6bd6b005cffd49b5fc27 to your computer and use it in GitHub Desktop.
Download ZIP
Update cards from Spreadsheet
Raw
gistfile1.txt
function updateCardsFromSpreadsheet()
{
var vals = SpreadsheetApp.openByUrl("spreadsheeturl").getSheets()[0].getDataRange().getValues();
for(var i = 0;i < vals.length;i++)
{
var card = new Card({link: vals[i][0]);
card.setName(vals[i][1]);
card.setDescription(vals[i][2]);
card.postComment(vals[i][3]);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment