--- title: "Google API Setup to Connect with Google Sheets" url: https://docs.coolplugins.net/doc/google-api-setup-connect-elementor-google-sheets/ date: 2025-12-25 modified: 2025-12-30 author: "Satinder Singh" description: "Before securely connecting your Elementor forms with Google Sheets, you’ll need to generate a Google API authentication token using the Google Cloud Console. This token allows FormsDB for Elementor to send form data to..." categories: - "FormsDB For Elementor Forms" word_count: 300 --- # Google API Setup to Connect with Google Sheets Before securely connecting your **Elementor forms** with **Google Sheets**, you’ll need to generate a **Google API authentication token** using the Google Cloud Console. This token allows **FormsDB for Elementor** to send form data to your Google Sheets safely and automatically. https://youtu.be/CV3ZtcOVWzU ## Create Google API Credentials Follow the steps below to generate a Google API authentication token: - Open the [**Google Cloud Console**](https://console.cloud.google.com/apis/credentials) in Chrome browser. - Click **Select Project** at the top and then click **New Project**. [![new project](https://docs.coolplugins.net/wp-content/uploads/2025/12/new-project-800x556.jpg)](https://docs.coolplugins.net/wp-content/uploads/2025/12/new-project.jpg) - Enter a project name, choose a location, and click **Create**. [![new project details](https://docs.coolplugins.net/wp-content/uploads/2025/12/new-project-details-800x360.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/new-project-details.png) - Once the project is created, select it from the **Select Project** dropdown. [![select a project](https://docs.coolplugins.net/wp-content/uploads/2025/12/select-a-project-800x211.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/select-a-project.png) - Next, navigate to the **Enabled APIs & services** section. [![enable api and services](https://docs.coolplugins.net/wp-content/uploads/2025/12/enable-api-and-services-800x308.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/enable-api-and-services.png) - Here, search and enable the **Google Drive API** and **Google Sheets API**. [![enable google drive api](https://docs.coolplugins.net/wp-content/uploads/2025/12/enable-google-drive-api-800x413.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/enable-google-drive-api.png) [![enable google sheets api](https://docs.coolplugins.net/wp-content/uploads/2025/12/enable-google-sheets-api-800x385.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/enable-google-sheets-api.png) - After enabling the APIs, go **OAuth consent screen**. [![OAuth consent screen](https://docs.coolplugins.net/wp-content/uploads/2025/12/consent-screen.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/consent-screen.png) - Click the **Get Started** button. [![click get started](https://docs.coolplugins.net/wp-content/uploads/2025/12/click-get-started-800x410.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/click-get-started.png) - Under **App information**, enter your app name and user support email, then click **Next**. - In the **Audience** section, select **External** and click **Next**. - Under **Contact information**, enter your email address and click **Next**. - Accept the data policy and click **Continue** to complete the OAuth consent setup. [![project configuration](https://docs.coolplugins.net/wp-content/uploads/2025/12/project-configuration.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/project-configuration.png) - Click **Create OAuth Client ID**. [![create OAuth client](https://docs.coolplugins.net/wp-content/uploads/2025/12/create-OAuth-client-800x244.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/create-OAuth-client.png) - Select **Web Application** as the application type and enter a name for the client. - Click **Add Authorized Redirect URI**. [![create OAuth client id](https://docs.coolplugins.net/wp-content/uploads/2025/12/create-OAuth-client-id.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/create-OAuth-client-id.png) - From your WordPress dashboard, you can access this redirect URI by navigating to **Elementor > FormsDB > Settings**.  [![redirect URI](https://docs.coolplugins.net/wp-content/uploads/2025/12/redirect-URI.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/redirect-URI.png) - Copy the redirect URI, and paste it into the **Authorized Redirect URIs** field in Google Cloud. - Click **Create** to generate the OAuth credentials. - Copy the **Client ID** and **Client Secret**. [![cliend id and secret key](https://docs.coolplugins.net/wp-content/uploads/2025/12/cliend-id-and-secret-key.jpg)](https://docs.coolplugins.net/wp-content/uploads/2025/12/cliend-id-and-secret-key.jpg) ## Generate Authentication Token - Paste the Client ID and Client Secret into the **FormsDB settings**. (From your WordPress dashboard, **Elementor > FormsDB > Settings)** [![enter client id and secret key](https://docs.coolplugins.net/wp-content/uploads/2025/12/enter-client-id-and-secret-key-800x419.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/enter-client-id-and-secret-key.png) - Now, from the Google Cloud Console, go to the **Audience** section and click **Publish App**. [![publish app](https://docs.coolplugins.net/wp-content/uploads/2025/12/publish-app-800x292.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/publish-app.png) - Return to **FormsDB settings** in Elementor and open the **Settings** tab. - Click **Generate Authentication Token**. [![generate authentication token](https://docs.coolplugins.net/wp-content/uploads/2025/12/generate-authentication-token-800x461.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/generate-authentication-token.png) - Log in with your Google account. If a security warning appears, click **Advanced**, then choose **Go to (unsafe)** to proceed. [![click advanced tab](https://docs.coolplugins.net/wp-content/uploads/2025/12/click-advanced-tab-800x426.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/click-advanced-tab.png) - Allow the requested permissions and click **Continue**. [![grant permissions](https://docs.coolplugins.net/wp-content/uploads/2025/12/grant-permissions-800x720.png)](https://docs.coolplugins.net/wp-content/uploads/2025/12/grant-permissions.png) - The Google API authentication token will be generated, and your Google Sheets account will be successfully connected. Now, your **Elementor form data** will be automatically **saved to Google Sheets**.