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.

2. Click the project picker at the top of the page, then choose New Project.

Creating a Google Cloud project

1. Enter a project name, such as Cekat Automations.

2. Click Create.

3. 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

• Google Sheets API

• Google Drive API

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

Enabling APIs in Google Cloud

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

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

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.