---
schema_version: "1"
id: 5729eab0bb84eeb6a170002f9b3140cbe5aff4be0702614718117fc42794dad1
title: Google Sheets Connector 1.1 - Examples
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/google-sheets-connector/latest/google-sheets-connector-examples.md
canonical_url: https://docs.mulesoft.com/google-sheets-connector/latest/google-sheets-connector-examples
source_site: docs.mulesoft.com
content_type: documentation
content_hash: f9d2a23436ef76d3a42a9dc253b74f4113e57b4895b81839422f12d702608c69
description: MuleSoft Documentation Site
release: "1.1"
latest: true
---
---
product: Google Sheets Connector
version: 1.1
is-latest-version: true
---

# Google Sheets Connector 1.1 - Examples

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

The following examples show how to use Anypoint Connector for Google Sheets (Google Sheets
Connector) to create a row in an existing spreadsheet.

## Before You Begin

You must have:

- Access to Google Sheets

- OAuth username and password

## Configure HTTP Listener

Configure **HTTP Listener** to initiate a Mule flow when a call is made to the `/` account path on
localhost, port 8081.

This example uses variables for some field values. You can either:

- Replace the variables with their values in the code.

- Provide the values for each variable in a properties file and then refer to that file from the
  connector configuration.

If you don’t know how to use a properties file, see
[Configuring Property Placeholders](https://docs.mulesoft.com/mule-runtime/latest/mule-app-properties-to-configure).

To configure **HTTP Listener**:

1.  Create a new Mule project in Studio.

2.  In the **Mule Palette** view, search for `http` and select the **Listener** operation:

3.  Drag the **Listener** operation onto the canvas.

4.  In the **Listener** configuration, click **+** next to the **Connector configuration** field to
    add a global element.

5.  Click **OK** to accept the defaults.

6.  Set the **Path** field to `/`:

## Add and Configure the Append Spreadsheets Values Operation

1.  In the **Mule Palette** view, search for `Google Sheets` and select the **Append Spreadsheets
    Values** operation.

2.  Drag the **Append Spreadsheets Values** operation onto the canvas, to the right of the **HTTP
    Listener** component.

3.  In the **Append Spreadsheets Values** configuration, click **+** next to the **Connector
    configuration** field to add a global element.

4.  Configure the global element as follows:

    - **Configuration Name**: `Google_Sheets_Connector_Mule4Connector_Config`

    - **Consumer key**: `${config.consumerKey}`

    - **Consumer secret**: `${config.consumerSecret}`

    - **Authorization url**: Leave the default

    - **Access token url**: Leave the default

    - **Callback path**: `${config.callbackPath}`

    - **Authorize path**: `${config.authorizePath}`

5.  Click **Test Connection** to ensure your username, password, and tenant name are correct.

6.  Click **OK**.

## Configure required parameters of the Append Spreadsheets Values Operation

1.  Click the **Append Spreadsheets Values** component.

2.  In the configuration panel of the component, enter your own values for the following parameters,
    for example:

    - **Spreadsheet id**: `19y7nVZPQz3NQSTSGfCh06KXPIqGV2YXohTupmynJyZ5`

    - **range**: `Sheet1!A1`

3.  Click **OK**.

## Add a Logger Component to Display the Response in the Mule Console

1.  In the **Mule Palette** view, search for `logger` and select **Logger (Core)**.

2.  Drag the **Logger** component onto the canvas, to the right of the **Append Spreadsheets
    Values** component.

3.  Configure the following fields:

    <table><colgroup><col> <col></colgroup><thead><tr><th>Field</th><th>Value</th></tr></thead><tbody><tr><td><p><strong>Display Name</strong></p></td><td><p>Enter <code>Log Response</code>.</p></td></tr><tr><td><p><strong>Message</strong></p></td><td><p>Enter <code>`#[payload]`</code>.</p></td></tr><tr><td><p><strong>Level</strong></p></td><td><p>Leave the default, <code>INFO</code>.</p></td></tr></tbody></table>

4.  Create a property file named `mule-artifact.properties` in `src/main/resources` with the
    properties used in this example:

    - `config.consumerKey`

    - `config.consumerSecret`

    - `config.callbackPath`

    - `config.authorizePath`

5.  Save the project.

6.  Test the app by sending a request to `/` on port 8081.

7.  You will receive a JSON response similar to this one:

```xml
{
    "spreadsheetId": "19y7nVZPQz3NQSTSGfCh06KXPIqGV2YXohTupmynJyZ5",
    "tableRange": "Demo!A1:C38",
    "updates": {
        "spreadsheetId": "19y7nVZPQz3NQSTSGfCh06KXPIqGV2YXohTupmynJyZ5",
        "updatedRange": "Demo!A39"
    }
}
```

## Append Spreadsheets Values in a Spreadsheet Example

Paste this code into the Studio XML editor to quickly load the flow for this example into your Mule
app:

```xml
<?xml version="1.0" encoding="UTF-8"?>

<mule xmlns:google-sheets="http://www.mulesoft.org/schema/mule/google-sheets" xmlns:http="http://www.mulesoft.org/schema/mule/http"
	xmlns="http://www.mulesoft.org/schema/mule/core"
	xmlns:doc="http://www.mulesoft.org/schema/mule/documentation" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd
http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/current/mule-http.xsd
http://www.mulesoft.org/schema/mule/google-sheets http://www.mulesoft.org/schema/mule/google-sheets/current/mule-google-sheets.xsd">
	<http:listener-config name="HTTP_Listener_config" doc:name="HTTP Listener config" doc:id="a841f003-9ac4-43bc-8751-10dd557b66d6" >
		<http:listener-connection host="127.0.0.1" port="8081" />
	</http:listener-config>

	<configuration-properties doc:name="Configuration properties" doc:id="7d6911bb-52b4-4d90-8724-62cfe239686a" file="mule-artifact.properties" />

    <flow name="demoFlow" doc:id="481ac26c-b66b-4f9d-b91f-4995ea8ff6a6" >
		<http:listener doc:name="Listener" doc:id="49be04b5-efec-4db6-8c49-d13475533be0" config-ref="HTTP_Listener_config" path="/"/>
		<google-sheets:create-spreadsheets-values-rangeappend-by-spreadsheet-id doc:name="Append Spreadsheets Values" doc:id="2618426a-cca7-41f0-87b2-90ea85045af2" config-ref="Google_Sheets_Connector_Mule4Connector_Config" spreadsheetId="19y7nVZPQz3NQSTSGfCh06KXPIqGV2YXohTupmynJyZ5" range="Demo"/>
		<logger level="INFO" doc:name="Logger" doc:id="9f7181ff-a7ad-4b0c-8300-07b8bd847672" />
	</flow>
</mule>
```

## See Also

- [Introduction to Anypoint Connectors](https://docs.mulesoft.com/connectors/introduction/introduction-to-anypoint-connectors)

- [Salesforce Help](https://help.salesforce.com)