{"id":52785,"date":"2016-12-12T08:29:45","date_gmt":"2016-12-12T08:29:45","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/extension-for-contact-form-7-and-googlesheet\/"},"modified":"2016-12-20T19:09:34","modified_gmt":"2016-12-20T19:09:34","slug":"extension-for-contact-form-7-and-googlesheet","status":"publish","type":"plugin","link":"https:\/\/pl.wordpress.org\/plugins\/extension-for-contact-form-7-and-googlesheet\/","author":14017589,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.0","stable_tag":"trunk","tested":"4.5.33","requires":"4.0.1","requires_php":"","requires_plugins":"","header_name":"Contact Form 7 googlesheet extesion.","header_author":"Pardeep Nadha","header_description":"","assets_banners_color":"c8c8c8","last_updated":"2016-12-20 19:09:34","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/pardeepnadha.wordpress.com\/","header_author_uri":"https:\/\/pardeepnadha.wordpress.com\/","rating":0,"author_block_rating":0,"active_installs":10,"downloads":1874,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":[],"ratings":{"1":0,"2":0,"3":0,"4":0,"5":0},"assets_icons":[],"assets_banners":{"banner-772x250.jpg":{"filename":"banner-772x250.jpg","revision":"1560897","resolution":"772x250","location":"assets","width":772,"height":250}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1559976","resolution":"1","location":"assets","width":1920,"height":981},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"1559976","resolution":"2","location":"assets","width":1920,"height":981},"screenshot-3.png":{"filename":"screenshot-3.png","revision":"1559976","resolution":"3","location":"assets","width":1920,"height":981},"screenshot-4.png":{"filename":"screenshot-4.png","revision":"1559976","resolution":"4","location":"assets","width":1920,"height":981},"screenshot-5.png":{"filename":"screenshot-5.png","revision":"1559976","resolution":"5","location":"assets","width":1920,"height":981},"screenshot-6.png":{"filename":"screenshot-6.png","revision":"1559976","resolution":"6","location":"assets","width":1920,"height":981},"screenshot-7.png":{"filename":"screenshot-7.png","revision":"1559976","resolution":"7","location":"assets","width":1920,"height":981},"screenshot-8.png":{"filename":"screenshot-8.png","revision":"1559976","resolution":"8","location":"assets","width":1920,"height":981}},"screenshots":{"1":"

Open this link in browser https:\/\/console.developers.google.com\/ and if you are not login with gmail id then login and click on link \"credientials\" then and then create google client email.<\/p>","2":"

In the credential link create google client ID.<\/p>","3":"

In the credential link you will see your google client id end with \"apps.googleusercontent.com\".<\/p>","4":"

Click on manage service accounts to get google client ID and key file.<\/p>","5":"

You will see your google client email end with \"@developer.gserviceaccount.com\".<\/p>","6":"

Click on \"create key\" link to generate keyfile.<\/p>","7":"

After Click on \"create key\" a popup will open the select \"p12\" option and submit create button it will automatically download keyfile to your pc.<\/p>","8":"

Fill the all details in configuration form and please share your google spreedsheet with client email.<\/p>"}},"plugin_section":[],"plugin_tags":[1152,150,127965,597,43667],"plugin_category":[],"plugin_contributors":[127966],"plugin_business_model":[],"class_list":["post-52785","plugin","type-plugin","status-publish","hentry","plugin_tags-contact-form-7","plugin_tags-google","plugin_tags-google-sheet","plugin_tags-integration","plugin_tags-sheet","plugin_contributors-pardeep-nadha","plugin_committers-pardeep-nadha"],"banners":{"banner":"https:\/\/ps.w.org\/extension-for-contact-form-7-and-googlesheet\/assets\/banner-772x250.jpg?rev=1560897","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/extension-for-contact-form-7-and-googlesheet_c8c8c8.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/extension-for-contact-form-7-and-googlesheet\/assets\/screenshot-1.png?rev=1559976","caption":"

Open this link in browser https:\/\/console.developers.google.com\/ and if you are not login with gmail id then login and click on link \"credientials\" then and then create google client email.<\/p>"},{"src":"https:\/\/ps.w.org\/extension-for-contact-form-7-and-googlesheet\/assets\/screenshot-2.png?rev=1559976","caption":"

In the credential link create google client ID.<\/p>"},{"src":"https:\/\/ps.w.org\/extension-for-contact-form-7-and-googlesheet\/assets\/screenshot-3.png?rev=1559976","caption":"

In the credential link you will see your google client id end with \"apps.googleusercontent.com\".<\/p>"},{"src":"https:\/\/ps.w.org\/extension-for-contact-form-7-and-googlesheet\/assets\/screenshot-4.png?rev=1559976","caption":"

Click on manage service accounts to get google client ID and key file.<\/p>"},{"src":"https:\/\/ps.w.org\/extension-for-contact-form-7-and-googlesheet\/assets\/screenshot-5.png?rev=1559976","caption":"

You will see your google client email end with \"@developer.gserviceaccount.com\".<\/p>"},{"src":"https:\/\/ps.w.org\/extension-for-contact-form-7-and-googlesheet\/assets\/screenshot-6.png?rev=1559976","caption":"

Click on \"create key\" link to generate keyfile.<\/p>"},{"src":"https:\/\/ps.w.org\/extension-for-contact-form-7-and-googlesheet\/assets\/screenshot-7.png?rev=1559976","caption":"

After Click on \"create key\" a popup will open the select \"p12\" option and submit create button it will automatically download keyfile to your pc.<\/p>"},{"src":"https:\/\/ps.w.org\/extension-for-contact-form-7-and-googlesheet\/assets\/screenshot-8.png?rev=1559976","caption":"

Fill the all details in configuration form and please share your google spreedsheet with client email.<\/p>"}],"raw_content":"\n

This plugin is use to upload contact form 7 to the google sheet.<\/p>\n\n

Follow the below to use this plugin:-<\/p>\n\n

    \n
  1. Install the Contact Form 7 plugin if you haven't already. <\/li>\n
  2. Create the CF7 Form that you want to use to save data on googlesheet. You will need the ID.<\/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 else you want.<\/li>\n
  5. Install this plugin.<\/li>\n
  6. Go to Contact > GoogleSheet Integration to configure the plugin.<\/li>\n
  7. Add the Contact Form 7 ID, Google Client App Name, Google Client ID, Google Client Email, Google Sheet Name, Google Sheet Tab Name in the settings form.<\/li>\n
  8. Save your settings.<\/li>\n
  9. Test your contact form with submit form and verify that the data shows up in your Google Sheet.<\/li>\n<\/ol>\n\n\n

    Method 1:\nDownload the zipped plugin file to your local machine by this link: \nGo to WordPress admin -> Plugins menu\nAdd New->Upload->browse the zipped plugin\nUpload and Activate the plugin.<\/p>\n\n

    Method 2:\n1. Unzipped the download plugin and upload the plugin files to the \/wp-content\/plugins\/<\/code> directory, or install the plugin through the WordPress plugins screen directly.\n1. Activate the plugin through the 'Plugins' screen in WordPress\n1. Use the Contact->GoogleSheet Integration screen to configure the plugin<\/p>\n\n\n

    \n
    What about support?<\/dt>\n

    Create a support ticket at WordPress forum and I will take care of any issue.<\/p><\/dd>\n\n<\/dl>\n\n\n

    1.0<\/h4>\n\n
      \n
    • First version<\/li>\n<\/ul>","raw_excerpt":"Upload data to Google Sheets using Contact Form 7","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/52785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=52785"}],"author":[{"embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/pardeep-nadha"}],"wp:attachment":[{"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=52785"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=52785"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=52785"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=52785"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=52785"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/pl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=52785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}