En

Get Cell Value#

Read the value of a cell from Google Sheets.

Document ID

[Text] Document ID. This identifier is obtained from the link to the sheet.

For example, if we have the link:

"https://docs.google.com/spreadsheets/d/1Y9k3CK7kdJvEjeIW4ROqsfVm9yu08u2vweRPWoV8wqg/edit#gid=0",

then the document id will be: "1Y9k3CK7kdJvEjeIW4ROqsfVm9yu08u2vweRPWoV8wqg".

Sheet Name[Text] The name of the sheet being worked on. If the value is left empty, the default sheet will be used.
Cell Name[Text] The name of the cell. For example: "A1".
Result[Text] The value of the cell.
Error Handling Level

Select the error handling level. Possible values:

  • "Default" - by default;
  • "Ignore" - errors are ignored;
  • "Handle" - errors are handled.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Message Level

Select the message level that blocks will output during operation. Possible values:

  • "Default" - by default;
  • "Release" - output is disabled;
  • "Debug" - main information output;
  • "Detailed" - detailed information output.

If "Default" is selected, the value of the "Start" block of this diagram will be used.

Error Text[Text] Returns detailed information about the error in case of incorrect execution of the block's work.