--- title: "Automatically Save Elementor Form Submissions to Google Sheets" url: https://coolplugins.net/automatically-save-elementor-form-submissions-to-google-sheets/ date: 2025-12-20 modified: 2026-05-25 author: "Satinder Singh" description: "FormsDB automatically saves Elementor form submissions to Google Sheets in real time for better organization and accessibility. The plugin securely connects Elementor Forms with Google Sheets using Google API authentication through Google Cloud Console credentials. Users can configure Elementor forms to send submissions directly into selected Google Spreadsheet tabs automatically after form submission. FormsDB also allows Elementor form submissions to be saved as WordPress posts, pages, media, or custom post types. The plugin supports logged-in user restrictions, custom sheet mapping, and automated data management without requiring coding knowledge." categories: - "Elementor" - "Elementor Form" - "WordPress Tips" image: https://coolplugins.net/wp-content/uploads/2025/12/Elementor-Form-Submissions-800x450.png word_count: 698 --- # Automatically Save Elementor Form Submissions to Google Sheets Are you using Elementor forms and want every submission to be automatically saved in **Google Sheets**? With the **[FormsDB For Elementor Forms](https://wordpress.org/plugins/sb-elementor-contact-form-db/advanced/)**, all your form submissions are automatically saved to Google Sheets or Posts in real time. ## What is FormsDB For Elementor Forms? **[FormsDB For Elementor Forms](https://wordpress.org/plugins/sb-elementor-contact-form-db/advanced/)** acts as a bridge between **Elementor Forms **and **Google Sheets**. Once your Elementor form is connected with Google Sheets, every new form submission is instantly added as a new row, keeping your data organized, accessible, and always up to date. [![FormsDB infographics](https://coolplugins.net/wp-content/uploads/2025/12/FormsDB-infographics-800x403.jpg)](https://coolplugins.net/wp-content/uploads/2025/12/FormsDB-infographics.jpg) 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. ### How to Generate a Google API Authentication Token Follow the steps below to generate a Google API authentication token: - First, make sure that you have installed and activated **Elementor / Hello Plus **and **[FormsDB For Elementor Forms](https://wordpress.org/plugins/sb-elementor-contact-form-db/advanced/)**. - Next, 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://coolplugins.net/wp-content/uploads/2025/12/new-project-800x556.jpg)](https://coolplugins.net/wp-content/uploads/2025/12/new-project.jpg) - Enter a project name, choose a location, and click **Create**. [![new project details](https://coolplugins.net/wp-content/uploads/2025/12/new-project-details-800x360.png)](https://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://coolplugins.net/wp-content/uploads/2025/12/select-a-project-800x211.png)](https://coolplugins.net/wp-content/uploads/2025/12/select-a-project.png) - Next, navigate to the **Enabled APIs & services** section. [![enable api and services](https://coolplugins.net/wp-content/uploads/2025/12/enable-api-and-services-800x308.png)](https://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://coolplugins.net/wp-content/uploads/2025/12/enable-google-drive-api-800x413.png)](https://coolplugins.net/wp-content/uploads/2025/12/enable-google-drive-api.png) [![enable google sheets api](https://coolplugins.net/wp-content/uploads/2025/12/enable-google-sheets-api-800x385.png)](https://coolplugins.net/wp-content/uploads/2025/12/enable-google-sheets-api.png) - After enabling the APIs, go **OAuth consent screen**. [![consent screen](https://coolplugins.net/wp-content/uploads/2025/12/consent-screen.png)](https://coolplugins.net/wp-content/uploads/2025/12/consent-screen.png) - Click the **Get Started** button. [![click get started](https://coolplugins.net/wp-content/uploads/2025/12/click-get-started-800x410.png)](https://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://coolplugins.net/wp-content/uploads/2025/12/project-configuration.png)](https://coolplugins.net/wp-content/uploads/2025/12/project-configuration.png) - Click **Create OAuth Client ID**. [![create OAuth client](https://coolplugins.net/wp-content/uploads/2025/12/create-OAuth-client-800x244.png)](https://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://coolplugins.net/wp-content/uploads/2025/12/create-OAuth-client-id.png)](https://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**.  [![access authorized URI](https://coolplugins.net/wp-content/uploads/2025/12/access-authorized-URI.png)](https://coolplugins.net/wp-content/uploads/2025/12/access-authorized-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://coolplugins.net/wp-content/uploads/2025/12/cliend-id-and-secret-key.jpg)](https://coolplugins.net/wp-content/uploads/2025/12/cliend-id-and-secret-key.jpg) - 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://coolplugins.net/wp-content/uploads/2025/12/enter-client-id-and-secret-key-800x419.png)](https://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://coolplugins.net/wp-content/uploads/2025/12/publish-app-800x292.png)](https://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://coolplugins.net/wp-content/uploads/2025/12/generate-authentication-token-800x461.png)](https://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://coolplugins.net/wp-content/uploads/2025/12/click-advanced-tab-1-800x426.png)](https://coolplugins.net/wp-content/uploads/2025/12/click-advanced-tab-1.png) - Allow the requested permissions and click **Continue**. [![grant permissions](https://coolplugins.net/wp-content/uploads/2025/12/grant-permissions-1-800x720.png)](https://coolplugins.net/wp-content/uploads/2025/12/grant-permissions-1.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. ### How to Save Elementor Form Submissions to Google Sheets Follow the steps below to configure your Elementor form to automatically send data to Google Sheets:  - Edit your Form with Elementor. - Navigate to the Action after submit section below the Form Fields. - From the dropdown list, select **Save Submissions in Google Sheet**. [![save submissions in google sheet](https://coolplugins.net/wp-content/uploads/2025/12/save-submissions-in-google-sheet-2.png)](https://coolplugins.net/wp-content/uploads/2025/12/save-submissions-in-google-sheet-2.png) - A new panel called Save submissions in Google Sheet will appear. [![save submissions in google sheet](https://coolplugins.net/wp-content/uploads/2025/12/save-submissions-in-google-sheet-1.png)](https://coolplugins.net/wp-content/uploads/2025/12/save-submissions-in-google-sheet-1.png) - Select the **Google Spreadsheet** where you want to store the form entries. - Enter the **Sheet Tab Name**. - Next, select the form data you want to save in the sheet. - Click **Update Sheet** to apply the settings. - After satisfied, publish your page. Now, every time the form is submitted, the data will be **automatically saved to Google Sheets**. ### How to Save Elementor Form Submissions to Posts Type - Navigate to the Action after submit section below the Form Fields. - From the dropdown list, select **Save Submissions in Post Type**. [![save submissions in post type](https://coolplugins.net/wp-content/uploads/2025/12/save-submissions-in-post-type.png)](https://coolplugins.net/wp-content/uploads/2025/12/save-submissions-in-post-type.png) - A new panel called Save submissions in Post Type will appear. [![post type submission](https://coolplugins.net/wp-content/uploads/2025/12/post-type-submission.png)](https://coolplugins.net/wp-content/uploads/2025/12/post-type-submission.png) - **Post Type**: Choose **where the form data will be stored** in WordPress: **Posts, Pages, Media, Floating Elements** or **My Templates**. - **Post Status:** Choose the visibility status of your selected post type. - Enable **Run only to logged in users** option, if you want **only logged-in users** to submit the form and save submissions as posts. - After satisfied, publish your page. Now, every time the form is submitted, the data will be **automatically saved to WordPress Posts Type**.