# Sheets - Append task

> [!WARNING]
>
> **Preview
> --- BigQuery Connector**
>
>
> This feature is
>
> subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the
> [Service Specific
> Terms](https://docs.cloud.google.com/terms/service-terms#1).
>
> Pre-GA features are available "as is" and might have limited support.
>
> For more information, see the
> [launch stage descriptions](https://cloud.google.com/products/#product-launch-stages).


The **Sheets - Append** task lets you append data after a specified table of data in a Google spreadsheet. New values are appended to the new row that is created after the specified table, starting with the first column of the table.

> [!IMPORTANT]
> **Spreadsheet:** The primary object in Google Sheets that can contain multiple sheets. Each [sheet](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/sheets) has structured information contained in [cells](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/cells).
>
> You can find the ID of your spreadsheet from its web URL. For example, `https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit#gid=0`


[Google Sheets](https://developers.google.com/sheets) is one of the many cloud-based productivity solutions in [Google Workspace](https://docs.cloud.google.com/workspace). It allows you to create and edit online spreadsheets with real-time collaboration functionality.

## Before you begin

Ensure that you perform the following tasks in your Google Cloud project before configuring the **Sheets - Append** task:

1. Enable the Google Sheets API (`sheets.googleapis.com`).


   [Enable the Google Sheets API](https://console.cloud.google.com/apis/enableflow?apiid=sheets.googleapis.com)
2. Create an [authentication profile](https://docs.cloud.google.com/application-integration/docs/configuring-auth-profile#createAuthProfile). Application Integration uses an authentication profile to connect to an authentication endpoint for the **Sheets - Append** task.

   For information about granting additional roles or permissions to a service account, see [Granting, changing, and revoking access](https://docs.cloud.google.com/iam/docs/granting-changing-revoking-access.md.txt).
3. Understand and learn about the [common terminologies](https://developers.google.com/sheets/api/guides/concepts) used in Google Sheet.

## Configure the Sheets - Append task

1. In the Google Cloud console, go to the **Application Integration** page.

   [Go to Application Integration](https://console.cloud.google.com/integrations)
2. In the navigation menu, click **Integrations** .


   The **Integrations** page appears listing all the integrations available in the Google Cloud project.
3. Select an existing integration or click **Create integration** to create a new one.


   If you are creating a new integration:
   1. Enter a name and description in the **Create Integration** pane.
   2. Select a region for the integration.

      > [!NOTE]
      > **Note:** The **Regions** dropdown only lists the regions provisioned in your Google Cloud project. To provision a new region, click **Enable Region** . See [Enable new region](https://docs.cloud.google.com/application-integration/docs/enable-new-region.md.txt) for more information.

   3. Select a service account for the integration. You can change or update the service account details of an integration any time from the **Integration summary** pane in the integration toolbar.

      > [!NOTE]
      > **Note:** The option to select a service account is displayed only if you have enabled integration governance for the selected region.

   4. Click **Create** . The newly created integration opens in the *integration editor*.


4. In the *integration editor* navigation bar, click **Tasks** to view the list of available tasks and connectors.
5. Click and place the **Sheets - Append** element in the integration editor.
6. Click the **Sheets - Append** element on the designer to view the **Sheets - Append** task configuration pane.
7. Go to **Authentication** , and select an existing authentication profile that you want to use.

   Optional. If you have not created an authentication profile prior to configuring the task, Click **+ New authentication profile** and follow the steps as mentioned in [Create a new authentication profile](https://docs.cloud.google.com/application-integration/docs/configuring-auth-profile#createAuthProfile).
8. Go to **Task Input** , and configure the displayed inputs fields using the following [Task input parameters](https://docs.cloud.google.com/application-integration/docs/gcp-tasks/configure-sheets-append-task.md.txt#params) table.

   Changes to the inputs fields are saved automatically.

## Task input parameters


The following table describes the input parameters of the **Sheets - Append** task:

| Property | Data type | Description |
|---|---|---|
| SpreadsheetId | String | The ID of your spreadsheet. You can find the ID of your spreadsheet from its web URL. For example, `https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit#gid=0` |
| Range | String | The [A1 notation](https://developers.google.com/sheets/api/guides/concepts#cell) of a range to search for the desired table in the sheet. |
| IncludeValuesInResponse | Boolean | Indicates if the returned object should include the values of the cells that were appended values. |
| InsertDataOption | enum [(InsertDataOption)](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append#InsertDataOption) | Indicates how the existing data will be changed when the new data is appended. |
| ValueInputOption | enum [(ValueInputOption)](https://developers.google.com/sheets/api/reference/rest/v4/ValueInputOption) | Indicates how the data is interpreted. **Default value:** `INPUT_VALUE_OPTION_UNSPECIFIED` |
| ResponseDateTimeRenderOption | enum [(DateTimeRenderOption)](https://developers.google.com/sheets/api/reference/rest/v4/DateTimeRenderOption) | Indicates how values related to date, time, and duration is represented in the output. > [!NOTE] > **Note:** **dateTimeRenderOption** is not considered if the value specified for **valueRenderOption** is `FORMATTED_VALUE`. **Default value:** `SERIAL_NUMBER` |
| ResponseValueRenderOption | enum [(ValueRenderOption)](https://developers.google.com/sheets/api/reference/rest/v4/ValueRenderOption) | Indicates how the retrieved values are represented in the output. **Default value:** `FORMATTED_VALUE` |
| Request | JSON | The request body is a [ValueRange](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values#resource:-valuerange) object that describes range values to write. See [request JSON structure](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append#request-body). |

## Task output

The **Sheets - Append** task returns the response output containing a [AppendValuesResponse](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append#body.response_body) object, similar to the following sample output:

```json
    {
        "spreadsheetId": SPREADSHEET_ID,
        "tableRange": "Sheet1!A1:D2",
        "updates": {
          "spreadsheetId": SPREADSHEET_ID,
          "updatedRange": "Sheet1!A3:D4",
          "updatedRows": 2,
          "updatedColumns": 4,
          "updatedCells": 8,
        }
      }
```

## Error handling strategy


An error handling strategy for a task specifies the action to take if the task fails due to a [temporary error](https://docs.cloud.google.com/application-integration/docs/error-handling.md.txt). For information about how to use an error handling strategy, and to know about the different types of error handling strategies, see [Error handling strategies](https://docs.cloud.google.com/application-integration/docs/error-handling-strategy.md.txt).

## Quotas and limits

For information about quotas and limits, see [Quotas and limits](https://docs.cloud.google.com/application-integration/docs/quotas.md.txt).

## What's next

- Add [edges and edge conditions](https://docs.cloud.google.com/application-integration/docs/edge-overview).
- [Test and publish](https://docs.cloud.google.com/application-integration/docs/test-publish-integrations.md.txt) your integration.
- Configure a [trigger](https://docs.cloud.google.com/application-integration/docs/how-to-guides#configure-triggers).
- Add a [Data Mapping task](https://docs.cloud.google.com/application-integration/docs/data-mapping-task).
- See [all tasks for Google Cloud services](https://docs.cloud.google.com/application-integration/docs/how-to#configure-tasks-for-google-cloud-services).