Tag: sheets
-
How to use Google Apps Script to get data from a connected data sheet
Regular sheets are straightforward For a regular Google Sheets spreadsheet, it’s fairly easy to use Google Apps Script to get the data contained on a worksheet: var spreadsheet = SpreadsheetApp.getActive(); var regularsheet = spreadsheet.getSheets()[0]; var range = regularsheet.getDataRange(); var values = range.getValues(); for ( j = 0; j < values.length; j++ ){ Logger.log(values[j][0] + ':…