{"id":32040,"date":"2014-10-02T00:43:28","date_gmt":"2014-10-02T00:43:28","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/ns-google-sheets-connector\/"},"modified":"2019-02-28T00:01:06","modified_gmt":"2019-02-28T00:01:06","slug":"ns-google-sheets-connector","status":"closed","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/ns-google-sheets-connector\/","author":10624012,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.2.6","stable_tag":"trunk","tested":"5.0.25","requires":"3.5","requires_php":"","requires_plugins":"","header_name":"NS Google Sheets Connector","header_author":"Never Settle","header_description":"","assets_banners_color":"feab92","last_updated":"2019-02-28 00:01:06","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/www.paypal.com\/cgi-bin\/webscr?cmd=_s-xclick&hosted_button_id=RM625PKSQGCCY&rm=2","header_plugin_uri":"http:\/\/neversettle.it","header_author_uri":"http:\/\/neversettle.it","rating":4.1,"author_block_rating":0,"active_installs":90,"downloads":11197,"num_ratings":0,"support_threads":1,"support_threads_resolved":1,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":[],"ratings":{"1":"2","2":0,"3":0,"4":"1","5":"7"},"assets_icons":{"icon-128x128.jpg":{"filename":"icon-128x128.jpg","revision":"1000218","resolution":"128x128","location":"assets"},"icon-256x256.jpg":{"filename":"icon-256x256.jpg","revision":"1000218","resolution":"256x256","location":"assets"}},"assets_banners":{"banner-772x250.jpg":{"filename":"banner-772x250.jpg","revision":"1000218","resolution":"772x250","location":"assets"}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0","1.0.1","1.0.2","1.0.3","1.1.0","1.2.0","1.2.1","1.2.2","1.2.4","1.2.5","1.2.6"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1000218","resolution":"1","location":"assets"}},"screenshots":{"1":"Plugin Settings and How to Configure your Google Spreadsheet and your Contact Form"}},"plugin_section":[],"plugin_tags":[25308,150,25296,597,46506],"plugin_category":[42],"plugin_contributors":[82875],"plugin_business_model":[],"class_list":["post-32040","plugin","type-plugin","status-closed","hentry","plugin_tags-connector","plugin_tags-google","plugin_tags-google-sheets","plugin_tags-integration","plugin_tags-sheets","plugin_category-contact-forms","plugin_contributors-neversettle","plugin_committers-neversettle"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/ns-google-sheets-connector_feab92.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/ns-google-sheets-connector\/assets\/screenshot-1.png?rev=1000218","caption":"Plugin Settings and How to Configure your Google Spreadsheet and your Contact Form"}],"raw_content":"\n

NOW Supports Connecting to Google via OATH! This plugin currently supports connecting the Contact Form 7 plugin to Google Sheets, but let us know what other kinds of data you'd like this to capture!<\/p>\n\n

The PRO Version<\/a> is now available, and provides connections between unlimited CF7 forms and Google Spreadsheets! We also just added basic integration and support for automatically sending basic WooCommerce data to Google Sheets!<\/p>\n\n

How to Use this Plugin<\/h4>\n\n

(Take a look at the screenshot to see how it all ties together and what settings need to go where!)<\/p>\n\n

    \n
  1. Install the Contact Form 7 (CF7) plugin if you haven't already. <\/li>\n
  2. Create the CF7 Form that you want to use to capture data. You will need the ID and field names from the form.<\/li>\n
  3. Log in to your Google Account and create a new Sheet and give it a simple name. <\/li>\n
  4. Rename Sheet 1 (tab 1 of the spreadhseet) to something simple that makes sense (maybe the name of your form).<\/li>\n
  5. 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\"). <\/li>\n
  6. Install this plugin.<\/li>\n
  7. Go to Settings > NS Sheets to configure the plugin and click the link to generate a Google Code to paste in the Google Access Code box. <\/li>\n
  8. Copy \/ paste the name of your spreadsheet and worksheet into the Google Sheet Name setting.<\/li>\n
  9. Add the spreadsheet tab name and ID of the form you want to use in the settings.<\/li>\n
  10. Save your settings.<\/li>\n
  11. Test your form submit and verify that the data shows up in your Google Sheet.<\/li>\n
  12. Have a beer and celebrate! <\/li>\n<\/ol>\n\n

    Important Notes<\/h4>\n\n
      \n
    • 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.<\/li>\n
    • Feedback is really important to us. Let us know if there are other creative ways you want to use this. <\/li>\n<\/ul>\n\n

      Enjoy!<\/p>\n\n\n

        \n
      1. Log in to your WordPress site as an administrator<\/li>\n
      2. Use the built-in Plugins tools to install from the repository or unzip and Upload the plugin directory to \/wp-content\/plugins\/ <\/li>\n
      3. Activate the plugin through the 'Plugins' menu in WordPress<\/li>\n
      4. The current output of the plugin teamplate can be seen by going to Settings > NS Plugin Template<\/li>\n<\/ol>\n\n\n
        \n
        Is this plugin supported?<\/dt>\n

        We'll try to answer any questions that come up in the support forum here on WP.org, but can't promise support.<\/p><\/dd>\n

        Why isn't the data sending? CF7 Submit is just Spinning.<\/dt>\n

        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:<\/p>\n\n

          \n
        1. Wrong username \/ password for google account (not likely - I'm sure you thought of this and made sure, but just thought I'd mention)<\/li>\n
        2. Wrong Sheet filename or tab name<\/li>\n
        3. Wrong Column name mapping<\/li>\n
        4. You might have to tweak your security settings in your google account here: https:\/\/security.google.com\/settings\/security\/secureaccount?pli=1 (This plugin uses an older Google API which requires the setting for allowing less secure apps to be Enabled)<\/li>\n<\/ol>\n\n

          Please double-check those things and hopefully one of them is the cause.<\/p><\/dd>\n\n<\/dl>\n\n\n

          1.2.6<\/h4>\n\n
            \n
          • Fixed bugs in plugin settings<\/li>\n<\/ul>\n\n

            1.2.5<\/h4>\n\n
              \n
            • Updated email subscription form service in sidebar<\/li>\n<\/ul>\n\n

              1.2.4<\/h4>\n\n
                \n
              • Fixed issue with updating the Google Authentication<\/li>\n<\/ul>\n\n

                1.2.2<\/h4>\n\n
                  \n
                • Improved conflict checking for other plugins that also use the Google API <\/li>\n<\/ul>\n\n

                  1.2.1<\/h4>\n\n
                    \n
                  • Added token to database for better handling<\/li>\n<\/ul>\n\n

                    1.2.0<\/h4>\n\n
                      \n
                    • Completely rewrote plugin and token functions for better compatibility<\/li>\n<\/ul>\n\n

                      1.1.0<\/h4>\n\n
                        \n
                      • Completely rewrote Google authentication mechanism to use OATH and get get off deprecated Google APIs<\/li>\n<\/ul>\n\n

                        1.0.3<\/h4>\n\n
                          \n
                        • Added Pro Version Notification<\/li>\n<\/ul>\n\n

                          1.0.2<\/h4>\n\n
                            \n
                          • Added additional error handling to fix some google connection issues with custom domains<\/li>\n<\/ul>\n\n

                            1.0.1<\/h4>\n\n
                              \n
                            • Added support for CF7 checkbox fields<\/li>\n<\/ul>\n\n

                              1.0.0<\/h4>\n\n
                                \n
                              • First public release<\/li>\n<\/ul>","raw_excerpt":"This is a painless way to integrate and automatically send WordPress data to Google Sheets.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/32040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=32040"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/neversettle"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=32040"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=32040"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=32040"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=32040"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=32040"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=32040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}