Introduction
GSheetConnector for Elementor Pro allows you to automatically send Elementor form submissions directly to Google Sheets. To establish a secure connection between your website and your Google account, the plugin provides a Manual OAuth Authentication method.
The Manual OAuth method is recommended for users who want to use their own Google Cloud Project and manage their own Google API credentials. This approach gives you complete control over the authentication process and helps ensure a secure connection between Elementor forms and Google Sheets.
By following this guide, you will learn how to:
- Create a Google Cloud Project
- Enable the Google Sheets API
- Configure the OAuth Consent Screen
- Generate a Client ID and Client Secret
- Connect your Google Account with GSheetConnector
- Authorize the required Google permissions
- Start syncing Elementor form submissions to Google Sheets
Once the setup is completed successfully, every new form submission can be automatically stored in your selected Google Spreadsheet, making it easier to manage, organize, and analyze your form data.
Prerequisites
Before you begin, make sure you have the following:
- An active Google Account
- WordPress website access
- Elementor Pro installed and activated
- GSheetConnector for Elementor Pro installed and activated
- Administrator access to your WordPress dashboard
- Permission to create and manage projects in Google Cloud Console
Step 1: Create a New Google Cloud Project
To begin the Manual OAuth setup, you first need to create a new project in Google Cloud Console. This project will be used to configure the Google APIs and OAuth credentials required for connecting GSheetConnector with your Google account.
- Sign in to your Google account and open the Google Cloud Console.
- Click on the Project Selector located at the top of the page.
- Click the New Project button.
- Enter a suitable project name that helps you identify the project easily.
- Click Create and wait for Google Cloud to generate the project.
Step 2: Select the Newly Created Project
After creating the project, you need to select it before proceeding with the API and OAuth configuration.
- Click the Project Selector again from the top navigation bar.
- Locate the project you recently created.
- Click on the project name to select it.
- Verify that the selected project name appears in the top header of Google Cloud Console.
Step 3: Configure the OAuth Consent Screen
After selecting your Google Cloud Project, the next step is to configure the OAuth Consent Screen. This screen is displayed when users authorize Google access for the GSheetConnector plugin.
-
In the Google Cloud Console, navigate to:
APIs & Services → OAuth Consent Screen
- You will be redirected to the OAuth Overview page.
- Click the Get Started button to begin the setup process.
Step 4: Configure Your App Information
Google requires some basic information about your application before OAuth authentication can be enabled.
App Name
Enter a name for your application.
Example: GSheetConnector Elementor Integration
This name will be displayed on the Google authorization screen when connecting your Google account.
User Support Email
Select the Google email address that users can contact if they encounter issues with the application.
App Logo (Optional)
You may upload an application logo if desired. This step is optional and can be skipped.
After entering the required information, click Next to continue.
Step 5: Choose the Audience Type
The next screen requires you to select the User Type for your application.
Google provides two options:
Internal
The Internal option is only available for organizations using Google Workspace accounts.
If you select Internal:
- Only users within your Google Workspace organization can access the application.
- Personal Gmail accounts cannot authorize the application.
- Suitable for private company or organization use.
External
The External option allows users outside your organization to access and authorize the application.
If you select External:
- Any authorized Gmail account can connect to the application.
- Ideal for WordPress websites, plugins, and public applications.
- Recommended for GSheetConnector integrations.
Which Option Should I Select?
For most GSheetConnector users, you should select: External
This allows you to connect your Google account without requiring a Google Workspace organization.
Important : If you are using a standard Gmail account, select External. The Internal option is generally used only for Google Workspace environments.
Step 6: Add Contact Information
Google requires a contact email address for important notifications related to your OAuth application.
- Enter your email address in the Contact Information section.
- Make sure the email address is active and accessible.
- Google may use this email address to send security notifications, verification updates, and policy-related communications.
Step 7: Complete the OAuth Consent Screen Setup
After reviewing all entered information:
- Verify that the application details are correct.
- Confirm the selected User Type is External.
- Review the contact information.
- Click Finish.
Google will now create the OAuth Consent Screen configuration for your project.
Step 8: Configure Branding Information
Once the OAuth Consent Screen is created, the next step is to configure your application’s branding details. These settings help Google identify your application and provide users with information about your website during the authorization process.
In the Google Cloud Console, navigate to:
Google Auth Platform → Branding
Fill in the required details as described below.
Add Your App Logo (Optional)
You can upload your application or company logo to display on the Google consent screen.
- Click Upload Logo.
- Select your logo image from your computer.
- Upload the image and save the changes.
Add Website Information
In the Application Home Page field, enter your website URL.
Example: https://yourwebsite.com
This URL allows users to identify the website associated with the application.
Configure App Domain
Under the App Domain section, enter the required website URLs.
Application Home Page
Enter your website’s main URL.
Example: https://yourwebsite.com
Privacy Policy URL
Enter the URL of your website’s Privacy Policy page.
Example: https://yourwebsite.com/privacy-policy
Terms of Service URL (Optional)
Enter the URL of your Terms of Service page if available.
Example: https://yourwebsite.com/terms-and-conditions
Add Authorized Domains
Under the Authorized Domains section, add your website domain.
Example: yourwebsite.com
If you use multiple domains for the application, add each domain separately.
Add Developer Contact Information
In the Developer Contact Information section, enter a valid email address.
Example : support@yourwebsite.com or yourgmail@gmail.com
Google uses this email address to send important notifications related to your OAuth application, policy updates, and security alerts.
Step 9: Save Branding Configuration
After entering all the required information:
- Review the details carefully.
- Verify that the website URLs and domain information are correct.
- Click the Save button.
Once saved successfully, your Branding configuration will be completed, and you can proceed to create OAuth Client credentials in the next step.
Complete the Branding section by adding your logo, website information, authorized domains, and developer contact details, then click Save to continue.
Step 10: Create OAuth Client ID Credentials
After completing the OAuth Consent Screen and Branding configuration, the next step is to create OAuth credentials that will be used to connect GSheetConnector with your Google account.
- Navigate to: Google Auth Platform → Overview
- Click the Create OAuth Client button.
This will open the OAuth Client configuration page. From the Google Auth Platform Overview page, click Create OAuth Client to begin creating your OAuth credentials.
Step 11: Configure OAuth Client Information
You will now be asked to enter information for your OAuth Client.
Application Type
Select : Web Application
Name : Enter a name that helps you identify the OAuth client.
Example: GSheetConnector Elementor OAuth
The name is only for your reference inside Google Cloud Console and will not be visible to your website visitors.
Step 12: Add Authorized Redirect URI
The Authorized Redirect URI is one of the most important settings in the OAuth configuration.
- Locate the Authorized Redirect URIs section.
- Click Add URI.
- Copy the Redirect URI provided by the GSheetConnector plugin.
- Paste it into the Authorized Redirect URIs field.
Example: https://yourwebsite.com/wp-admin/admin.php?page=gsheetconnector-elementor
Even a small difference in the URL may cause Google authentication to fail and display a Redirect URI Mismatch error.
Step 13: Save the OAuth Client
After entering the required information:
- Verify the Application Type.
- Verify the Authorized Redirect URI.
- Click Create or Save.
Google will now generate your OAuth credentials.
Success
Once the OAuth Client is created successfully, Google will generate:
- Client ID
- Client Secret
These credentials will be required in the GSheetConnector plugin – Integration settings.
Step 14: Copy the Client ID
After creating the OAuth Client, you will be redirected to the Credentials page.
- Locate your newly created OAuth Client.
- Open the OAuth Client details if necessary.
- On the right-hand side, find the Client ID section.
- Click the Copy icon next to the Client ID.
Step 15: Copy the Client Secret
Below the Client ID section, you will find the Client Secret.
- Locate the Client Secret field.
- Click the Copy icon next to the Client Secret.
- Store the copied value securely.
Anyone with access to your Client Secret may be able to misuse your Google application credentials.
Best Practice : Store your Client ID and Client Secret in a secure location so they can be used later if you need to reconnect or reconfigure the integration.
Step 16: Configure Data Access (Scopes)
After creating your OAuth Client credentials, you need to configure the required OAuth scopes. These scopes define the permissions that GSheetConnector will request when connecting to your Google account.
To configure the scopes:
- Navigate to the Google Auth Platform.
- Open the Data Access section.
- Click Add or Remove Scopes.
- Search for and select the required Google Drive and Google Sheets API scopes listed below.
- After selecting all required scopes, click Update or Save.
Why Are Scopes Required?
OAuth scopes allow GSheetConnector to securely access Google services that are necessary for creating, reading, and updating spreadsheets.
The plugin only requests permissions that are required for Google Sheets integration and does not access unrelated Google account data.
Important Note
GSheetConnector uses these permissions only to:
- Create new Google Sheets.
- Access existing Google Sheets.
- Read spreadsheet metadata.
- Write Elementor form submissions to spreadsheets.
- Identify the connected Google account email address.
The plugin does not access personal emails, contacts, photos, or other private Google account information.
Required Scopes
Please enable the following scopes:
| API Service | Scope |
|---|---|
| Google Drive API | ../auth/drive |
| Google Drive API | ../auth/drive.metadata.readonly |
| Google Drive API | ../auth/drive.file |
| Google Sheets API | ../auth/spreadsheets |
| Google User Info API | ../auth/userinfo.email |
Scope Description
Google Drive API – ../auth/drive
Provides access to manage Google Drive files required for spreadsheet operations.
Google Drive API – ../auth/drive.metadata.readonly
Allows the plugin to read spreadsheet metadata and retrieve available Google Sheets from your Drive account.
Google Drive API – ../auth/drive.file
Allows the plugin to access and manage files that it creates or uses during the integration process.
Google Sheets API – ../auth/spreadsheets
Allows GSheetConnector to create, read, update, and write data to Google Sheets.
Google User Info API – ../auth/userinfo.email
Allows the plugin to identify and display the connected Google account email address after successful authentication.
Save the Selected Scopes
After selecting all required scopes:
- Review the selected permissions.
- Confirm that all required scopes have been added.
- Click Save to apply the changes.
Once the scopes are configured successfully, your OAuth application will have the necessary permissions required for connecting GSheetConnector with Google Sheets.
Step 17: Submit Your App for Verification
After configuring the OAuth Consent Screen, Branding, Audience Settings, Data Access Scopes, and OAuth Credentials, the final step is to submit your application for Google verification.
- Navigate to: Google Auth Platform → Audience
- Review all configured settings and ensure that all required information has been completed correctly.
- Click the Submit for Verification button.
Important
Before submitting your application, verify the following:
- OAuth Consent Screen is configured.
- Branding information is complete.
- Authorized Domains are added.
- Required Scopes have been added.
- Developer Contact Information is configured.
- OAuth Client ID has been created successfully.
If any required information is missing, Google may prevent you from submitting the application for review.
Step 18: Confirm Verification Submission
After clicking Submit for Verification, Google will display a confirmation screen.
- Review the information carefully.
- Confirm that you want to submit the application for verification.
- Click the Confirm button.
Google will now receive your verification request and begin reviewing your OAuth application.
Review the verification details and click Confirm to submit your application for Google’s verification process.
Step 19: Open the Verification Center
Once the verification request has been submitted:
- Click the Go to Verification Center link.
- The Verification Center allows you to track the status of your verification request.
- You can monitor progress and review any actions required by Google.
Possible statuses include:
- Draft
- Submitted
- In Review
- Approved
- Additional Information Required
Understanding the Verification Process
Google reviews OAuth applications that request sensitive scopes to ensure user data is handled securely.
Since GSheetConnector requires access to Google Drive and Google Sheets APIs, Google may review the application before allowing unrestricted public use.
During the review process, Google may verify:
- Application details
- Authorized domains
- Privacy Policy URL
- OAuth consent information
- Requested API scopes
- Website ownership
How Long Does Verification Take?
The verification timeline varies depending on Google’s review queue and the information provided during submission.
Typical Verification Time
| Verification Type | Estimated Time |
|---|---|
| Basic Review | 3 to 5 Business Days |
| Standard Verification | 1 to 2 Weeks |
| Complex Reviews | 2 to 6 Weeks |
While Waiting for Verification
While your application is under review:
- Existing Test Users can continue using the application.
- OAuth authentication can still be tested with approved test accounts.
- You can monitor verification progress through the Verification Center.
Note
If your application is still in Testing mode, only users added under the Test Users section will be able to authorize the application.
Verification Approved
Once Google approves your application:
- The verification status will change to Verified.
- OAuth warning messages may be removed.
- Users can authorize the application without being added as Test Users.
- Your Google Sheets integration will be ready for production use.
Internal User Type OAuth Authentication Setup
The Internal User Type method is designed for organizations using Google Workspace accounts. With this method, only users within your Google Workspace organization can authorize and access the application.
If your organization uses Google Workspace and you want to restrict access to internal users only, you can configure OAuth authentication using the Internal User Type option.
Step 1: Create a New Google Cloud Project
- Sign in to Google Cloud Console using your Google Workspace account.
- Click the Project Selector at the top of the page.
- Click New Project.
- Enter a project name of your choice.
- Click Create.
- Once the project is created, select the newly created project.
Note
All OAuth configurations, API settings, and credentials must be created within the same Google Cloud project.
Step 2: Configure Project Information
Navigate to:
Google Auth Platform → OAuth Consent Screen
Click Get Started and begin the project configuration process.
App Information
Enter the required application details:
- App Name
- User Support Email
- Application Logo (Optional)
The App Name will be displayed during the Google authorization process.
After entering the required information, click Next.
Step 3: Configure Audience Settings
In the Audience section, Google will ask you to choose a User Type.
Select: Internal
What is Internal User Type?
The Internal option restricts access to users within your Google Workspace organization.
With Internal User Type:
- Only organization members can authorize the application.
- External Gmail users cannot connect the application.
- No Test User configuration is required for internal organization users.
- Ideal for company and enterprise environments.
After selecting Internal, click Next.
Step 4: Add Contact Information
Enter a valid email address under the Contact Information section.
Google uses this email address to send:
- Security notifications
- OAuth-related updates
- Policy notifications
- Verification communications
After entering the information, click Finish.
Step 5: Create an OAuth Client
Navigate to: Google Auth Platform → Overview
Click : Create OAuth Client
OAuth Client Configuration
Configure the following settings:
Application Type
Select : Web Application
OAuth Client Name
Enter a name that helps identify the application.
Example : GSheetConnector Elementor Internal OAuth
Step 6: Add Authorized Redirect URI
Locate the Authorized Redirect URIs section.
- Click Add URI.
- Copy the Redirect URI provided by the GSheetConnector plugin.
- Paste it into the Authorized Redirect URI field.
Example : https://yourwebsite.com/wp-admin/admin.php?page=gsheetconnector-elementor
Step 7: Create OAuth Credentials
After completing the OAuth Client configuration:
- Verify all information.
- Click Create.
Google will generate:
- Client ID
- Client Secret
Step 8: Copy Client ID and Client Secret
After the OAuth Client is created successfully:
Copy Client ID
Locate the Client ID field and click the Copy icon.
Copy Client Secret
Locate the Client Secret field and click the Copy icon.
Step 9: Configure Data Access Scopes
Navigate to: Google Auth Platform → Data Access
Click Add or Remove Scopes and add the required permissions.
Required Scopes
| API Service | Scope |
|---|---|
| Google Drive API | ../auth/drive |
| Google Drive API | ../auth/drive.metadata.readonly |
| Google Drive API | ../auth/drive.file |
| Google Sheets API | ../auth/spreadsheets |
| Google User Info API | ../auth/userinfo.email |
Why These Scopes Are Required
These permissions allow GSheetConnector to:
- Access Google Sheets
- Create new spreadsheets
- Read spreadsheet information
- Write Elementor form submissions
- Display the connected Google account
After adding all required scopes, save the configuration.
OAuth Consent Screen Summary
Before proceeding, review the OAuth Consent Screen Summary.
Verify that:
- App Information is correct
- Internal User Type is selected
- Contact Information is configured
- Required Scopes are added
- OAuth Client is created successfully
If everything is correct, continue with the plugin integration.
Connect OAuth Credentials in GSheetConnector
After completing the Google Cloud configuration, return to your WordPress website.
Navigate to: GSheetConnector → Integration
Step 10: Add Client ID
Paste the copied Client ID into the Client ID field.
Step 11: Add Client Secret
Paste the copied Client Secret into the Client Secret field.
Step 12: Save Settings
Click the Save button to store the OAuth credentials.
Step 13: Sign In with Google
After saving the credentials:
- Click Sign In with Google.
- Select your Google Workspace account.
- Continue with the authorization process.
Step 14: Verify GSheetConnector Access
Google will display a permission screen showing the access requested by GSheetConnector.
Review the permissions and click Continue.
Permissions Requested
GSheetConnector requires permission to:
- View Google Sheets
- Create new Google Sheets
- Edit spreadsheet data
- Access Drive spreadsheet files
- Identify the connected Google account
These permissions are required for proper synchronization between Elementor forms and Google Sheets.
Step 15: Generate and Save Client Token
After authorization:
- Google redirects you back to the plugin settings page.
- GSheetConnector generates an authentication token.
- The Client Token will be displayed automatically.
Click Save to store the authentication token.
Note : The Client Token is used to maintain the secure connection between your website and Google services.
Step 16: OAuth Authentication Successful
Once the authentication process is completed successfully:
- The connected Google email address will be displayed.
- The connection status will show as Connected.
- Google account authorization is completed.
- Google Sheets integration is now ready for use.
Your Elementor form submissions can now be securely synchronized with Google Sheets.
Frequently Asked Questions
What is the Manual OAuth Authentication method?
The Manual OAuth Authentication method allows you to connect GSheetConnector with Google Sheets using your own Google Cloud Project, Client ID, and Client Secret. This method gives you full control over your Google API credentials and authentication settings.
Do I need a Google Cloud Project for the Manual Method?
Yes. The Manual Method requires you to create your own Google Cloud Project and configure OAuth credentials before connecting your Google account with GSheetConnector.
Which Audience type should I select: Internal or External?
Select External if you are using a personal Gmail account or want users outside your organization to access the application.
Select Internal only if you are using a Google Workspace account and want to restrict access to users within your organization.
Can I use a personal Gmail account with the Internal User Type?
No. The Internal User Type is only available for Google Workspace accounts. Personal Gmail accounts must use the External User Type.
Where can I find my Client ID and Client Secret?
After creating your OAuth Client in Google Cloud Console, navigate to:
Google Auth Platform → Clients
Open your OAuth Client and use the copy icons to copy the Client ID and Client Secret.
What is an Authorized Redirect URI?
The Authorized Redirect URI is the URL Google uses to return users back to your website after successful authentication.
Always copy the Redirect URI directly from the GSheetConnector Integration settings and add it to your OAuth Client configuration.
Why am I getting a Redirect URI Mismatch error?
This error usually occurs when the Redirect URI configured in Google Cloud Console does not exactly match the Redirect URI provided by the plugin.
Verify that:
* The URL is copied correctly.
* No extra spaces exist.
* The website domain matches exactly.
* HTTPS is used where required.
Why do I need to add OAuth Scopes?
OAuth Scopes define the permissions required by GSheetConnector to access Google Sheets and Google Drive.
Without the required scopes, the plugin cannot create spreadsheets, access existing sheets, or save Elementor form submissions.
Does GSheetConnector access my personal Google data?
No. GSheetConnector only requests permissions necessary for Google Sheets integration, such as creating spreadsheets, reading spreadsheet information, and writing form submissions.
The plugin does not access your emails, contacts, photos, or other personal Google account data.
Do I need to submit my app for Google verification?
If you are using the application only for personal use or testing, verification may not be required immediately.
If your application will be used publicly by multiple users, Google verification is recommended.
How long does Google OAuth verification take?
Verification time varies depending on Google’s review process.
Typical review times are:
* Basic Review: 3–5 business days
* Standard Review: 1–2 weeks
* Complex Reviews: Up to 6 weeks
Can I use the plugin while verification is pending?
Yes. While your application is in testing mode, authorized Test Users can continue using the integration.
Why can't I see my Google Sheets after connecting my account?
This may happen if:
* Required scopes are missing.
* Google authorization was not completed.
* The account does not have access to the spreadsheet.
* Authentication has expired.
Try reconnecting your Google account and authorizing all requested permissions.
What should I do if the Google Sign-In button is not working?
Please verify that:
* Client ID is correct.
* Client Secret is correct.
* Redirect URI is configured properly.
* OAuth Client is active.
* Required APIs and scopes are enabled.
Can I connect multiple Elementor forms to Google Sheets?
Yes. You can connect multiple Elementor forms and map them to different Google Sheets as needed.
Can I use an existing Google Spreadsheet?
Yes. You can either create a new spreadsheet through the plugin or connect an existing spreadsheet from your Google Drive account.
What permissions does GSheetConnector request during authentication?
Depending on your configuration, GSheetConnector may request permission to:
* View Google Sheets
* Create Google Sheets
* Edit spreadsheet data
* Access Google Drive spreadsheet files
* Display the connected Google account email address
These permissions are required for proper Google Sheets integration.
How do I reconnect my Google account?
Disconnect the existing connection from the Integration settings, save the changes, and then click Sign In with Google again to complete a new authentication process.
Where can I verify that my Google account is connected successfully?
After successful authentication:
* Your Google email address will be displayed.
* The connection status will show as Connected.
* A Client Token will be generated and saved automatically.
What should I do if authentication fails?
Check the following:
* Google Sheets API is enabled.
* OAuth Client ID and Client Secret are correct.
* Redirect URI is configured properly.
* Required scopes are added.
* The correct Google account is being used.
After making changes, reconnect your Google account and try again.
