Google connectors | Zoho Creator Help

Google connectors

Overview

Zoho Creator provides built-in connectors for various popular Google services. These connectors help you automate workflows, sync data, and perform various actions from within Zoho Creator.

The different connectors supported for Google services are: 
  1. Google Sheets
  2. Google Drive
  3. Google Calendar
  4. Google Tasks
  5. Google Contacts
These connectors operate in a bring your own credentials (BYOC) mode, meaning you'll need to provide your own credentials (client ID and client secret) to authorize and establish the connection.

Meta information

Connector
Google Sheets, Google Drive, Google Calendar, Google Tasks, Google Contacts
Authentication type
OAuth 2.0
Data centers
US, IN, EU, AU, CA, SA, JP, and UAE
Applicable for 
C5, C6
Website
Privacy policy
API documentation

Setting up Google connectors

As a prerequisite for creating any of the built-in Google connectors in Zoho Creator, you'll need to obtain a client ID and client secret from the Google Cloud Console. Follow these steps to generate them:
  1. Navigate to https://console.developers.google.com
  2. In the Google Console, you can either create a new project or select an existing one. Click the dropdown at the top of the page next to the project name and choose from the displayed list of projects.
  3. To create a new one, click New Project at the top right.
  4. Create a project with your Google Workspace administrator credentials, and open the project. 
  5. On the project’s welcome page, click APIs and services under the Quick access section.
  6. Click Library in the left sidebar. 
  7. On the API library page, search for and enable the APIs you intend to use (e.g., Google Drive APIGmail APIGoogle Calendar API).
  8. Navigate back to the APIs and services page and select the OAuth consent screen from the left menu.
  9. To configure the OAuth consent screen, begin by filling in the necessary application details, such as the app name, support email, and other required fields. Next, select the appropriate user type—External for public apps or Internal for Google Workspace domain users. Then, add the relevant scopes based on the APIs you intend to use (for example, /auth/drive, /auth/calendar).
  10. To create OAuth credentials, navigate to APIs and services > Credentials. Click + Create credentials and select OAuth Client ID
  11. On the Create OAuth client ID page, choose Web application as the application type. Then, under the Authorized redirect URIs section, add the Zoho Creator redirect URL: https://creator.zoho.com/integration/oauth/callback.
    Note: The redirect URI will vary based on your data center (DC). For example, users in the EU DC should use creator.zoho.eu. Learn more about Creator URL patterns here.
  12. Now the OAuth-created popup will be displayed. Copy the Client ID and the Client secret.
Creating a Google connector in Zoho Creator
  1. Navigate to the Microservices in the left pane and click + Create New. Then click Pick & Create next to Connections. 
  2. The list of built-in connectors will be displayed. Use the search bar to narrow down the Google connectors and select the connector of the required service to create a connection.
  3. Make the required customizations in the Add Connection pane and click Create And Authorize
  4. Next, the Link Account popup will be displayed requesting the Client ID and Client Secret. Paste the values copied from step 12. 
  5. Click Authorize and you'll be redirected to Google's authorization page. Enter your authorization credentials and accept the access permissions. After successful authorization, the connection is ready to be used in your applications. 

Where this connector can be used

Deluge

All actions supported through this connector can be performed using Deluge workflows:
Method
Description
invokeURL
The Deluge invokeURL task can be used to access the Google APIs for the supported actions.

For complete information on the APIs, visit the Google API doc.