In this post, I look at using template literals, an ES6 feature now available to Google Apps Script developers, to create dynamic multiline strings.
| 0 Comments ||
After answering 100’s of Google Apps Script questions, I realized how many projects people are working on that start with a Google Spreadsheet as a base. A lot of my existing examples involve using a Google Form to trigger scripts that do things to data being written to a spreadsheet, so I typically have to describe what to do using quick code snippets or links to other docs.
In this post, we look at the easiest way to retrieve all of the rows of data from a Google Spreadsheet using Google Apps Script.