# Google AppSheet

> Find, add, edit and delete AppSheet table rows, and run an app action.

App · 5 actions. Web page: https://docs.lodol.com/docs/integrations/google-appsheet

## Actions

### Add rows

Add rows in your connected AppSheet app.

**Inputs**

- Table name (`table_name`, text, required): The table name shown in Data > Tables in your app.
- Rows (`rows`, list, required): Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector (`selector`, text): An AppSheet FILTER or SELECT expression to choose rows.
- Locale (`locale`, text): Locale for interpreting dates and numbers, such as en-US.
- Time zone (`time_zone`, text): Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email (`run_as_user_email`, text): Email of the user to run this request as, when your app permits it.

**Outputs**

- `data` (list): Google App Sheet response data.

**Example output**

```json
{
  "data": []
}
```

### Delete rows

Delete rows in your connected AppSheet app.

**Inputs**

- Table name (`table_name`, text, required): The table name shown in Data > Tables in your app.
- Rows (`rows`, list, required): Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector (`selector`, text): An AppSheet FILTER or SELECT expression to choose rows.
- Locale (`locale`, text): Locale for interpreting dates and numbers, such as en-US.
- Time zone (`time_zone`, text): Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email (`run_as_user_email`, text): Email of the user to run this request as, when your app permits it.

**Outputs**

- `data` (list): Google App Sheet response data.

**Example output**

```json
{
  "data": []
}
```

### Edit rows

Edit rows in your connected AppSheet app.

**Inputs**

- Table name (`table_name`, text, required): The table name shown in Data > Tables in your app.
- Rows (`rows`, list, required): Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector (`selector`, text): An AppSheet FILTER or SELECT expression to choose rows.
- Locale (`locale`, text): Locale for interpreting dates and numbers, such as en-US.
- Time zone (`time_zone`, text): Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email (`run_as_user_email`, text): Email of the user to run this request as, when your app permits it.

**Outputs**

- `data` (list): Google App Sheet response data.

**Example output**

```json
{
  "data": []
}
```

### Find rows

Find rows in your connected AppSheet app.

**Inputs**

- Table name (`table_name`, text, required): The table name shown in Data > Tables in your app.
- Rows (`rows`, list): Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector (`selector`, text): An AppSheet FILTER or SELECT expression to choose rows.
- Locale (`locale`, text): Locale for interpreting dates and numbers, such as en-US.
- Time zone (`time_zone`, text): Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email (`run_as_user_email`, text): Email of the user to run this request as, when your app permits it.

**Outputs**

- `data` (list): Google App Sheet response data.

**Example output**

```json
{
  "data": []
}
```

### Run table action

Run table action in your connected AppSheet app.

**Inputs**

- Table name (`table_name`, text, required): The table name shown in Data > Tables in your app.
- Action name (`action_name`, text, required): The name of an existing action in your AppSheet app.
- Rows (`rows`, list, required): Rows as column-name/value objects. For edits and deletes, include the key columns; for Find, leave empty to read all rows.
- Selector (`selector`, text): An AppSheet FILTER or SELECT expression to choose rows.
- Locale (`locale`, text): Locale for interpreting dates and numbers, such as en-US.
- Time zone (`time_zone`, text): Timezone used to interpret date and time values, such as America/Los_Angeles.
- Run as user email (`run_as_user_email`, text): Email of the user to run this request as, when your app permits it.

**Outputs**

- `data` (list): Google App Sheet response data.

**Example output**

```json
{
  "data": []
}
```
