Alex Agranov

This plugin provides integration between <a href="https://wordpress.org/plugins/contact-form-7/" rel="ugc">Contact Form 7</a> and <a href="https://www.google.com/sheets/" rel="nofollow ugc">Google Sheets</a>. 
It adds new processor to Contact Form 7 that enables sending of submitted forms to Google Sheets.
<h4>Connecting the Plugin to Google Sheets</h4>
After installing the plugin you must go to it’s Settings screen and create application credentials needed to establish connection with Google Sheets. All instructions are provided in the Settings screen.
After successfully creating application credentials and uploading them (i.e. completing steps 1 and 2), you will see Client ID and Client Email that represent your instance of “Google Sheets for Contact Form 7” plugin. You will need to share your sheets with Client Email (as Editor role) to grant “Google Sheets for Contact Form 7” plugin permissions to edit them.
<h4>Using the Plugin</h4>
After successfully connecting the plugin to Google Sheets, do the following to configure your Contact Form 7 to send data to Google Sheets on form submission.
In Google Sheets
<ul>
<li>Create a new Google Sheet</li>
<li>Switch to the tab where you want to capture the data</li>
<li>
Determine Sheet ID and Tab ID from the sheet’s URL that looks as follows: https://docs.google.com/spreadsheets/d/sheet-id/edit#gid=tab-id
For example, for URL https://docs.google.com/spreadsheets/d/142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64/edit#gid=0 Sheet ID is “142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64” and Tab ID is “0”
</li>
<li>
Enter “datetime” in the the first column if you want to capture time and date of submission
</li>
<li>There is no need to enter names for other columns – they will be automatically added upon form submission</li>
<li>Share the sheet with Client Email that represents your instance of “Google Sheets for Contact Form 7” plugin – as Editor role</li>
</ul>
In Contact Form 7
<ul>
<li>Open your contact form</li>
<li>Switch to Google Sheets tab</li>
<li>Configure Sheet ID and Tab ID and click Save</li>
<li>Submit a test form and verify that the data shows up in your Google Sheet</li>
</ul>
<h4>Automatic Header Generation</h4>
The plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed. Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually. You may also manually reorder columns as you wish.
<h4>Capturing Submission Metadata</h4>
In addition to the datetime and regular form fields, you may also capture Contact Form 7 <a href="https://contactform7.com/special-mail-tags" rel="nofollow ugc">special mail-tags</a>. In order to do so, add manually corresponding headers to your spreadsheet. Remove square brackets and first underscore from the tag name, and replace remaining underscores with dashes. For example, add remote-ip header to capture [_remote_ip] mail-tag.
<h4>Integration with “Contact Form 7 Database Addon – CFDB7”</h4>
If you use <a href="https://wordpress.org/plugins/contact-form-cfdb7/" rel="ugc">Contact Form 7 Database Addon – CFDB7</a> to save your submissions, you will also be able to resend already submitted forms to Google Sheets. This may be useful if something went wrong during initial form submission and/or someone deleted data in Google Sheets by mistake. In order to do so, in CFDB7 plugin, choose your form, open specific submission and click Send to Google Sheets button.
<h4>Acknowledgements</h4>
Initial version of this plugin was inspired by <a href="https://wordpress.org/plugins/cf7-google-sheets-connector/" rel="ugc">CF7 Google Sheets Connector</a> plugin.
However it’s implementation is quite different:
<ul>
<li>it uses service principle for authentication with Google Sheets</li>
<li>it has completely different and much more reliable sheets update logic</li>
<li>it implements automatic header generation, to ensure that no submission data is lost</li>
<li>it supports capturing submission meta-data</li>
<li>it provides integration with CFDB7 plugin for forms re-submission</li>
</ul>

Integration with Google Sheets for Contact Form 7

Send your Contact Forms 7 submissions directly to your Google Sheets spreadsheet.

Pagecode

This plugin allows you to create tables/sheets easily as an Admin, you can colour code the tables, add up rows and columns, and create unlimited tables for free.
This is a plug and play solution for those who want to show visitors simple tables and only want Admins to edit them. Users can search rows and columns for specific data.
The plugin has no additional options but will work dynamically on any page.
Demo of this plugin can be seen here: <a href="https://sandbox-pagecode-com.pagehost.co.uk/table/" rel="nofollow ugc">Click here</a>
As you can see the table shows a list of data, which was added by an Admin, users can sort through this data with ease, this is a basic spreadsheet.
The table is added to the page with a unique key, each key is a new table/spreadsheet, for example if you want to make a table you would use the shortcode below:
[tablestatistics table=”demo”] this would then show a table, and all data added would be saved under demo.
You could then display this shortcode on any page, or you can create another new table, using a different name.
To colour code your table you can add colorcode=”true” to the shortcode, for example [tablestatistics table=”demo” colorcode=”true”]
Colour coding will check if the number is above 0 or less than 0, if it is above 0, then it will be green, if it is below 0 then it will be red.
If you would like to add up the totals of a row, it will add up all the numbers in that row and ignore any text, use {{total}} in a box at the end.
You can also add up totals of columns using {{total.col}}

Dynamic Datatables

This plugin allows you to create custom tables on the fly. You can make unlimited tables, add new rows, columns or delete them and create formulas to  …

Integration with Google Sheets for Contact Form 7 vs Dynamic Datatables