{"id":34,"date":"2020-10-23T06:19:35","date_gmt":"2020-10-23T00:49:35","guid":{"rendered":"https:\/\/westerndeal.com\/client\/westerndealpost\/?p=34"},"modified":"2020-10-23T06:19:35","modified_gmt":"2020-10-23T00:49:35","slug":"how-to-connect-a-google-sheet-with-wpforms","status":"publish","type":"post","link":"https:\/\/westerndeal.com\/westerndeal-new\/blog\/how-to-connect-a-google-sheet-with-wpforms\/","title":{"rendered":"How to Connect a Google Sheet with WPForms? Updated Oct 2020"},"content":{"rendered":"<h1><a href=\"https:\/\/westerndeal.com\/westerndeal-new\/go\/GSheetConnector\" target=\"_blank\" rel=\"nofollow noopener\" data-schema-attribute=\"about mentions\">WPForms Google Sheet Connector<\/a><br \/>\nis one of the greatest plugins to connect your WPForms with Google Sheets<\/h1>\n<p><strong><div class=\"wp-pic-wrapper align-center wordpress\" ><div class=\"wp-pic wordpress plugin \"  id=\"wp-pic-gsheetconnector-wpforms\" ><div class=\"wp-pic-wordpress\" style=\"display: none;\">\n\t<div class=\"wp-pic-wordpress-content\">\n\t\t<div class=\"wp-pic-plugin-card-top\">\n\t\t\t<div class=\"wp-pic-column-name\">\n\t\t\t\t<h3>\n\t\t\t\t\t<a href=\"https:\/\/wordpress.org\/plugins\/gsheetconnector-wpforms\/\" title=\"More information about GSheetConnector &#8211; WPForms Google Sheets Connector\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\tGSheetConnector &#8211; WPForms Google Sheets Connector\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/ps.w.org\/gsheetconnector-wpforms\/assets\/icon-128x128.gif?rev=3232730\" class=\"wp-pic-plugin-icon\" alt=\"\">\t\t\t\t\t<\/a>\n\t\t\t\t<\/h3>\n\t\t\t<\/div>\n\t\t\t<div class=\"wp-pic-action-links\">\n\t\t\t\t<a class=\"wp-pic-action-buttons\" href=\"https:\/\/downloads.wordpress.org\/plugin\/gsheetconnector-wpforms.4.1.0.zip\" title=\"Download\" target=\"_blank\" rel=\"noopener\">Download<\/a>\n\t\t\t<\/div>\n\t\t\t<div class=\"wp-pic-column-description\">\n\t\t\t\t<p>Connect WPForms to Google Sheets and automatically send form entries to a google sheet in real-time. No manual exports, no coding required.<\/p>\n\t\t\t\t\t\t\t\t\t<p class=\"authors\">By <cite><a href=\"https:\/\/profiles.wordpress.org\/westerndeal\/\" target=\"_blank\" rel=\"noopener noreferrer\">WesternDeal<\/a><\/cite><\/p>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"wp-pic-plugin-card-bottom\">\n\t\t\t<div class=\"wp-pic-column-rating\" title=\"(based on 18 ratings)\">\n\t\t\t\t<div class=\"star-rating\"><span class=\"screen-reader-text\">4.5 rating based on 18 ratings<\/span><div class=\"star star-full\" aria-hidden=\"true\"><\/div><div class=\"star star-full\" aria-hidden=\"true\"><\/div><div class=\"star star-full\" aria-hidden=\"true\"><\/div><div class=\"star star-full\" aria-hidden=\"true\"><\/div><div class=\"star star-half\" aria-hidden=\"true\"><\/div><\/div>\t\t\t\t<span class=\"wp-pic-num-ratings\" aria-hidden=\"true\">(18)<\/span>\n\t\t\t<\/div>\n\t\t\t<div class=\"wp-pic-column-updated\">\n\t\t\t\t<strong>Last Updated:<\/strong> 6 days ago\t\t\t<\/div>\n\t\t\t<div class=\"wp-pic-column-downloaded\">\n\t\t\t\t8,000+ Active Installs\t\t\t<\/div>\t\n\t\t\t<div class=\"wp-pic-column-compatibility\">\n\t\t\t\t<span class=\"wp-pic-compatibility-compatible\">Compatible with WordPress 5.6<\/span>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><\/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>\nTo Connect Google Sheet and WPForms<\/strong><\/p>\n<p>Successfully Install WPForms and GSheetConnector-WPForms Plugins then Activate the plugin through the \u2018Plugins\u2019 Screen in WordPress.<\/p>\n<p>Use the Admin Panel &gt; WPForms &gt; Google Sheet screen to Add do Integration Google Access Code.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-medium wp-image-35 aligncenter\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/wpforms-gsheet-menu-300x206.png\" alt=\"\" width=\"300\" height=\"206\" \/><\/p>\n<p>Here you will need to integrate WPForms plugin with your Google account. Simply click on the \u201cGet Code\u201d button to get an access code for authentication<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"alignleft wp-image-36 size-full\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/Gsheet-Access-Code.png\" alt=\"\" width=\"628\" height=\"382\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>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.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-37 size-full\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/google-access-code-page-1.jpg\" alt=\"\" width=\"365\" height=\"480\" \/><\/p>\n<p>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.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38 size-full\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/google-access-code-1.png\" alt=\"\" width=\"698\" height=\"458\" \/><\/p>\n<p>Go to Google Drive, Create a New Google Sheet, and Add Google Sheet Title and Google Sheet Tab Name.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-39 size-full\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/gsheet-create.png\" alt=\"\" width=\"652\" height=\"309\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After integration, you will lead to GoogleSheet Form Settings tab. In GoogleSheet Form Settings tab there is a dropdown to select a form in which you will see a listing of all the forms of WPForms. You will have to select one form which you want to connect with your Google sheet.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-40 size-full\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/select-gsheet-lite.jpg\" alt=\"\" width=\"555\" height=\"277\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After selecting a form you will see Google Sheet Settings.<\/p>\n<p>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 WPForm.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-41 \" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/select-gsheet-name-and-tab-name.jpg\" alt=\"\" width=\"557\" height=\"480\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Provide Google Sheets Column Header<\/strong><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>In the Google sheets tab, provide column names in row 1. Like the first column is \u201cName\u201d. For each further column, copy-paste the Form label from the WPForms form (e.g. \u201cName\u201d, \u201cEmail\u201d, \u201cComment-or-Message\u201d, etc).<\/li>\n<li>The fields name should be with a specific format like if the WPForms field label is \u201cComment or Message\u201d your google sheet column name should be \u201cComment-or-Message\u201d same with all the labels (e.g Firstname Lastname = \u201cFirstname-Lastname\u201d, zip code = \u201czip-code\u201d, etc).<\/li>\n<li>Lastly, Test your WPForms and verify that the data shows up in your Google Sheet.<\/li>\n<li>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 WPForms settings.<\/li>\n<li>Also while inputting the WPForm field label to Google Sheet follow the rules if there is an empty space between the label name it will not send the WPForm data to Google Sheet.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-42 size-full\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/client\/westerndealpost\/wp-content\/uploads\/2019\/07\/gsheet-create-1.png\" alt=\"\" width=\"652\" height=\"309\" \/><\/p>\n<p>Refer Documentation here<\/p>\n<ul class=\"wedocs-doc-sections\">\n<li><a href=\"https:\/\/www.gsheetconnector.com\/docs\/wpforms-gsheetconnector-free\/installation\" target=\"_blank\" rel=\"nofollow noopener\" data-schema-attribute=\"\">Installation<\/a><\/li>\n<li><a href=\"https:\/\/www.gsheetconnector.com\/docs\/wpforms-gsheetconnector-free\/how-to-connect-a-google-sheet-with-wpforms\" target=\"_blank\" rel=\"nofollow noopener\" data-schema-attribute=\"\">How to Connect a Google Sheet to WPForms?<\/a><\/li>\n<li><a href=\"https:\/\/www.gsheetconnector.com\/docs\/wpforms-gsheetconnector-free\/full-installation-tutorial\" target=\"_blank\" rel=\"nofollow noopener\" data-schema-attribute=\"\">Video Guide<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WPForms Google Sheet Connector is one of the greatest plugins to connect your WPForms with Google Sheets To Connect Google Sheet and WPForms Successfully Install WPForms and GSheetConnector-WPForms Plugins then Activate the plugin through the \u2018Plugins\u2019 Screen in WordPress. Use the Admin Panel &gt; WPForms &gt; Google Sheet screen to Add do Integration Google Access&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2071,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[],"class_list":["post-34","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wpforms"],"_links":{"self":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts\/34","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=34"}],"version-history":[{"count":1,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts\/34\/revisions"}],"predecessor-version":[{"id":987980,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts\/34\/revisions\/987980"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/media\/2071"}],"wp:attachment":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/media?parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/categories?post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/tags?post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}