CF7 Google Sheets Connector PRO

Send one form to its configured destinations

CF7 Google Sheets Connector PRO sends successful Contact Form 7 submissions to Google Sheets as new rows. A single form can use multiple feeds to send data to multiple spreadsheets or worksheet tabs, with each destination configured separately. This can help organize leads, inquiries, registrations, RSVPs, orders, and other form data in searchable, shareable spreadsheets.

Select a sheet or enter its identifiers

Automatic Google Sheet and tab detection lets you select an existing spreadsheet and worksheet directly, instead of manually entering Sheet IDs and Tab IDs. Each destination that should receive submissions needs its own configured feed.

Set the fields and column layout

• Advanced field mapping: Choose which Contact Form 7 fields to send and how the form data is organized.
• Field controls: Enable or disable individual fields to choose which values are sent.
• Custom column order: Set the order of fields in the spreadsheet.
• Custom headers: Rename Google Sheets column headers instead of relying only on the original Contact Form 7 field names.
• Mail tag settings: Use all Contact Form 7 special mail tags supported by the Pro edition.

These controls let a spreadsheet use a specified layout, clearer column names, or a smaller set of submitted values. They can also help adapt the same form structure to different spreadsheet destinations.

Choose how Google authentication works

Quick Connect uses Google OAuth 2.0 and does not require creating a Google Cloud project or API keys. For server-to-server connections, use Google Service Account authentication with a JSON key. Manual Google authentication is also available for organizations using their own Google Cloud project and OAuth credentials.

Submission storage and diagnostics

Successful Contact Form 7 submissions can be sent automatically to Google Sheets. The connector also offers optional local storage in the WordPress database, separate from the Google Sheets connection. Stored entries can be browsed by form, searched and paginated, marked read or unread, and selected for bulk sending to a spreadsheet.

Diagnostic tools include error logs for Google authentication, connection, and API failures, plus system status information about the WordPress, PHP, extension, and server environment.

Installation and setup

1. Install and activate CF7 Google Sheets Connector PRO alongside Contact Form 7.
2. Connect a Google account using Quick Connect, a service account, or manual authentication.
3. Select a Contact Form 7 form and a Google Sheet or worksheet tab for a feed.
4. Configure field mapping, column order, header names, and enabled fields.
5. Save the configuration and submit a test entry to verify the spreadsheet process.

Future successful submissions can then be added to the selected spreadsheet destinations according to the feed settings.