---
schema_version: "1"
id: 3c21d6a71f1dda9561e329aef356902a0b4796cfa8aaeb46afc4077483716de0
title: Using Anypoint Studio to Configure Google Sheets Connector 1.1
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/google-sheets-connector/latest/google-sheets-connector-studio.md
canonical_url: https://docs.mulesoft.com/google-sheets-connector/latest/google-sheets-connector-studio
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 0bf6d09cf0334f4e185ff017b573174f128ad8f9311a879569cabe9be8e68f1a
description: MuleSoft Documentation Site
release: "1.1"
latest: true
---
---
product: Google Sheets Connector
version: 1.1
is-latest-version: true
---

# Using Anypoint Studio to Configure Google Sheets Connector 1.1

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

Anypoint Studio (Studio) editors help you design and update your Mule applications, properties, and
configuration files.

To add and configure a connector in Studio:

1.  [Create a Mule project](#create-mule-project).

2.  [Add the connector to your Mule project](#add-connector-to-project).

3.  [Configure an input source for the connector’s flow](#configure-input-source).

4.  [Add a connector operation to the flow](#add-connector-operation).

5.  [Configure a global element for the connector](#configure-global-element).

6.  [Configure the other connector fields](#configure-other-fields).

When you run the connector, you can view the app log to check for problems, as described in
[View the App Log](#view-app-log).

If you are new to configuring connectors in Studio, see
[Using Anypoint Studio to Configure a Connector](https://docs.mulesoft.com/connectors/introduction/intro-config-use-studio).
If, after reading this topic, you need additional information about the connector fields, see the
[Google Sheets Reference](https://docs.mulesoft.com/google-sheets-connector/latest/google-sheets-connector-reference).

## Create a Mule Project

In Studio, create a new Mule project in which to add and configure the connector:

1.  In Studio, select **File > New > Mule Project**.

2.  Enter a name for your Mule project and click **Finish**.

## Add the Connector to Your Mule Project

Add Google Sheets Connector to your Mule project to automatically populate the XML code with the
connector’s namespace and schema location and add the required dependencies to the project’s
`pom.xml` file:

1.  In the **Mule Palette** view, click **(X) Search in Exchange**.

2.  In **Add Modules to Project**, type `google sheets` in the search field.

3.  Click **Google Sheets** in **Available modules**.

4.  Click **Add**.

5.  Click **Finish**.

Adding a connector to a Mule project in Studio does not make that connector available to other
projects in your Studio workspace.

## Configure a Source

A source initiates a flow when a specified condition is met. You can configure one of these sources
to use with Google Sheets Connector:

- **HTTP > Listener**

  Initiates a flow each time it receives a request on the configured host and port

- **Scheduler**

  Initiates a flow when a time-based condition is met

Text for using HTTP Listener as an input source

For example, to configure an HTTP listener, follow these steps:

1.  In the **Mule Palette** view, select **HTTP > Listener**.

2.  Drag **Listener** to the Studio canvas.

3.  On the **Listener** configuration screen, optionally change the value of the **Display Name**
    field.

4.  Specify a value for the **Path** field.

5.  Click the plus sign (+) next to the **Connector configuration** field to configure a global
    element that can be used by all instances of HTTP **Listener** in the app.

6.  On the **General** tab, specify connection information for the connector.

7.  On the **TLS** tab, optionally specify the TLS information for the connector.

8.  On the **Advanced** tab, optionally specify reconnection information, including a reconnection
    strategy.

9.  Click **Test Connection** to confirm that Mule can connect with the specified server.

10. Click **OK**.

## Add a Connector Operation to the Flow

When you add a connector operation to your flow, you immediately define a specific operation for
that connector to perform.

To add an operation for Google Sheets Connector, follow these steps:

1.  In the **Mule Palette** view, select **Google Sheets** and then select the desired operation.

2.  Drag the operation onto the Studio canvas to the right of the input source.

Each Google Sheets operation has its own required fields in Anypoint Studio. For more information,
see the [Google Sheets Connector Reference](https://docs.mulesoft.com/google-sheets-connector/latest/google-sheets-connector-reference).

## Configure a Global Element for the Connector

When you configure a connector, it’s best to configure a global element that all instances of that
connector in the app can use. Configuring a global element requires you to provide the
authentication credentials that the connector requires to access the target Google Sheets system.
Google Sheets Connector supports OAuth 2.0 authorization.

To configure the global element for Google Sheets Connector, follow these steps:

1.  Select the name of the connector in the Studio canvas.

2.  In the configuration screen for the operation, click the plus sign (+) next to the **Connector
    configuration** field to access the global element configuration fields.

3.  On the **General** tab, configure the authentication for the connection as described in
    [OAuth Authentication](#oauth-authentication).

    You can reference a configuration file that contains ANT-style property placeholders
    (recommended), or you can enter your authorization credentials in the global configuration
    properties. For information about the benefits of using property placeholders and how to
    configure them, see
    [Anypoint Connector Configuration](https://docs.mulesoft.com/connectors/introduction/intro-connector-configuration-overview).

4.  On the **Advanced** tab, optionally specify reconnection information, including a reconnection
    strategy.

5.  Click **Test Connection** to confirm that Mule can connect with the specified server.

6.  Click **OK**.

### OAuth 2.0 Authentication

Use OAuth 2.0 to delegate user authentication to the service hosting the user account. For more
information, refer to
[Configuring OAuth 2.0 for Connectors](https://docs.mulesoft.com/connectors/introduction/intro-config-oauth2),
[Configuring OAuth 2.0 for Connectors on CloudHub](https://docs.mulesoft.com/connectors/introduction/intro-config-oauth2-cloudhub),
or [OAuth Support in the SDK](https://docs.mulesoft.com/mule-sdk/latest/oauth).

Enter the following information on the **General** tab of the **Global Element Properties** screen
to configure OAuth 2.0 Authentication:

<table><colgroup><col> <col></colgroup><thead><tr><th>Field</th><th>Description</th></tr></thead><tbody><tr><td><p><strong>Consumer key</strong></p></td><td><div><div><p>Enter a consumer key belonging to your authentication server’s client application.</p></div></div></td></tr><tr><td><p><strong>Consumer password</strong></p></td><td><div><div><p>Enter a consumer password belonging to your authentication server’s client application.</p></div></div></td></tr><tr><td><p><strong>Authorization url</strong></p></td><td><div><div><p>URL for the OAuth 2.0 authorization, filled in by the connector.</p></div></div></td></tr><tr><td><p><strong>Access token url</strong></p></td><td><div><div><p>URL for the access token, filled in by the connector.</p></div></div></td></tr><tr><td><p><strong>Scopes</strong></p></td><td><div><div><p>Scopes used by the connector.</p></div></div></td></tr><tr><td><p><strong>Callback path</strong></p></td><td><div><div><p>Callback path used during the Oauth dance.</p></div></div></td></tr><tr><td><p><strong>Authorize path</strong></p></td><td><div><div><p>Authorize path used during the Oauth dance.</p></div></div></td></tr><tr><td><p><strong>Object store</strong></p></td><td><div><div><p>Object store to contain the access tokens created during the authorization.</p></div></div></td></tr></tbody></table>

## Configure Additional Connector Fields

After you configure a global element for Google Sheets Connector, configure the other required
fields for the connector, as described in the
[Google Sheets Connector Reference](https://docs.mulesoft.com/google-sheets-connector/latest/google-sheets-connector-reference).

## View the App Log

To check for problems, you can view the app log as follows:

- If you’re running the app from Anypoint Platform, the app log output is visible in the Anypoint
  Studio console window.

- If you’re running the app using Mule from the command line, the app log output is visible in your
  OS console.

Unless the log file path is customized in the app’s log file (`log4j2.xml`), you can also view the
app log in the default location `MULE_HOME/logs/<app-name>.log`. You can configure the location of
the log path in the app log file `log4j2.xml`.

## Next Step

After you configure a global element and connection information, configure the other fields for the
connector.

## See Also

- [Google Sheets Reference](https://docs.mulesoft.com/google-sheets-connector/latest/google-sheets-connector-reference)

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