Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. function populateSheet() {
  2. var data = getData(); // Get JSON data from the above function
  3. var sheet = SpreadsheetApp.getActiveSheet(); // Get active sheet object from the Spreadsheet
  4. var lastRowCount = sheet.getLastRow(); // Get the last row
  5. var header = ['Name', 'Email', 'Phone', 'Website']; // These will be the column headers in the sheet
  6.  
  7. sheet.clear(); // Clear the sheet if needed
  8. sheet.getRange(1, 1, 1, header.length).setValues([header]); // Add column header in first row
  9.  
  10. /* Start adding data from API after column header */
  11. for (var i = 0; i < data.length; i++) {
  12. var row = [];
  13. var nextRow = sheet.getLastRow() + 1; // Offset header row
  14. row.push(data[i].name, data[i].email, data[i].phone, data[i].website) // Transpose data from JSON in an array
  15. sheet.getRange(nextRow, 1, 1, row.length).setValues([row]); // Set data to the
  16. }
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement