=== CF7 Google Sheets Connector ===
Contributors: westerndeal, sooskriszta, julius1986
Author URL: http://profiles.wordpress.org/
Tags: google, sheets, google sheets, googlesheets, google sheet connector, spreadsheet, integration, cf7, contact form 7
Requires at least: 3.5
Tested up to: 4.5
Stable tag: 4.6
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

This plugin currently supports connecting the Contact Form 7 to Google Sheets. This is a simplest way to send data to the Google Sheets.

== Description ==

= How to Use this Plugin =

* Install the CF7 Google Sheet Connector plugin if you haven't already. 
* You will notice a new Menu under contact form which says "Google Sheets"
* Now First of all log in to your Google Account and create a new Sheet and give it a simple name. 
* Rename Sheet 1 (tab 1 of the spreadhseet) to something simple that makes sense (maybe the name of your form).
* Add a column name in Row 1 for "date" and each form field you will have in your form (default CF7 form field names are "your-name", "your-email", "your-subject", "your-message"). 
* Go to 'Google Sheets' menu page to configure the plugin and click the "Get Code" to retrieve your code from Google Drive to allow us to access your spreadsheets. And paste the code in the given textbox and save it . 
* Do check the debug log file to know is your configuration successful or not .
* Now create a contact form or edit existing contact form you will notice a "Google Sheet" tab. Copy / paste the name of your spreadsheet and tab name into the given textbox to which you want to link it .
* Save your settings.
* Test your form submit and verify that the data shows up in your Google Sheet.

= 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 Sheets and plugin / form settings.

== Installation ==

1. Log in to your WordPress site as an administrator
2. Use the built-in Plugins tools to install from the repository or unzip and Upload the plugin directory to /wp-content/plugins/ 
3. Activate the plugin through the 'Plugins' menu in WordPress
4. The current output of the plugin teamplate can be seen by going to Contact > Google Sheet menu

== Screenshots ==

1. Google Sheet access 
2. Configure your Google Spreadsheet and your Contact Form 

== Frequently Asked Questions ==

= Why isn't the data send to spreadsheet ? CF7 Submit is just Spinning. = 
Sometimes it can take a while of spinning before it goes through. But if the entries never show up in your Sheet then one of these things might be the reason:

1. Wrong access code ( Check debug log )
2. Wrong Sheet name or tab name
3. Wrong Column name mapping

Please double-check those things and hopefully one of them is the cause.

== Changelog ==

= 1.0 =
* First public release
* Integrated Contact form 7 with Google sheets