On previous articles we covered how to store your Contact Form 7 enquiries on the WordPress backend by using a database plugin.
You can choose to integrate Google Sheets with Contact Form 7 alongside the above or as a standalone. We’ve tested both together and they work just fine. You may want to install the database plugin just as a fallback in case you ever have any issue with the Google Sheets integration as Google keeps changing the rules on these things and some times plugin publishers may be temporarily caught out, especially if it’s a free plugin as they don’t generally have the resources to respond as quickly.
You can integrate Google Sheets with Contact Form 7 by using a number of plugins but the great majority of them are paid and can be found on Code Crayon but these are obviously paid. Some do have some advanced functionality so worth a look anyways:
On the official free WordPress plugin directory there seems to be just 2. We’re focusing on 1 of them now and the second one will be listed below.
The one we really liked and fully tested is this one:
It only takes a minute to configure and it basically it transfer every single field from the Contact Form 7 web form onto Google Sheets automatically. Every entry is added as a separate row – it does not have a uniquely identifier field/ID which is helpful as it prevents overwriting.
Top tip: read documentation carefully to ensure Google Sheets tab and column names match so that the mapping can occur properly first time.
This is what it looks like on Google Sheets:
The plugin offers a handy demo page where you can submit enquiries: https://cf7demo.gsheetconnector.com/ and then you can check the submitted results on the demo Google Sheets itself on https://docs.google.com/spreadsheets/d/1ooBdX0cgtk155ww9MmdMTw8kDavIy5J1m76VwSrcTSs/edit#gid=0
Note: Be sure not to submit any real personal details to this demo sheet as this is a publicly accessible sheet.
The first time we tested this it did not work but it eventually appeared after a few hours. On the other hand, once we installed it ourselves on our site it’s worked fine straight away and results appear immediately every time.
Top tip: by default it shows lots of irrelevant fields which it collects automatically on Google Sheets such as IP. We’ve just deleted the columns we did not want (or moved them out of the way) and then added additional ones we care about (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc). In other words, you can use all the fields we currently capture on the form (even if it’s going through additional plugins – eg. if you have a file upload plugin).
That’s it! Now you have a Google Sheet with live enquiries – you can analyse this information in any way you wish by sorting, searching, creating graphs, etc just like you would on any other Google Sheet.
Top tip: If you are running Woocommerce for your ecommence there are also plugins that will transfer these details to the same Google Sheet. We’ll write more on this soon but if you can’t wait, this free plugin will be helpful:
It transfers the Contact Form 7 plugin info across to a Google Sheets doc just like the previous plugin but in addition it also transfers basic Woocommerce order derails across: