CF7 Google Sheets Connector PRO

Send Contact Form 7 submissions to Google Sheets

CF7 Google Sheets Connector PRO sends successful Contact Form 7 submissions to Google Sheets as new rows. Site owners can configure a form to send data to one or more spreadsheet feeds, with each destination set up for its own process.

Choose sheets and configure feeds

Automatic sheet and worksheet tab detection lets you choose a destination without manually entering Sheet IDs and Tab IDs. A form can send submissions to multiple Google Sheets or worksheet tabs when each destination has a configured feed.

Set the fields and spreadsheet layout

Field mapping lets you choose which Contact Form 7 values go to Google Sheets and how they are organized. You can set the column order, rename column headers and enable or disable individual fields. The Pro edition also works with its available Contact Form 7 special mail tag settings. These controls let a feed use a specific spreadsheet layout and select the submitted values it sends.

Connect a Google account

Choose an authentication method for the connection. Quick Connect uses Google OAuth 2.0 and does not require creating a Google Cloud project or API keys. The connector also supports Google Service Account authentication with a JSON key for server-to-server connections, or manual Google authentication with an organization's own Google Cloud project and OAuth credentials.

Optional local storage and diagnostics

Separately from sending submissions to Google Sheets, the connector delivers optional storage in the WordPress database. 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 logs for Google authentication, connection and API errors, along with 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 the Contact Form 7 form and the 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 check the spreadsheet workflow.

After setup, successful submissions can be added to the selected spreadsheet destinations according to their feed settings.