{"id":20,"date":"2020-07-08T04:36:29","date_gmt":"2020-07-07T23:06:29","guid":{"rendered":"https:\/\/westerndeal.com\/client\/westerndealpost\/?p=20"},"modified":"2025-11-05T10:01:49","modified_gmt":"2025-11-05T10:01:49","slug":"how-to-store-contact-form-7-data-to-google-sheets","status":"publish","type":"post","link":"https:\/\/westerndeal.com\/westerndeal-new\/blog\/how-to-store-contact-form-7-data-to-google-sheets\/","title":{"rendered":"How to Store Contact Form 7 Data to Google Sheets &#8211; Updated 2020"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"20\" class=\"elementor elementor-20\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-aeb45bf e-flex e-con-boxed e-con e-parent\" data-id=\"aeb45bf\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e4b6bff elementor-widget elementor-widget-text-editor\" data-id=\"e4b6bff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<strong>Introduction:<div class=\"wp-pic-wrapper align-center large\" ><div class=\"wp-pic large plugin scheme1\"  id=\"wp-pic-cf7-google-sheets-connector\" ><div class=\"wp-pic-large\" style=\"display: none;\">\n\t<div class=\"wp-pic-large-content\">\n\t\t<a class=\"wp-pic-asset-bg\" href=\"https:\/\/wordpress.org\/plugins\/cf7-google-sheets-connector\/\" target=\"_blank\" title=\"WordPress.org Plugin Page\" rel=\"noopener\">\n\t\t\t<img decoding=\"async\" src=\"https:\/\/ps.w.org\/cf7-google-sheets-connector\/assets\/banner-772x250.gif?rev=3620029\" alt=\"GSheetConnector \u2013 Contact Form 7 Google Sheets Connector &amp; Save CF7 Entries to Database\" \/>\t\t\t<span class=\"wp-pic-asset-bg-title\"><span>GSheetConnector \u2013 Contact Form 7 Google Sheets Connector &amp; Save CF7 Entries to Database<\/span><\/span>\n\t\t<\/a>\n\t\t<div class=\"wp-pic-half-first\">\n\t\t\t<a class=\"wp-pic-logo\" href=\"https:\/\/wordpress.org\/plugins\/cf7-google-sheets-connector\/\" style=\"background-image: url(https:\/\/ps.w.org\/cf7-google-sheets-connector\/assets\/icon-128x128.gif?rev=3620029 );\" target=\"_blank\" title=\"WordPress.org Plugin Page\" rel=\"noopener\"><\/a>\n\t\t\t<p class=\"wp-pic-author\">Author(s):\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/profiles.wordpress.org\/westerndeal\/\" target=\"_blank\" rel=\"noopener\">WesternDeal<\/a>\n\t\t\t\t\t\t\t<\/p>\n\t\t\t<p class=\"wp-pic-version\"><span>Current Version:<\/span> 5.2.3<\/p>\n\t\t\t<p class=\"wp-pic-updated\"><span>Last Updated:<\/span> August 1, 2026<\/p>\n\t\t\t<p><a class=\"wp-pic-dl-link\" href=\"https:\/\/downloads.wordpress.org\/plugin\/cf7-google-sheets-connector.5.2.3.zip\" title=\"Direct download\" target=\"_blank\" rel=\"noopener\">Direct Download<\/a><\/p>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"wp-pic-half-last\">\n\t\t\t<div class=\"wp-pic-bottom\">\n\t\t\t\t<div class=\"wp-pic-bar\">\n\t\t\t\t\t<a href=\"https:\/\/wordpress.org\/support\/view\/plugin-reviews\/cf7-google-sheets-connector\" class=\"wp-pic-rating\" target=\"_blank\" title=\"Ratings\" rel=\"noopener\">\n\t\t\t\t\t\t88%<em>Ratings<\/em>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t<a href=\"https:\/\/downloads.wordpress.org\/plugin\/cf7-google-sheets-connector.5.2.3.zip\" class=\"wp-pic-downloaded\" target=\"_blank\" title=\"Direct download\" rel=\"noopener\">\n\t\t\t\t\t\t40,000+<em>Installs<\/em>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t<a href=\"https:\/\/wordpress.org\/plugins\/cf7-google-sheets-connector\/\" class=\"wp-pic-requires\" target=\"_blank\" title=\"WordPress.org Plugin Page\" rel=\"noopener\">\n\t\t\t\t\t\tWP 6.7+<em>Requires<\/em>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div>\n<\/div><\/div><!-- .wp-pic-wrapper--><link rel='stylesheet' id='dashicons-css' href='https:\/\/westerndeal.com\/westerndeal-new\/wp-includes\/css\/dashicons.min.css?ver=d4f80eee8c6da2a38097528e3e37bc20' media='all' \/>\n<link rel='stylesheet' id='wppic-style-css' href='https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/plugins\/wp-plugin-info-card\/dist\/wppic-styles.css?ver=6.3.0' media='all' \/>\n<script id=\"jquery-core-js\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/wp-includes\/js\/jquery\/jquery.min.js?ver=3.7.1\"><\/script>\n<script id=\"jquery-migrate-js\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/wp-includes\/js\/jquery\/jquery-migrate.min.js?ver=3.4.1\"><\/script>\n<script id=\"wppic-script-js-extra\">\nvar wppicAjax = {\"ajaxurl\":\"https:\/\/westerndeal.com\/westerndeal-new\/wp-admin\/admin-ajax.php\"};\n\/\/# sourceURL=wppic-script-js-extra\n<\/script>\n<script id=\"wppic-script-js\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/plugins\/wp-plugin-info-card\/assets\/js\/wppic-script.min.js?ver=6.3.0\"><\/script>\n<\/strong>\n<ul>\n \t<li><a href=\"https:\/\/westerndeal.com\/westerndeal-new\/go\/GSheetConnector\" target=\"_blank\" rel=\"nofollow noopener\">CF7 GSheetConnector<\/a> is the Powerful Connector Bridge between\u00a0 Contact Form 7 and Google sheets.<\/li>\n \t<li>It also Supports WordPress Multisite and You can Add Multiple Forms and Connect Your Forms to the Sheets.<\/li>\n<\/ul>\n<strong>To Connect Google Sheet and Contact Form 7<\/strong>\nSuccessfully Install Contact Form 7 and CF7 Google Sheet Connector Plugins then Activate the plugin through the \u2018Plugins\u2019 Screen in WordPress.\n<ul>\n \t<li>Use the Admin Panel &gt; Contact form 7 &gt; Google Sheet screen to Add do Integration Google Access Code.<\/li>\n<\/ul>\n<img decoding=\"async\" class=\"size-medium wp-image-80 aligncenter\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/google-sheet-button.png\" alt=\"\" width=\"269\" height=\"128\" \/>\n<ul>\n \t<li>Here you will need to integrate Contact Form 7 plugin with your Google account. Simply click on the \u201cGet Code\u201d button to get an access code for authentication.<\/li>\n<\/ul>\n<img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-96\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/Google-Access-code.jpg\" alt=\"\" width=\"578\" height=\"257\" \/>\n<ul>\n \t<li>By clicking on the get code button it will redirect you to your Gmail account. Sign in and you will get a message to allow create, edit, delete and view your google sheets.<\/li>\n<\/ul>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-97\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/Google-Access-Code-1.jpg\" alt=\"\" width=\"449\" height=\"665\" \/>\n<ul>\n \t<li>By clicking on the Allow button you will get your access code. You can copy code and enter the code in the textbox and save it. After saving the code you will see a message in green that the Access code was saved. But do check debug log for invalid access code<\/li>\n<\/ul>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-98\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/Activate-Google-Access-Code.jpg\" alt=\"\" width=\"578\" height=\"289\" \/>\n<ul>\n \t<li>Go to Google Drive, Create a New Google Sheet, and Add Google Sheet Title and Google Sheet Tab Name.<\/li>\n<\/ul>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-100\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/Google-sheet.png\" alt=\"\" width=\"691\" height=\"345\" \/>\n<ul>\n \t<li>Go to the Contact form 7 &gt; Here click on edit of Contact form for which you want to connect with Google Sheet.<\/li>\n<\/ul>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-102\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/Contact-form-edit.jpg\" alt=\"\" width=\"528\" height=\"372\" \/>\n<ul>\n \t<li>Click on the Google Sheet Tab.<\/li>\n \t<li>From the Respective Google Sheet copy-paste the \u201cGoogle Sheet Title\u201d and \u201cGoogle Sheet Tab Name\u201d on the Google Sheets Tab in the Contact Form 7.<\/li>\n<\/ul>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-103\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/Google-sheet-Tab-1.jpg\" alt=\"\" width=\"789\" height=\"235\" \/>\n<ul>\n \t<li>Go to Google Drive in the Google sheets tab, provide column names in row 1. (e.g. \u201cyour-name\u201d, \u201cyour-email\u201d, \u201cyour-subject\u201d, \u201cyour-message\u201d, etc).<\/li>\n<\/ul>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-106\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/CF7GSheet-data.png\" alt=\"\" width=\"688\" height=\"343\" \/>\n<ul>\n \t<li>Test your form submit and verify that the data shows up in your Google Sheet.<\/li>\n<\/ul>\n&nbsp;\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Introduction: CF7 GSheetConnector is the Powerful Connector Bridge between\u00a0 Contact Form 7 and Google sheets. It also Supports WordPress Multisite and You can Add Multiple Forms and Connect Your Forms to the Sheets. To Connect Google Sheet and Contact Form 7 Successfully Install Contact Form 7 and CF7 Google Sheet Connector Plugins then Activate the&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2073,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62,63],"tags":[],"class_list":["post-20","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-contact-form","category-wordpress"],"_links":{"self":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts\/20","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/comments?post=20"}],"version-history":[{"count":4,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts\/20\/revisions"}],"predecessor-version":[{"id":987998,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts\/20\/revisions\/987998"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/media\/2073"}],"wp:attachment":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/media?parent=20"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/categories?post=20"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/tags?post=20"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}