# Read rows from Google Sheets

Looks for rows in a Google spreadsheet, saves values to variables and shows the rows to the person.

![Settings panel of the "Read rows from Google Sheets" block](https://support.watbot.org/_media/en/01-chatbots/03-blocks/07-lists/_images/google-sheet-reader.webp?v=1791781230)

## Settings

"Link to table", "Sheet", "Range of rows to process" and "Filters" — as in the [common settings](https://support.watbot.org/chatbots/blocks/lists#common-settings-of-google-sheets-blocks).

- **"Sorting"** — the column and the order: "Asc" or "Desc".
- **"Variables from the table"** — which variable to save which column's value to. The "Add variable" and "Add global variable" buttons choose where to write: to a contact variable or to a global variable of the bot. The value from the first row found is saved.
- **"Messages chain template"** — what to send to the person for each row:
  - "Template" — text. A cell value is inserted by its column letter: `{{ A }}`, `{{ B }}`;
  - "Photo" and "File" — the letter of the column whose cell holds a direct link to a picture or a file.
- **"Number of records in a message"** — how many rows to show, from 1 to 100.
- **"Process table using JavaScript"** — turns on the "JavaScript for table processing" field. In the code, the rows found are available as `sheet.data` — an array of rows, each row being an array of cells. Which columns to load for the code is set by calling `setColumnRange("A:Z")`. See [Built-in variables](https://support.watbot.org/api/javascript/builtins#sheet-rows) for details.
- **"Menu"** — the block's buttons.

The saved values are then used like regular variables: `{{ $price }}` — see [Data you can insert](https://support.watbot.org/chatbots/templates/data) for details. You can leave the template empty if you only need the variables.

## Outputs

- "No records found" — the range has no rows that match the filters. The variables are not changed in this case.
- Buttons from "Menu" — the person pressed a button.
- "Any other phrase" — the person wrote something else.
- "Continue" — right after the variables are saved and the rows are sent.

> [!NOTE]
> If "Continue" is not connected to anything and "Any other phrase" is connected, the bot follows "Any other phrase" right after showing the rows, without waiting for a reply.