# Google Sheets integration

> Build workflow automations with 10 public Google Sheets actions.

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

## Available actions

10 actions. Connection types: google_sheets.

### [Append Row](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_append_row.md)

- Handler: `google_sheets_append_row`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `spreadsheet_id`, `sheet_title`, `header_row`, `headers`, `values`, `value_input_option`, `write_enabled`
- Outputs: `success`, `submitted`, `write_skipped`, `skip_reason`, `spreadsheet_id`, `updated_range`, `updated_cells`, `error`, `error_message`

Perform Append Row through Google Sheets.

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

- Handler: `google_sheets_batch_get_values`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `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 Cells](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_batch_update_cells.md)

- Handler: `google_sheets_batch_update_cells`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `spreadsheet_id`, `sheet_title`, `header_row`, `headers`, `row_updates`, `value_input_option`, `write_enabled`
- Outputs: `success`, `submitted`, `write_skipped`, `skip_reason`, `spreadsheet_id`, `row_update_count`, `updated_cells`, `updated_rows`, `error`, `error_message`

Perform Batch Update Cells 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`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `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.

### [Create Sheet From Upload](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_create_from_upload.md)

- Handler: `google_sheets_create_from_upload`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `document_id`, `title`, `sheet_title`, `source_format`, `write_enabled`
- Outputs: `success`, `submitted`, `write_skipped`, `skip_reason`, `spreadsheet_id`, `spreadsheet_url`, `sheet_title`, `row_count`, `column_count`, `drive_folder_id`, `error`, `error_message`

Perform Create Sheet From Upload through Google Sheets.

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

- Handler: `google_sheets_get_rows`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `spreadsheet_id`, `sheet_title`, `header_row`, `max_rows`, `filter_column`, `filter_value`, `skip_empty_rows`
- Outputs: `success`, `spreadsheet_id`, `sheet_title`, `headers`, `rows`, `row_count`, `truncated`, `error`, `error_message`

Perform Get Rows 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`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `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`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `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`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `spreadsheet_id`
- Outputs: `success`, `spreadsheet_id`, `tabs`, `tab_count`, `visible_tabs`, `visible_tab_count`, `error`, `error_message`

Perform List Tabs through Google Sheets.

### [Update Cells](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_update_cells.md)

- Handler: `google_sheets_update_cells`
- Connection type: `google_sheets`
- External effect: `write`
- Inputs: `google_sheets_account_id`, `spreadsheet_id`, `sheet_title`, `header_row`, `headers`, `row_number`, `updates`, `value_input_option`, `write_enabled`
- Outputs: `success`, `submitted`, `write_skipped`, `skip_reason`, `spreadsheet_id`, `row_number`, `updated_cells`, `updated_rows`, `error`, `error_message`

Perform Update Cells through Google Sheets.