WordPress.org

Plugin Directory

WPSyncSheets For WPForms — Google Sheets Connector for WPForms & Real‑Time Data Export

WPSyncSheets For WPForms — Google Sheets Connector for WPForms & Real‑Time Data Export

Description

WPSyncSheets For WPForms — A powerful and user-friendly solution to automatically save entries from both WPForms Lite and WPForms Pro directly into a single Google Spreadsheet. With this addon, every time a user submits a form without any code, their data is instantly synced to your connected spreadsheet. Easily manage and organize form submissions in one place.

🚀 Key Features

🔄 Real-time export of WPForms entries to Google Sheets
✅ Automated & runtime syncing – no manual exports needed
🧩 Field-to-column mapping for custom spreadsheet structures
📄 Auto-create Google Spreadsheet & sheets from feed settings
📌 Option to freeze header row in Google Sheets
🕒 Auto-add submission date & time for each form entry
📥 View, clear, or export Google Sheet data from the plugin dashboard
⚙️ Tested with WPForms Lite & Pro, WordPress 6.8.2, and PHP 8.3

💡 Why Use This Plugin?

Real-time sync: No more manual exports — your sheets update automatically
Collaboration ready: Easily share sheets with team members or stakeholders
Fully Customizable: You can design your forms the way you want
Customizable sheets: Control what you export and how it’s formatted

📂 Download Sample Sheets

View Sample Exported Entries Sheet

🛠️ How to Export WPForms Entries to Google Sheets

  1. Install and activate the plugin
  2. Connect to Google Drive via API (Client ID, Secret, and Token)
  3. Go to the form settings WPSyncSheets Feed Settings
  4. Enable the feeds and map it.
  5. Save the Setting
  6. New submissions will auto-export to Google Sheets

▶ How To’s Video

How to Export WPForms?

🔗 Live Demo – Click Here

🧪 Demo Testing Instructions

  1. Fill out the sample form
  2. Submit your data
  3. Click the spreadsheet link to view real-time exported entries

🔒 Upgrade to Pro

The Pro version unlocks powerful features:

All the features in the free plugin (entries export, create new google sheet, etc)
✅ Custom column mapping – choose your own headers and order
Edit or Sorting existing sheet headers directly from settings.
Conditional logic – sync entries only when specific rules match
Submission time, user info, IP address logging
Save Files: Automatically store uploaded files in the plugin folder and add download links to your Google Sheet.

📘 Documentation & Support

📣 Trusted by Over 10,000+ Customers

Trusted by businesses, developers, and marketing teams to automate WPForms data syncing and streamline client reporting via Google Sheets.

🔔 Stay Updated

Subscribe to the WPSyncSheets Newsletter and get tips, updates, and exclusive discounts delivered straight to your inbox!

Relevant Import-Export Google Sheets Plugins

Other useful plugins from WPSyncSheets to import and export data from WordPress websites to Google Sheets.

WPSyncSheets For WooCommerce: Import Export for WooCommerce orders, products, customers, coupons, and events.

WPSyncSheets For Elementor: Migrates Elementor form entries to Google Sheets, maps form fields to the spreadsheet columns, and automatically updates sheets when form entries are submitted.

WPSyncSheets For Gravity Forms: Sync Gravity Forms entries to Google Sheets allowing form data transfer to specified spreadsheet columns in real-time.

WPSyncSheets For Core: Enables import export WordPress posts and pages to and from Google Sheets, allowing users to bulk edit content in the spreadsheet and sync changes back to WordPress.

WPSyncSheets For Document Library Pro: Sync Document Library Pro entries with Google Sheets allowing for two-way updates between the plugin entries and spreadsheet data.

WPSyncSheets For Contact Form 7: Transfers Contact Form 7 entries to Google Sheets, maps form fields to spreadsheet columns, and updates sheets upon form submission.

WPSyncSheets For Ninja Forms: Migrates Ninja Forms entries to Google Sheets, maps form fields to spreadsheet columns, and updates sheets in real-time.

WPSyncSheets For Fluent Forms: Sync Fluent Forms entries to Google Sheets, and automatically transfer form data to designated spreadsheet columns upon submission.

WPSyncSheets For Formidable Forms: Adds Formidable Forms entities to Google Sheets maps form fields to spreadsheet columns and automatically updates sheets when forms are submitted.

About WPSyncSheets

