Wordpress plugins
CF7 to Spreadsheet

CF7 to Spreadsheet

Version : 1.1.0
Tested up to : 5.1.1
Number of download : 678
Average rating : 4 / 5 on 4 votes 4 votes, 4 avg.rating

Screenshots

CF7 to Spreadsheet
CF7 to Spreadsheet
CF7 to Spreadsheet
CF7 to Spreadsheet

This plugin connects your Contact Form 7 and Google Spreadsheet. When a visitor submits his/her data on your website via a Contact Form 7 form, on form submission, such data are added into Google Spreadsheet. This is a simple way to maintain your contact form 7 data backup. How to Use this Plugin In Google Spreadsheet Log into your Google Account and visit Google Spreadsheet. Create a new Sheet and name it. Rename the tab on which you want to capture the data. In the Google sheets tab, provide column names in row 1. The first column should be “date” if you want to add date. For each further column, copy paste mail tags from the Contact Form 7 form (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc). Also, you can add required mail tags (e.g “your-name”, “your-email”). Process to generate API key Follow the steps from this url to create a project: https://docs.brainstormforce.com/create-google-sheet-api-key/ After the project is created, go to Quotas tab, click on “Google sheet Api” and then on Credentials Press Create Credentials Select OAuth client ID Select Other, give it a name and Save You’ll get a popup with client Id and client secret Copy/paste those on lines 13 and 14 (see above) You need to Reconnect the plugin – go to Wp Admin/Settings/CF7 to Spreadsheet/Press “Reconnect with google Spreadsheet In WordPress Admin Create or Edit the Contact Form 7 form from which you want to capture the data. Set up the form as usual in the Form and Mail etc tabs. Thereafter, go to the new “CF7 to Spreadsheet” tab. On the “CF7 to Spreadsheet” tab, copy-paste the Google Spreadsheets sheet name and tab name into respective positions, and hit “Save”. Important Notes You must pay very careful attention to your naming. This plugin will have unpredictable results if names and spellings do not match between your Google Spreadsheets and form settings. Also, naming is not case sensitive.

Download now