# Google Sheets integration

> Build workflow automations with 5 public Google Sheets actions.

Source: [https://genhealth.ai/docs/workflows/integrations/google-sheets](https://genhealth.ai/docs/workflows/integrations/google-sheets)

## Available actions

5 actions. Connection types: None required.

### [Batch Get Values](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_batch_get_values.md)

- Handler: `google_sheets_batch_get_values`

- External effect: `write`
- Inputs: `spreadsheet_id`, `ranges`, `major_dimension`
- Outputs: `success`, `spreadsheet_id`, `value_ranges`, `range_count`, `error`, `error_message`

Perform Batch Get Values through Google Sheets.

### [Batch Update Values](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_batch_update_values.md)

- Handler: `google_sheets_batch_update_values`

- External effect: `write`
- Inputs: `spreadsheet_id`, `data`, `value_input_option`, `expected_data`, `require_expected_match`, `write_enabled`
- Outputs: `success`, `submitted`, `write_skipped`, `skip_reason`, `conflict`, `conflicting_ranges`, `spreadsheet_id`, `updated_range_count`, `updated_rows`, `updated_columns`, `updated_cells`, `error`, `error_message`

Perform Batch Update Values through Google Sheets.

### [Get Spreadsheet Metadata](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_get_spreadsheet_metadata.md)

- Handler: `google_sheets_get_spreadsheet_metadata`

- External effect: `write`
- Inputs: `spreadsheet_id`, `include_grid_data`
- Outputs: `success`, `spreadsheet_id`, `title`, `tabs`, `tab_count`, `error`, `error_message`

Perform Get Spreadsheet Metadata through Google Sheets.

### [Get Values](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_get_values.md)

- Handler: `google_sheets_get_values`

- External effect: `write`
- Inputs: `spreadsheet_id`, `range_name`, `major_dimension`
- Outputs: `success`, `spreadsheet_id`, `range`, `values`, `row_count`, `column_count`, `error`, `error_message`

Perform Get Values through Google Sheets.

### [List Tabs](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_list_tabs.md)

- Handler: `google_sheets_list_tabs`

- External effect: `write`
- Inputs: `spreadsheet_id`
- Outputs: `success`, `spreadsheet_id`, `tabs`, `tab_count`, `visible_tabs`, `visible_tab_count`, `error`, `error_message`

Perform List Tabs through Google Sheets.