WPSyncSheets is a leading plugin suite built to connect WordPress and WooCommerce platforms with Google Sheets. Our mission is to help businesses automate data transfer, simplify operations, and reduce repetitive tasks through real-time, two-way data synchronization.

With over 9+ purpose-built plugins, WPSyncSheets enables:

  • Smooth export/import of WooCommerce and WordPress data
  • Bulk content updates through spreadsheets
  • Live syncing of form submissions across popular form plugins
  • Easy spreadsheet-based product management

Whether you’re running an eCommerce store, collecting leads, or managing blog content, WPSyncSheets lets you automate your workflow—no code required.

👉 Learn more on our Official Website
📈 Upgrade to WPSyncSheets Pro for the full automation suite
💬 Have questions? Contact Our Support Team

Screenshots

  • Google API Integration Settings
  • General Settings
  • Sheet Headers
  • Google Spreadsheet Entries

Installation

  1. Upload the entire wpsyncsheets-wpforms folder to the /wp-content/plugins/ directory.
  2. Activate the plugin through the Plugins screen (Plugins > Installed Plugins).

You will find WPSyncSheets For WPForms menu in your WordPress admin screen.

For basic usage, have a look at the plugin’s Documentation.

FAQ

Why isn’t form data sent to Google Sheets—or just spinning indefinitely?

This usually happens when:

  • Your Google authentication token needs reauthorization. Visit the plugin settings and reauthorize.
  • Google Sheets and Drive APIs are not enabled on your Google account. Ensure both are activated in your Google Cloud Console.

Will the submission date and time be saved?

Yes. Each synced entry includes the exact date and time of submission in dedicated columns.

Can I connect multiple WPForms to different Google Sheets?

Yes! You can configure each WPForm individually to sync with a unique Google Spreadsheet or specific sheet tab, offering complete flexibility.

Can I map form fields to specific sheet columns?

Yes, with the Pro version, you can map form fields to custom column headers for precise data structuring.

Is my form data stored securely?

Yes. All form data remains within your WordPress site and your authenticated Google account. No external servers or third-party services are used.

Are uploaded files saved and added to Google Sheets?

Yes, in the Pro version. File uploads are saved in the plugin folder, and a link is automatically added to the Google Sheet entry.

Can I freeze the sheet header row?

Yes. The plugin includes an option to freeze or unfreeze the header row in Google Sheets.

Can I view, clear, or download the connected Google Sheet?

Yes. You can access your linked Google Sheet from the plugin settings with options to view, clear, or download it.

What should I do if I see a «This app isn’t verified» warning from Google?

If you created the Google API credentials yourself, click “Advanced” and then “Go to project” to continue. It’s safe if you’re the app owner.

Why is there a «range exceeds grid limits» error in Sheets?

This occurs when the sheet reaches its maximum row or column limit. Simply increase the number of rows in your Google Sheet to fix this.

Reviews

Read all 1 review

Contributors & Developers

“WPSyncSheets For WPForms — Google Sheets Connector for WPForms & Real‑Time Data Export” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.6.9.3

  • Optimized code

1.6.9.2

  • Tested with WPForms 1.9.7.3
  • Tested with WordPress 6.8.2

1.6.9.1

  • Add «Upgrade to Pro» link

1.6.9

  • Add Dashboard Tab

1.6.8

  • Add Feedback Form Popup
  • UI & UX Changes

1.6.7

  • Modified Submission Date and Submission Time in sheet headers

1.6.6

  • Optimized code

1.6.5

  • UI/UX Changes

1.6.4

  • Tested with WordPress 6.8

1.6.3

  • Fixed: Multisite plugin activation not being recognized.
  • Fixed: Resolved an issue with the refresh token.

1.6.2

  • Added is_plugin_active() function_exists for improved security in plugin operations.

1.6.1

  • Performed user capability check for secure operation execution.

1.6

  • Added nonce functionality for improved security in plugin operations.

1.5.2

  • Optimized code

1.5.1

  • Tested with WordPress 6.7.1
  • Updated & Tested with Guzzle Library 7.9.2

1.5

  • Optimized code

1.4

  • Enable\Disable Sheet Headers
  • Submission Date & Time options
  • Clear spreadsheet
  • Optimized code

1.3

  • Optimized code

1.2

  • Optimized code
  • Coding Standards Improvement & Security Patch

1.1

  • Optimized code
  • Download Spreadsheet Button
  • Load Library

1.0

  • Initial Version