Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function populateSheet() {
- var data = getData(); // Get JSON data from the above function
- var sheet = SpreadsheetApp.getActiveSheet(); // Get active sheet object from the Spreadsheet
- var lastRowCount = sheet.getLastRow(); // Get the last row
- var header = ['Name', 'Email', 'Phone', 'Website']; // These will be the column headers in the sheet
- sheet.clear(); // Clear the sheet if needed
- sheet.getRange(1, 1, 1, header.length).setValues([header]); // Add column header in first row
- /* Start adding data from API after column header */
- for (var i = 0; i < data.length; i++) {
- var row = [];
- var nextRow = sheet.getLastRow() + 1; // Offset header row
- row.push(data[i].name, data[i].email, data[i].phone, data[i].website) // Transpose data from JSON in an array
- sheet.getRange(nextRow, 1, 1, row.length).setValues([row]); // Set data to the
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement