En

Get Range Value#

Get the range value 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.
Range[Text] Range. For example: "A1:C3".
Has HeadersIf enabled, the first row of the read range will be treated as the header of the table columns.
Result[Data Table] A table with the retrieved data.
Error Handling Level

Select the error handling level. Possible values:

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

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

Message Level

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

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

If "Default" is selected, the value from 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.