Title: Integration with Google Sheets for Contact Form 7 Author: Alex Agranov Published: जानेवारी 16, 2024 Last modified: जानेवारी 16, 2024 --- प्लगइन शोधा ![](https://ps.w.org/cf7-google-sheets/assets/banner-772x250.png?rev=3022217) हे प्लगइन **WordPress च्या शेवटच्या 3 महत्त्वाच्या प्रमुख पुनर्वितरणांच्या साथी चाचणी झालेले नाही**. हे येथे वापरल्यास सामर्थ्य देणार नाही किंवा त्या आधारित असु शकते आणि WordPress च्या अधिक अद्ययावत आवृत्तींसह वापरताना संगतता समस्यांची शक्यता आहे. ![](https://ps.w.org/cf7-google-sheets/assets/icon-128x128.png?rev=3022217) # Integration with Google Sheets for Contact Form 7 [Alex Agranov](https://profiles.wordpress.org/alexagr/) कडून [डाउनलोड करा](https://downloads.wordpress.org/plugin/cf7-google-sheets.zip) * [तपशील](https://mr.wordpress.org/plugins/cf7-google-sheets/#description) * [पुनरावलोकने](https://mr.wordpress.org/plugins/cf7-google-sheets/#reviews) * [इंस्टॉलेशन](https://mr.wordpress.org/plugins/cf7-google-sheets/#installation) * [डेव्हलोपमेंट](https://mr.wordpress.org/plugins/cf7-google-sheets/#developers) [समर्थन](https://wordpress.org/support/plugin/cf7-google-sheets/) ## वर्णन This plugin provides integration between [Contact Form 7](https://wordpress.org/plugins/contact-form-7/) and [Google Sheets](https://www.google.com/sheets/). It adds new processor to Contact Form 7 that enables sending of submitted forms to Google Sheets. #### Connecting the Plugin to Google Sheets After installing the plugin you must go to it’s **Settings** screen and create application credentials needed to establish connection with Google Sheets. All instructions are provided in the **Settings** screen. After successfully creating application credentials and uploading them (i.e. completing steps 1 and 2), you will see _Client ID_ and _Client Email_ that represent your instance of “Google Sheets for Contact Form 7” plugin. You will need to share your sheets with _Client Email_ (as _Editor_ role) to grant “Google Sheets for Contact Form 7” plugin permissions to edit them. #### Using the Plugin After successfully connecting the plugin to Google Sheets, do the following to configure your Contact Form 7 to send data to Google Sheets on form submission. _In Google Sheets_ * Create a new Google Sheet * Switch to the tab where you want to capture the data * Determine _Sheet ID_ and _Tab ID_ from the sheet’s URL that looks as follows: https://docs.google.com/spreadsheets/d/_sheet-id_/edit#gid=_tab-id_ * For example, for URL https://docs.google.com/spreadsheets/d/142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64/ edit#gid=0 _Sheet ID_ is “142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64” and _Tab ID_ is “0” * Enter “datetime” in the the first column if you want to capture time and date of submission * There is no need to enter names for other columns – they will be automatically added upon form submission * Share the sheet with _Client Email_ that represents your instance of “Google Sheets for Contact Form 7” plugin – as _Editor_ role _In Contact Form 7_ * Open your contact form * Switch to **Google Sheets** tab * Configure _Sheet ID_ and _Tab ID_ and click _Save_ * Submit a test form and verify that the data shows up in your Google Sheet #### Automatic Header Generation The plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed. Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually. You may also manually reorder columns as you wish. #### Capturing Submission Metadata In addition to the _datetime_ and regular form fields, you may also capture Contact Form 7 [special mail-tags](https://contactform7.com/special-mail-tags). In order to do so, add _manually_ corresponding headers to your spreadsheet. Remove square brackets and first underscore from the tag name, and replace remaining underscores with dashes. For example, add _remote-ip_ header to capture _[\_remote\_ip]_ mail- tag. #### Integration with “Contact Form 7 Database Addon – CFDB7” If you use [Contact Form 7 Database Addon – CFDB7](https://wordpress.org/plugins/contact-form-cfdb7/) to save your submissions, you will also be able to resend already submitted forms to Google Sheets. This may be useful if something went wrong during initial form submission and/or someone deleted data in Google Sheets by mistake. In order to do so, in CFDB7 plugin, choose your form, open specific submission and click _Send to Google Sheets_ button. #### Acknowledgements Initial version of this plugin was inspired by [CF7 Google Sheets Connector](https://wordpress.org/plugins/cf7-google-sheets-connector/) plugin. However it’s implementation is quite different: * it uses service principle for authentication with Google Sheets * it has completely different and much more reliable sheets update logic * it implements automatic header generation, to ensure that no submission data is lost * it supports capturing submission meta-data * it provides integration with CFDB7 plugin for forms re-submission ## स्क्रीनशॉट [⌊Connecting plugin to Google Sheets⌉⌊Connecting plugin to Google Sheets⌉[ Connecting plugin to Google Sheets [⌊Configuring Google Sheets processor in Contact Form 7⌉⌊Configuring Google Sheets processor in Contact Form 7⌉[ Configuring Google Sheets processor in Contact Form 7 [⌊Integration with "Contact Form 7 Database Addon - CFDB7" plugin⌉⌊Integration with" Contact Form 7 Database Addon - CFDB7" plugin⌉[ Integration with “Contact Form 7 Database Addon – CFDB7” plugin ## स्थापना 1. Upload “cf7-google-sheets” to the “/wp-content/plugins/” directory 2. Activate the plugin through the **Plugins** screen in WordPress ## नेहमी विचारले जाणारे प्रश्न ### Why isn’t the data sent to spreadsheet? Contact Form 7 Submit is just Spinning. Sometimes it can take a while of spinning before it goes through. But if the entries never show up in your Google Sheet use the following checklist: * Check that plugin can access your sheet by entering it’s _Sheet ID_ in **Settings** screen and clicking _Test_ * In Google Sheets processor configuration screen for your form: - Check that you entered correct _Sheet ID_ and _Tab ID_ (obtained from the sheet’s URL – and NOT the Sheet/Tab Name) * Check _View Log_ in plugin **Settings** screen for detailed error trace ## समीक्षा ![](https://secure.gravatar.com/avatar/45c6516ea01fce9286d6eab690106be1dc4c93a7f9152e2af320b076d7a9189a? s=60&d=retro&r=g) ### 󠀁[Finally working google sheets connector](https://wordpress.org/support/topic/finally-working-google-sheets-connector/)󠁿 [s4d4m](https://profiles.wordpress.org/s4d4m/) जून 19, 2025 I had been long frustrated by the failure to log records with the CF7 Google Sheets Connector – but with this plugin, it finally seems like everything is working. Thanks! ![](https://secure.gravatar.com/avatar/a33bdd39af675102e72d187e2e50d5fce6a19ef3c5bc3464b3f97fc67922550f? s=60&d=retro&r=g) ### 󠀁[Very usefull plugin](https://wordpress.org/support/topic/very-usefull-plugin-170/)󠁿 [pavulon5](https://profiles.wordpress.org/pavulon5/) जानेवारी 9, 2025 It’s not easy to config but work well! And you don’t have missing data. Great job! ![](https://secure.gravatar.com/avatar/e9a70ef9ef167b0ec459be47b990e7b7f4b2cebc80137bd737e0d342db606651? s=60&d=retro&r=g) ### 󠀁[Doesn’t work](https://wordpress.org/support/topic/doesnt-work-3093/)󠁿 [hellothereuk](https://profiles.wordpress.org/hellothereuk/) मार्च 13, 2024 1 उत्तर Following setup/auth instructions but they dont work. “Step 2: upload credentials. json file” – nothing happens – the fields Client ID or Client email never populate with anything after adding the .json file, so unable to continue. [ सर्व 2 पुनरावलोकने वाचा ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/) ## योगदानकर्ते आणि विकसक “Integration with Google Sheets for Contact Form 7” हे मुक्त स्रोत सॉफ्टवेअर आहे. पुढील लोक या प्लगइनच्या निर्मितीत योगदान केले आहे. योगदानकर्ते * [ Alex Agranov ](https://profiles.wordpress.org/alexagr/) [भाषांतर करा “Integration with Google Sheets for Contact Form 7” तुमच्या भाषेत.](https://translate.wordpress.org/projects/wp-plugins/cf7-google-sheets) ### विकासातील आग्रह? [कोड ब्राउझ करा](https://plugins.trac.wordpress.org/browser/cf7-google-sheets/), [SVN संग्रहालय](https://plugins.svn.wordpress.org/cf7-google-sheets/) तपासा, किंवा [विकास लॉग](https://plugins.trac.wordpress.org/log/cf7-google-sheets/) च्या [RSS](https://plugins.trac.wordpress.org/log/cf7-google-sheets/?limit=100&mode=stop_on_copy&format=rss) द्वारे सदस्यता घ्या. ## बदलांची यादी #### 1.3 * Refactor and clean-up the code for publishing to wordpress.org #### 1.2 * Refactor credentials upload for compliance with “Plugin Check” - After upgrade, please re-upload credentials.json in Settings screen #### 1.1 * Add integration with “Contact Form 7 Database Addon – CFDB7” * Fix uploaded file name #### 1.0 * Initial version ## मेटा * आवृत्ती **1.3** * शेवटचा अद्यतन **2 वर्षे पूर्वी** * सक्रिय स्थापना **300+** * वर्डप्रेस आवृत्ती ** 3.6 किंवा मोठा ** * परीक्षित केले आहे **6.4.8** * भाषा * [English (US)](https://wordpress.org/plugins/cf7-google-sheets/) * टॅग्ज: * [contact form 7](https://mr.wordpress.org/plugins/tags/contact-form-7/)[google](https://mr.wordpress.org/plugins/tags/google/) [Google Sheets](https://mr.wordpress.org/plugins/tags/google-sheets/)[sheets](https://mr.wordpress.org/plugins/tags/sheets/) * [प्रगत दृश्य](https://mr.wordpress.org/plugins/cf7-google-sheets/advanced/) ## मूल्यांकन 3.7 पैकी ५ तारे. * [ 2 5-तारांकित परीक्षणे ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=5) * [ 0 4-तारांकित परीक्षणे ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=4) * [ 0 3-तारांकित परीक्षणे ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=3) * [ 0 2-तारांकित परीक्षणे ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=2) * [ 1 1-तारांकित पुनरावलोकन ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/#new-post) [सर्व पुनरावलोकने पहा](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/) ## योगदानकर्ते * [ Alex Agranov ](https://profiles.wordpress.org/alexagr/) ## समर्थन काहीतरी सांगायचं आहे का? मदतीची आवश्यकता आहे का? [समर्थन फोरम पहा](https://wordpress.org/support/plugin/cf7-google-sheets/) ## देणगी आपण हे प्लगइन पुरविण्यात समर्थन करू इच्छिता का? [ ह्या प्लगइनला देणगी द्या ](https://paypal.me/alexagr)