Google Sheets Integration

We’re excited to introduce a powerful new feature of the Ultimate Addons for Contact Form 7: Google Sheets Integration. This functionality allows you to automatically record Contact Form 7 form submissions to a Google Sheet in real-time—perfect for organizing leads, support queries, event registrations, and more without relying on third-party tools.

Watch Complete Video

Why You Should Connect Contact Form 7 to Google Sheets

Whether you’re collecting inquiries, event registrations, feedback, or support requests, managing data directly in Google Sheets offers huge advantages:

• ✅ Automate data entry
• ✅ Avoid manual copy-pasting
• ✅ Reduce errors and streamline workflows
• ✅ Collaborate effortlessly with your team in real time

This integration is ideal for agencies, marketing teams, internal operations, and educational platforms.

How to Send CF7 Form Submissions to Google Sheets – A Step-by-Step Guideline

Prerequisites

Before you begin, ensure the following:

• ✅ Contact Form 7 is installed and working on your WordPress site
• ✅ You have admin access to your website file system
• ✅ A Google account with access to Google Cloud Console
• ✅ Comfort with editing Contact Form 7 forms

Create a Google Cloud Project and Credentials

1. Visit: https://console.developers.google.com
2. Create a new project or select an existing one
3. Give your project a name (e.g., Contact Form 7 Sheets)
4. Click Create

---

Step 2 – Enable Google Sheets API

1. Inside your project dashboard, click “Enable APIs & Services” then click Library
2. Search for Google Sheets API
3. Click the API result, then click “Enable”

---

Step 3 – Create Service Account and Generate JSON Key

1. Go to APIs & Services > Credentials
2. Click “+ CREATE CREDENTIALS” > Service Account
3. Fill in the service account details:
   • Name: Google Sheets for Contact Form 7
   • Click Create and Continue
4. Under Grant this service account access to the project:
   • Role: Select Editor
   • Click Continue, then Done
5. In the Service Accounts list, click the new account

1. Navigate to the KEYS tab
   • Click “Add Key” > Create new key
   • Select Key type: JSON
   • Click Create

💾 Your credentials file (e.g… credentials.json) will be downloaded. This is your secure API key.

🔒 Important: Keep this file private and secure. Do not commit it to public repositories.

---

Step 4 – Share Your Sheet with the Service Account

1. Open your target Google Sheet
2. Click Share
3. Find the service account email inside the credentials.json file
4. (e.g., cf7-sheets@your-project.iam.gserviceaccount.com)
5. Share the Google Sheet with this email
6. Role: Editor

---

Step 5 – Configure the Plugin with Your Credentials File

1. Go to Ultimate Addons > Settings > Google Sheets
2. Upload your file (e.g... credentials.json) file in the field provided
3. Save the settings

Test Sheet Connection & Enter Sheet ID

1. From your Google Sheet URL:
   https://docs.google.com/spreadsheets/d/<sheet-id>/edit
   Copy the Sheet ID
   ✅ Example:
   Sheet URL:
   https://docs.google.com/spreadsheets/d/1a2b3c4d5e6F7g8H9I0JklMnOpQrStUvWxYzZAbCdEfG/edit
   Sheet ID:
   1a2b3c4d5e6F7g8H9I0JklMnOpQrStUvWxYzZAbCdEfG
2. Paste the Sheet ID into your plugin settings
3. Click Test Connection
   • You should see a message like:
     ✅ “Google Sheet connection is working fine.”

Important: Never expose this credentials file publicly. Avoid uploading it to shared/public directories or version control repositories.

How to Connect Contact Form 7 with Google Sheets

After you’ve configured the API credentials, it’s time to link specific forms to your spreadsheet.

1. Enable Google Sheets Add-on
2. Navigate to Ultimate Addons > All Addons
3. Search for “Google Sheets”
4. Toggle the switch to enable the add-on
5. Once enabled, the Google Sheet tab will be available on all CF7 forms.

---

Connect Google Sheet with Your CF7 Form

• Go to Contact > Add New or open an existing form
• Scroll to the bottom, find “Addons for CF7 Options”
• Click the “Google Sheets” tab
• You’ll see the Google Sheets Settings Panel

---

Google Sheet Settings Panel

Enable Google Sheet

Toggle this setting to Yes to enable submission recording for this form.

Google Sheet ID

Paste your Google Sheet ID here: Example:1RmxQRsRbqlDqmFOt7iasdfaeX-XFuDPysdf8mOYJsdfds7cCIq5E6TM

Google Sheet Tab ID

Every sheet/tab inside your spreadsheet has a Tab ID

• You can inspect it via developer tools or a script
  Example: 34531081419
  Paste the ID here to specify where the form data will be recorded

Once completed, submit your form and verify that the data appears in your Google Sheet in real time.

---

Still Not Clear?

If you need help setting this up or are getting errors during submission, we’re here to assist.
👉 [Open a support ticket here]