Google Sheets authentication

Prerequisites

Depending on the authentication type you select, you need one of the following:

• Your Google email address and the password associated with your Google account.
• Your application's Client ID and Client secret.

If your account is not enabled by Google:

• Reach out to your administrator for approvals on creating connections.
• Enable permission by checking the options available to allow creating a connection.

For more information on Google sheets documentation, refer to Google Sheets for Developers.

Add the Google Sheets connection

1. Select Integration Service from Automation Cloud.
2. From the Connectors list, select Google Sheets. You can also use the search bar to find the connector.
3. Select the Add connection button.
4. You are now redirected to the connection page. You can choose between two authentication types: OAuth 2.0 Authorization code or Bring your own OAuth 2.0 app.

   • If you select OAuth 2.0 Authorization code, click Connect, then authenticate using your Google email address and password.
   • If you select Bring your own OAuth 2.0 app, you must provide a Client ID and Client secret.
5. Your connection has been added.

Permissions

Connecting allows UiPath products to interact with Google Sheets data on your behalf. This may include read, write, modify and delete data, depending on your Google Docs permissions. You can always remove any access in your Google Account.