Google API Setup to Connect Elementor Forms 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.

Create Google API Credentials

Follow the steps below to generate a Google API authentication token:

• Open the Google Cloud Console in Chrome browser.
• Click Select Project at the top and then click New Project.

• Enter a project name, choose a location, and click Create.

• Once the project is created, select it from the Select Project dropdown.

• Next, navigate to the Enabled APIs & services section.

• Here, search and enable the Google Drive API and Google Sheets API.

• After enabling the APIs, go OAuth consent screen.

• Click the Get Started button.

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

• Click Create OAuth Client ID.

• Select Web Application as the application type and enter a name for the client.
• Click Add Authorized Redirect URI.

• From your WordPress dashboard, you can access this redirect URI by navigating to Elementor > FormsDB > Settings. 

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

Generate Authentication Token

• Paste the Client ID and Client Secret into the FormsDB settings.
  (From your WordPress dashboard, Elementor > FormsDB > Settings)

• Now, from the Google Cloud Console, go to the Audience section and click Publish App.

• Return to FormsDB settings in Elementor and open the Settings tab.
• Click Generate Authentication Token.

• Log in with your Google account. If a security warning appears, click Advanced, then choose Go to (unsafe) to proceed.

• Allow the requested permissions and click Continue.

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