> For the complete documentation index, see [llms.txt](https://docs.cekat.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cekat.ai/en/automation-and-developer/connect-gmail-and-google-sheets-to-cekat-automations.md).

# How to Connect Gmail and Google Sheets to Cekat Automations

Cekat Automations can connect to Gmail and Google Sheets through an OAuth connection. This guide walks you through creating a Google Cloud project, turning on the APIs you need, creating OAuth credentials and connecting them to your automation.

## Step 1: Create a Google Cloud project

1. Open the [Google Cloud Console](https://console.cloud.google.com/).
2. Click the project picker at the top of the page, then choose **New Project**.

![Creating a Google Cloud project](https://3693109682-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZNZlvyOVkZXyd3pz2Cql%2Fuploads%2FWjOcA4WXtG10jOlUnUnO%2Fgoogle-cloud-project.png?alt=media)

3. Enter a project name, such as **Cekat Automations**.
4. Click **Create**.
5. Once the project is created, make sure it's selected in the project picker.

## Step 2: Turn on the required APIs

From **APIs & Services → Library**, search for and enable these APIs:

* [Gmail API](https://console.cloud.google.com/apis/library/gmail.googleapis.com)
* [Google Sheets API](https://console.cloud.google.com/apis/library/sheets.googleapis.com)
* [Google Drive API](https://console.cloud.google.com/apis/library/drive.googleapis.com)

The Google Drive API is needed so Google Sheets can find, create and watch spreadsheets.

![Enabling APIs in Google Cloud](https://3693109682-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZNZlvyOVkZXyd3pz2Cql%2Fuploads%2FDXdT7TKHukRofTh2gs2c%2Fgoogle-apis.png?alt=media)

## Step 3: Set up the OAuth consent screen

1. Go to **APIs & Services → OAuth consent screen**.
2. Choose **External**, unless you use Google Workspace and need an internal setup.
3. Click **Create**.
4. Fill in the app details:
   * **App name:** Cekat Automations
   * **User support email:** your support or administrator email
   * **Developer contact information:** your administrator email
5. Click **Save and Continue** until you reach **Scopes** and **Test users**.
6. On the summary page, click **Back to Dashboard**.
7. If the app is still in **Testing** mode, add the Google account you'll be using as a **Test User**.

## Step 4: Create an OAuth client ID and client secret

1. Go to **APIs & Services → Credentials**.
2. Click **+ Create Credentials**, then choose **OAuth client ID**.
3. Under **Application type**, choose **Web application**.
4. Enter a name for the credential, such as **Cekat Automations Web**.
5. Under **Authorized redirect URIs**, click **+ Add URI**.
6. Enter the **Redirect URL** shown on the Cekat Automations connection page.
7. Leave **Authorized JavaScript origins** empty unless your setup needs it.
8. Click **Create**.
9. Copy the **Client ID** and **Client Secret** for the next step.

![Creating OAuth credentials](https://3693109682-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZNZlvyOVkZXyd3pz2Cql%2Fuploads%2FwzGyNwEUuoKVYva2tOqo%2FWhatsApp%20Image%202026-09-30%20at%203.37.29%20PM.jpeg?alt=media\&token=1363b459-585e-4304-a95e-fcee0df23dcc)

> Never share your Client Secret publicly or put it inside a workflow.

## Step 5: Connect to Cekat Automations

1. Open your automation in Cekat Automations.
2. Add a Gmail or Google Sheets node.
3. Click **Create Connection** or **Add Connection**.
4. Enter the **Client ID** and **Client Secret** from Google Cloud.
5. Click **Connect**.
6. Follow Google's login and authorization steps.
7. Once that's done, go back to your automation and carry on setting up the node.

![Connecting Gmail or Google Sheets](https://3693109682-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZNZlvyOVkZXyd3pz2Cql%2Fuploads%2FwzGyNwEUuoKVYva2tOqo%2FWhatsApp%20Image%202026-09-30%20at%203.37.29%20PM.jpeg?alt=media\&token=1363b459-585e-4304-a95e-fcee0df23dcc)

Once the connection is set up, you can use Gmail and Google Sheets in your automations through the nodes available in your workspace.

## Permissions requested

During OAuth, Google asks for permissions based on the services you're using:

* **Gmail:** send email, read email, and create or manage drafts.
* **Google Sheets:** access spreadsheets and Google Drive to find or pick a spreadsheet.
* **Google account:** identify the connected account.

Google shows you a summary of these permissions before you finish authorizing.