WPForms
98The best WordPress contact form plugin. Drag & Drop form builder to create beautiful contact forms, paymen...
Free
5M+ installs 4.8★ (14,369)
CF7 Spreadsheets
Wordpress plugin that merge Contact form 7 functional with google spreadsheets (also works with private spreadsheet).
The facts
- Rating
- 4.7★ from 19
- Active installs
- 300+
- Price
- Free
- Last updated
- 29 Dec 2020
- Added
- Jan 2017
- Requires WP
- 4.7
- Tested up to
- WP 5.6.19
- Downloads
- 12,174
Our analysis
AI-assistedCF7 Spreadsheets is a WordPress plugin that integrates Contact Form 7 with Google Sheets, allowing you to save form submissions directly to a spreadsheet. It supports both public and private spreadsheets, provided you set up the necessary API credentials and permissions. This plugin is suitable for users who want to manage form data in a spreadsheet format for easier analysis or record-keeping.
To use the plugin, you need to enable the Google Sheets API, create a service account, and upload the JSON credentials file in the plugin settings. After setting up, you can create forms using Contact Form 7 and link them to your Google Sheets for data collection.
Best for: This plugin suits WordPress users who need to collect and manage form submissions in Google Sheets.
What it does well
- ✓Integrates Contact Form 7 with Google Sheets
- ✓Supports both public and private spreadsheets
- ✓Free to use from the WordPress.org directory
Where it falls short
- •Requires API setup which may be complex for some users
- •Limited information on support or updates since December 2020
Verdict
CF7 Spreadsheets offers a straightforward solution for linking form submissions to spreadsheets, but may require technical setup that could be challenging for some users.
From the developer
moshensky's own description of CF7 Spreadsheets, lightly tidied.
WordPress plugin that merge Contact form 7 functional with google spreadsheets (also works with private spreadsheet).
How to use:
Video instruction: https://www.youtube.com/watch?v=ZgZRBByY4fc
Video instruction (OLD versions): https://www.youtube.com/watch?v=5ICWr5MMo7E
- Prepare API
- Go to the Console Developers API
- Create new project (or choose existing one)
- Click “enable API and services”, or click on “library” tab
- Find in list “Google sheets API” and click “Enable”
- Go to
Credentialstab and clickcreate credentials. In dropdown list chooseService account key. In next window select you service account, andKey typetoJSON. - Save the JSON document
- Upload JSON document on plugin page (second tab).
- Create a table
- Go to the Google Spreadsheets and create new table (or open exists table)
- Copy table URL and ID. For example:
//docs.google.com/spreadsheets/d/1yhzO1Q6ikYysfg8LCHqegPM/edit#gid=0in this table URL is:1yhzO1Q6ikYysfg8LCHqegPM, and ID is:0(parametergid). - If you have private spreadsheet – you should grant edit rights to your service account (that we create earlier) directly in spreadsheet. You could find service account email in your website admin panel after uploading JSON file.
- Paste the spreadsheet URL and ID in plugin options page, upload JSON file, and choose other options.
- Create usual form in
Contact form 7and use it.
Tagged as
Alternatives
Other plugins for building forms.
The best anti-spam protection to block spam comments and spam in a contact form. The most trusted antispam sol...
Free
5M+ installs 4.7★ (1,186)
Fluent Forms
94Get a fast contact form plugin. Create advanced forms using drag and drop form builder with all smart features...
Free
700k+ installs 4.8★ (790)
Best WordPress form builder plugin. Create contact forms, payment forms & order forms with 1000+ integrati...
Free
600k+ installs 4.8★ (2,117)
Save and manage Contact Form 7 messages. Never lose important data. It is a lightweight contact form 7 databas...
Free
600k+ installs 5★ (1,874)
MetForm
93Elementor forms builder to create WordPress forms like contact form, booking form, feedback form, survey form,...
Free
600k+ installs 4.7★ (504)