Reading and writing the Sheet data

Often you need to read and/or write data to/from the Sheet. Usually, use the getValue method to read a value from a cell and the getValues method to read values from a range. The getValue method returns a single value and the getValues method returns a 2-dimensional array of values. To write single value and 2-dimensional array of values, use setValue and setValues methods respectively.

Get Learning Google Apps Script now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.