> ## Documentation Index
> Fetch the complete documentation index at: https://docs.keyflow.space/llms.txt
> Use this file to discover all available pages before exploring further.

# Read From Google Sheets

### **Overview:**

The `Read Google Sheets Data` block efficiently extracts data from a specified sheet within your Google Sheets. This process automates data retrieval, making it a valuable asset for tasks that require regular data access from spreadsheets.

<Note>
  To run this block, you will first need to authenticate your Google account
  with Keyflow. Navigate to your
  [credentials](https://keyflow.space/settings/credentials) page and connect
  your Google Sheets using "Read & Write Google Sheets"
</Note>

***

### Inputs & Outputs

| I/O    | Feature                  | Type         | Simple Explanation                                                                                                      |
| ------ | ------------------------ | ------------ | ----------------------------------------------------------------------------------------------------------------------- |
| input  | `file_link_or_id`        | string       | The link or unique ID of the specific Google Sheet you want to read data from.                                          |
| input  | `sheet_name`             | string       | The name of the specific sheet within the file; defaults to the first sheet if not provided.                            |
| input  | `reader_mode`            | selector     | The mode for retrieving data: options include `Row-by-Row`, `Column-by-Column`, `Specified Row`, or `Specified Column`. |
| input  | `row_index` (optional)   | number       | The index of the row to read, starting at 0; required only when using "Specified Row" as reader\_mode.                  |
| input  | `column_name` (optional) | string       | The name of the column to read, beginning with 'A'; required when using "Specified Column" as reader\_mode.             |
| output | `sheet_data`             | string\[]\[] | Contains the retrieved sheet data organized in rows and columns.                                                        |

***

### Use Cases

Consider how this block can enhance efficiency in various scenarios:

* **Automated Report Generation:** Seamlessly extract relevant information for financial reports or surveys without manual copy-pasting.
* **Scheduled Record Updates:** Easily update records in other applications based on real-time changes made in your Google Sheets.
* **Data Migration:** Facilitate moving datasets from Google Sheets into another system, which could streamline processes like integration or analysis.

In essence, whenever there is a need for quick and reliable access to spreadsheet information, the `Read Google Sheets Data` block proves invaluable!