Files group

A collection of commands to help you work with files (Google Sheets, Excel)

These commands allow you to read and retrieve data from Google Sheets or Excel files.

1. Variable

You need to declare a new variable to store data after retrieving it from the file. The retrieved data will be stored as an array. The format of the variable is googleSheets.variableName. Note: The variable name should not contain special characters or spaces.

2. File You can choose between an Excel file or a Google Sheet file.

• For an Excel file, you need to specify the correct file path.

• For a Google Sheet file, you need to enter the correct spreadsheet ID. Example of a link: https://docs.google.com/spreadsheets/d/14P23JgPbzsrruyddf2TZMPGasreHFkEi5dvskClVVDU/edit?gid=1027084744#gid=1027084744

In this example, 14P23JgPbzsrruyddf2TZMPGasreHFkEi5dvskClVVDU is the spreadsheet ID.

3. Range

Enter the sheet name and the columns you want to retrieve data from. If no range is entered, the system will retrieve all data from the first file. For example, in the file below, if you want to get data from cell A1 to D7 in Sheet 2, you would enter: Sheet 2!A1:D7

If the first row in the file contains column headers, you can check the box "Use the first row as keys" so that the system doesn't retrieve data from the first row.\

4. Description (optional)

Enter a description or note for the command. This is optional, and you are not required to fill it in.

5. Preview data

This feature allows you to preview the data retrieved from the file.