Skip to content

Instantly share code, notes, and snippets.

@koni
Created May 16, 2018 07:50
Show Gist options
  • Save koni/da3e76046232b6391467088b2f73afdd to your computer and use it in GitHub Desktop.
Save koni/da3e76046232b6391467088b2f73afdd to your computer and use it in GitHub Desktop.
GAS 適当なスプレッドシートにjsonの結果を書き込む
function myFunction() {
var sheet = SpreadsheetApp.getActiveSheet();
for (var i in users.users){
var user = users.users[i];
var r= parseInt(i, 10)+2;
sheet.getRange(r, 1).setValue(user.screen_name);
sheet.getRange(r, 2).setValue(user.name);
sheet.getRange(r, 3).setValue(user.protected);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment