# Files group

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/24D55JgPbzsrruyddf2TZMPGasreHFkEi5dvskClVVDU/edit?gid=1027084744#gid=1027084744`

In this example, `24D55JgPbzsrruyddf2TZMPGasreHFkEi5dvskClVVDU` 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.hidemyacc.com/hidemyacc-3.0-features/automation-feature/create-automation-scripts/files-group.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.