GSheetConnector – Contact Form 7 Google Sheets Connector & Save CF7 Entries to Database

Install and activate CF7 Google Sheets Connector, then go to Contact → Google Sheets → Integration and connect your Google account using Google OAuth 2.0. Next, create or open your Google Sheet, add your Contact Form 7 field names as column headers, and enter the Sheet Name, Sheet ID, Tab Name, and Tab ID in the Google Sheets tab of your Contact Form 7 form. After saving the settings, submit a test form entry. The submission should appear automatically as a new row in your Google Sheet.

Contact Form 7 does not send submissions to Google Sheets by itself. CF7 Google Sheets Connector adds this integration. Once your form and spreadsheet are connected, new Contact Form 7 submissions are automatically sent to Google Sheets in real time, so you don't need to manually export or copy form data.

No. The recommended Quick Connect method uses Google OAuth 2.0 authentication and lets you connect your Google account without creating your own Google Cloud project or API credentials. For advanced requirements, CF7 Google Sheets Connector PRO also supports manual Google authentication using your own Google Cloud project and OAuth credentials.

Go to Contact → Google Sheets → Integration and click Sign in with Google. Choose the Google account you want to connect and approve the requested permissions. Once authentication is complete, the connected account will appear in the Integration tab. No Google Cloud Console setup is required when using the recommended Quick Connect method.

Yes. CF7 Google Sheets Connector supports Google Service Account authentication. Create a service account and JSON key in Google Cloud, add the JSON key to the Service Account settings in the plugin, and share your target Google Sheet with the service account email address. This provides a server-to-server connection without requiring an interactive Google login after configuration.

In the free version, add your Contact Form 7 field names as column headers in the first row of your Google Sheet. For example, if your Contact Form 7 fields are: your-name, your-email, your-phone, your-message Use the same names as your Google Sheets column headers: your-name | your-email | your-phone | your-message When someone submits the form, each value is added under its corresponding Google Sheets column. CF7 Google Sheets Connector PRO provides advanced field mapping, custom header names, column ordering, field controls, and automatic sheet and tab detection.

Yes, but support differs between the Free and PRO versions. The free version supports the Contact Form 7 date special mail tag. CF7 Google Sheets Connector PRO supports additional Contact Form 7 special mail tags, including date, time, serial number, remote IP address, user agent, page URL, post information, site information, and more. PRO also supports custom mail tags and provides toggle controls to enable or disable individual mail tags.

Yes. You can connect multiple Contact Form 7 forms to Google Sheets. Each CF7 form can have its own Google Sheet and worksheet configuration. The free version supports one Google Sheets feed per form. CF7 Google Sheets Connector PRO supports multiple Google Sheets feeds per form, allowing a single Contact Form 7 form to send data to multiple spreadsheet destinations.

Yes. Enable the CF7 Database feature to store Contact Form 7 submissions locally in your WordPress database in addition to sending them to Google Sheets. Stored entries can be viewed and searched from WordPress, marked as read or unread, and selected entries can be resent to Google Sheets when needed.

If the CF7 Database feature is enabled under Settings → General Settings, the submission can still be stored locally in your WordPress database even if the Google Sheets sync is interrupted. You can review stored entries and resend selected submissions to Google Sheets using the Send to Spreadsheet bulk action. You can also check the plugin's Error Log and System Status information for authentication, API, permission, or configuration errors.

If your Contact Form 7 submissions are not appearing in Google Sheets, check the following:

1. Make sure the correct Sheet Name, Sheet ID, Tab Name, and Tab ID are saved in the form's Google Sheets settings.
2. Check that your Google account is still connected under Contact → Google Sheets → Integration.
3. Make sure the first-row Google Sheets headers match your Contact Form 7 field names exactly.
4. Check for incorrect spaces, underscores, capitalization, or other differences in your spreadsheet column headers.
5. If you're using a Google Service Account, make sure the spreadsheet has been shared with the service account email address with the required permissions.
6. Check the plugin's Error Log and System Status for authentication, Google API, or permission errors.

Usually, a continuously spinning Contact Form 7 submit button indicates an issue with the form submission process itself, JavaScript, REST API communication, email delivery, or another WordPress configuration. CF7 Google Sheets Connector processes the Google Sheets integration after the relevant Contact Form 7 submission event. Check Contact Form 7, your browser console, WordPress configuration, and any email or REST API errors when troubleshooting a stuck submission.

Yes. If you embed a Contact Form 7 form inside a page created with Elementor, Divi, Avada, or another page builder, CF7 Google Sheets Connector can still send that Contact Form 7 form's submissions to Google Sheets. The important point is that the embedded form must be a Contact Form 7 form. If you're using the page builder's own native form instead, use the corresponding GSheetConnector integration:

• Elementor Forms → Google Sheets Integration
• Divi Forms → Google Sheets Integration
• Avada Forms → Google Sheets Integration

Form submission data is sent from your WordPress website to Google's APIs using the configured Google authentication method rather than being used as a separate GSheetConnector-hosted form submission database. Your WordPress site can also store submissions locally when the CF7 Database feature is enabled. As with any website handling personal information, you should configure your WordPress site, forms, Google account, spreadsheet permissions, and privacy disclosures according to the data you collect and the privacy requirements that apply to your website.

Yes. The plugin includes formula-injection protection for values sent to Google Sheets. Submitted values beginning with characters such as =, +, -, or @ are handled before being written to the spreadsheet to help prevent submitted content from being interpreted as a spreadsheet formula.

By default, uninstalling the plugin keeps saved settings so you can reinstall it without having to configure everything again. If you want stored plugin data and Google connection details removed during uninstall, enable Delete data on uninstall under Settings → General Settings before uninstalling the plugin.

Yes. CF7 Google Sheets Connector supports WordPress Multisite. Each site can manage its own Google connection and Contact Form 7 to Google Sheets configuration.

The free version provides the core features needed to connect Contact Form 7 to Google Sheets, send form submissions automatically, configure spreadsheet columns, and optionally store submissions locally in WordPress. CF7 Google Sheets Connector PRO adds advanced features such as multiple Google Sheets feeds, automatic sheet and tab detection, advanced field mapping, custom headers and column ordering, all supported special mail tags, custom mail tags, conditional logic, Google Drive integration, spreadsheet formatting options, CSV export, role-based permissions, and manual Google authentication. See the Free vs PRO feature comparison for more details.