Single Google Sheet Configuration for GSheetConnector for Elementor Pro
This guide will help you connect your Elementor Pro form with Google Sheets using GSheetConnector for Elementor Pro. By following the steps below, you can automatically store Elementor form submissions directly into your Google Sheet.
GSheetConnector for Elementor Pro supports multiple Google authentication methods, including Existing Authentication, Manual Authentication, and Service Account Authentication. Once connected, you can either create a new Google Sheet or connect an existing sheet and start syncing your form entries automatically.
- Before configuring Google Sheets, make sure Elementor Pro and GSheetConnector for Elementor Pro are installed and activated.
- Your Elementor form must be configured properly before enabling Google Sheets integration.
- Google authentication must be completed before connecting any sheet.
- Service Account authentication is the recommended method for better security and easier management.
- If you are using the Service Account method, make sure the target Google Sheet is shared with the Service Account email address.
- Form Feed Settings is the recommended approach for new users because it provides better flexibility and easier management of multiple forms and sheets.
Step 1: Create a New Page
Create a new page in WordPress where you want to display your Elementor form.
Step 2: Add a Form Widget
Edit the page using Elementor.
Add a new row or section to the page and search for the Form widget in Elementor.
Drag and drop the Form widget onto the page and configure all required form fields.
Step 3: Enable GSheetConnector Action
Navigate to the Actions After Submit section inside the Form settings.
Add GSheetConnector to the list of actions.
After adding the action, scroll down and open the GSheetConnector Pro settings panel.
Step 4: Configure Google Authentication
If you have not connected Google Sheets yet, navigate to:
GSheetConnector → Settings → Integration
You will find the following authentication methods:
- Existing Authentication
- Manual Authentication
- Service Account Authentication
You may choose any authentication method based on your requirements.
Complete the authentication process and save your settings.
Step 5: Open GSheetConnector Pro Settings
Return to your Elementor form page and open the GSheetConnector Pro settings section.
The authentication method you selected in the Integration settings will be displayed here automatically.
Step 6: Manual Google Sheet Configuration
You will see the Enable Manual Google Sheet Configuration option.
This option allows you to manually enter and configure your Google Sheet details.
Use this option if you want to manually connect a specific spreadsheet and worksheet.
Step 7: Automatic Google Sheets Configuration
The Automatic Google Sheets Configuration section allows you to:
- Create a new Google Sheet directly from Elementor.
- Connect an existing Google Sheet.
- Select an existing worksheet from your connected Google account.
Under the Sheet Name dropdown, select the Google Sheet you want to connect.
If your sheet is not displayed in the dropdown list, click the Fetch Sheets option.
Then click the Click Here link to reload and fetch all available Google Sheets from your connected Google account.
Step 8: Configure Form Feed Settings (Recommended)
You will also see the following link:
Click here to Setup Form Feed Settings to easily configure multiple feeds simultaneously
Using Form Feed Settings, you can:
- Create multiple feeds.
- Connect multiple Google Sheets.
- Configure different sheets for different forms.
- Manage integrations more efficiently.
Step 9: Select Fields to Sync
The Select Fields to Sync option allows you to control which form fields are sent to Google Sheets.
You can:
- Use Check All to enable all fields at once.
- Use Uncheck All to disable all fields.
- Manually enable or disable individual fields as needed.
Enable only the fields that you want to appear in your Google Sheet.
Step 10: Header Settings
The Header Settings section allows you to customize the appearance of your Google Sheet.
Available options include:
- Freeze Header Row
- Header Background Color
- Odd Row Color
- Even Row Color
These settings help improve the readability and organization of your spreadsheet.
Step 11: Sync Existing Entries
At the bottom of the settings section, you will find the following option:
Click here to Sync with your Selected Google Sheet
Use this option to send previously submitted form entries to your connected Google Sheet.
This feature is useful when you want to export older form data that was collected before the Google Sheet connection was configured.
Save Feed Settings and Test Form Submission
After completing all Feed Settings, click on the Save Settings button.
Once the Feed Settings are saved successfully, the plugin will automatically create the header row in your connected Google Sheet using your Elementor Form field labels.
All selected form fields will be displayed as column headers in the connected sheet.
Test Form Submission
After saving the Feed Settings, it is recommended to test the integration.
- Open the page where your Elementor Form is published.
- Fill out the form with sample information.
- Click on the Submit button.
You will see the submitted form data automatically added as a new row in the sheet under the corresponding column headers.
This confirms that your Elementor Form and Google Sheet integration is working correctly.
Frequently Asked Questions
Which Google authentication method should I use?
GSheetConnector for Elementor Pro supports Existing Authentication, Manual Authentication, and Service Account Authentication. We recommend using the Service Account Authentication method because it is more secure, reliable, and does not require re-authentication when a Google account password changes.
Can I create a new Google Sheet directly from Elementor?
Yes. The Automatic Google Sheets Configuration section allows you to create a new Google Sheet directly from the Elementor Form settings and connect it immediately without leaving your website dashboard.
Can I connect an existing Google Sheet?
Yes. You can select an existing Google Sheet from the Sheet Name dropdown and connect it with your Elementor Form. Once selected, form submissions will automatically be stored in the selected sheet.
Why am I unable to find my newly created Google Sheet in the Sheet Name dropdown?
If your newly created sheet does not appear in the dropdown list, click the Click Here link below the Sheet Name field. This will refresh and fetch the latest sheets available in your connected Google account.
Can I use multiple Google Sheets for different Elementor Forms?
Yes. You can use the Form Feed Settings feature to create separate feeds for different Elementor Forms and connect each form to a different Google Sheet.
Should I use the Form Feed feature or the Elementor Form Inner Settings?
For new users, we recommend using the Form Feed feature available in the plugin settings. It provides better feed management, supports multiple sheets, and makes configuration easier. The Elementor Form Inner Settings option is retained mainly for compatibility with older setups.
What happens if I add new fields to my Elementor Form after completing the setup?
If you add new form fields after the initial setup, open the GSheetConnector settings again, review the field mapping, save the settings, and update the Google Sheet headers if necessary.
Can I customize the column headers in Google Sheets?
Yes. The plugin allows you to edit field labels before syncing them. The edited labels will be used as column headers in the connected Google Sheet.
Will existing data in my Google Sheet be deleted when I connect the form?
No. Connecting your Elementor Form to Google Sheets will not delete existing spreadsheet data. New form submissions will be added as new rows in the connected worksheet.
Can I sync previous form submissions after connecting Google Sheets?
Yes. Use the Click here to Sync with your Selected Google Sheet option to send previously submitted form entries to your connected Google Sheet.
Do I need to save the settings after selecting fields and configuring the sheet?
Yes. After completing the configuration, you must click the Save Settings button. The plugin will then create the column headers and prepare the sheet for future form submissions.
How can I verify that the integration is working correctly?
After saving the settings, submit a test entry through your Elementor Form. Open the connected Google Sheet and verify that a new row has been added with the submitted information.
Why are the Google Sheet column headers not created automatically?
Column headers are generated when the Feed Settings are saved successfully. If the headers are not created, verify that the sheet is connected correctly, required permissions are granted, and the settings have been saved without errors.
Can I disable specific fields from being sent to Google Sheets?
Yes. The Select Fields to Sync section allows you to choose exactly which form fields should be synced. Disabled fields will not be sent to Google Sheets.
Can I change the Google Sheet later without recreating the form?
Yes. You can edit the GSheetConnector settings at any time and select a different Google Sheet or worksheet without recreating the Elementor Form.
