GSheetConnector

CF7 Google Sheets Connector connects Contact Form 7 to Google Sheets and automatically sends form submissions to a Google Sheet in real time. Every new entry, including leads, inquiries, RSVPs, orders, and other form data, is added directly to your spreadsheet. This makes it easy to keep your Contact Form 7 entries organized, searchable, and accessible to your team without relying only on email notifications.

It’s a lightweight CF7 Google Sheets integration built for site owners who want a reliable way to connect Contact Form 7 to Google Sheets. With one-click Google OAuth 2.0 authentication, you can quickly connect your Google account, map your CF7 form to a Google Sheet, and start sending form entries automatically.

Why Connect Contact Form 7 to Google Sheets?

Connecting Contact Form 7 to Google Sheets gives you a simple way to collect, organize, and share form submissions without manually copying data from emails or WordPress.

• Real-time Google Sheets sync – Send Contact Form 7 submissions to your Google Sheet as soon as they are successfully submitted. No manual exports or copy-pasting.
• Simple setup – Connect your Google account, map your CF7 form to a spreadsheet once, and future submissions are automatically added as new rows.
• Keep form entries organized – Store leads, inquiries, registrations, RSVPs, orders, and other Contact Form 7 data in a structured spreadsheet.
• Easy access for your team – Share, search, sort, and filter incoming submissions in Google Sheets without giving team members access to your WordPress dashboard.
• Local submission backup – Optionally store Contact Form 7 entries in your WordPress database, independently of the Google Sheets connection.

⚡ Key Features

Real-Time Contact Form 7 to Google Sheets Sync

• Connect any Contact Form 7 form to a specific Google Sheet and worksheet tab using the Sheet Name, Sheet ID, Tab Name, and Tab ID.
• Automatically append a new spreadsheet row after every successful Contact Form 7 submission using the wpcf7_mail_sent event.
• Send your Contact Form 7 field values to their corresponding columns in Google Sheets.
• Supports the Contact Form 7 date special mail tag in the free version.
• Built-in formula-injection protection removes leading =, +, -, and @ characters from submitted values before they are sent to your spreadsheet.
• Newly added rows have inherited formatting cleared automatically to help prevent unwanted cell styling.

Easy Google OAuth 2.0 Authentication

Connect your Google account quickly without having to create your own Google Cloud project.

• Quick Connect (recommended) – Connect your Google account in just a few clicks using Google OAuth 2.0 authentication.
• No Google Cloud project or API keys are required when using Quick Connect.
• Once authenticated, configure your Contact Form 7 form and Google Sheet to start receiving submissions.

For advanced setups, GSheetConnector also provides additional authentication options.

Google Service Account Authentication

Connect Google Sheets using a Google Service Account JSON key for server-to-server authentication.

This method does not require an interactive Google login after configuration and can be useful for agencies, managed websites, and automated environments.

CF7 Google Sheets Connector PRO also provides a manual Google authentication option for organizations that prefer to use their own Google Cloud project and OAuth credentials.

Read the full description on the official page →