GOOGLE.SHEETS.CELL.READ
Premium
Experimental
Read cells from a Google sheet.
Syntax
=GOOGLE.SHEETS.CELL.READ(Spreadsheet-Id, Sheet-Id or Sheet-Name, Cells, [ResponseTarget], [Render option])
Arguments
| Name | Type | Description |
|---|---|---|
| Spreadsheet-Id | Text | The id of the spreadsheet to read cells from. |
| Sheet-Id or Sheet-Name | Number,Text | ID or name of the sheet to read cells from. |
| Cells | Text | A string conforming to Google cells notation which specifies the cells to read. |
| ResponseTarget (optional) | Target | Specify inbox, outbox, cell or cell-range to write any response to. |
| Render option (optional) | CellRenderOption | Specifiy if formatted value should be returned or cell formula. Default is UNFORMATTED_VALUE. Options: "FORMATTED_VALUE": Returned cell value is formatted, e.g. as currency. "UNFORMATTED_VALUE": Returned Cell value is not formatted. "FORMULA": If cell is based on a formula this is returned instead of its value. |
Return
| Type | Description |
|---|---|
| Boolean,JSON | TRUE if read succeeded or response JSON if no target specified |
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | Reads cells A1:C3 from sheet S2 of spreadsheet with the ID given in B2. |