Create a Spreadsheet with rows and columns values from a loop Create a sheet, with cell, row and column counters to populate the data. Create a folder, or select a folder to move the spreadsheet file into. Apps Script Lesson How to Create a Spreadsheet in Google Workspace Add Row Data with Code.