Title: Integration with Google Sheets for Contact Form 7 Author: Alex Agranov Published: 2024.01.16. Last modified: 2024.01.16. --- Bővítmények keresése ![](https://ps.w.org/cf7-google-sheets/assets/banner-772x250.png?rev=3022217) Ez a bővítmény **nem lett tesztelve a WordPress legutóbbi 3 fő kiadásával**. Lehetséges, hogy már nincs karbantartva, frissítve és a használata gondot jelenthet a frissebb WordPress verziókkal. ![](https://ps.w.org/cf7-google-sheets/assets/icon-128x128.png?rev=3022217) # Integration with Google Sheets for Contact Form 7 Szerző: [Alex Agranov](https://profiles.wordpress.org/alexagr/) [Letöltés](https://downloads.wordpress.org/plugin/cf7-google-sheets.zip) * [Részletek](https://hu.wordpress.org/plugins/cf7-google-sheets/#description) * [Vélemények](https://hu.wordpress.org/plugins/cf7-google-sheets/#reviews) * [Telepítés](https://hu.wordpress.org/plugins/cf7-google-sheets/#installation) * [Fejlesztés](https://hu.wordpress.org/plugins/cf7-google-sheets/#developers) [Támogatás](https://wordpress.org/support/plugin/cf7-google-sheets/) ## Leírás 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 ## Képernyőmentések * [[ * Connecting plugin to Google Sheets * [[ * Configuring Google Sheets processor in Contact Form 7 * [[ * Integration with „Contact Form 7 Database Addon – CFDB7” plugin ## Telepítés 1. Upload „cf7-google-sheets” to the „/wp-content/plugins/” directory 2. Activate the plugin through the **Plugins** screen in WordPress ## GYIK ### 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 ## Vélemények ![](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/) 2025.06.19. 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/) 2025.01.09. 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/) 2024.03.13. 1 reply 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 (az összes) vélemény olvasása ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/) ## Közreműködők és fejlesztők “Integration with Google Sheets for Contact Form 7” egy nyílt forráskódú szoftver. A bővítményhez a következő személyek járultak hozzá: Közreműködők * [ Alex Agranov ](https://profiles.wordpress.org/alexagr/) [“Integration with Google Sheets for Contact Form 7” fordítása a saját nyelvünkre.](https://translate.wordpress.org/projects/wp-plugins/cf7-google-sheets) ### Érdekeltek vagyunk a fejlesztésben? [Browse the code](https://plugins.trac.wordpress.org/browser/cf7-google-sheets/), check out the [SVN repository](https://plugins.svn.wordpress.org/cf7-google-sheets/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/cf7-google-sheets/) by [RSS](https://plugins.trac.wordpress.org/log/cf7-google-sheets/?limit=100&mode=stop_on_copy&format=rss). ## Változási napló #### 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 ## Meta * Version **1.3** * Last updated **2 év ezelőtt** * Active installations **300+** * WordPress version ** 3.6 vagy magasabb ** * Tested up to **6.4.8** * Language * [English (US)](https://wordpress.org/plugins/cf7-google-sheets/) * Tags * [contact form 7](https://hu.wordpress.org/plugins/tags/contact-form-7/)[google](https://hu.wordpress.org/plugins/tags/google/) [Google Sheets](https://hu.wordpress.org/plugins/tags/google-sheets/)[sheets](https://hu.wordpress.org/plugins/tags/sheets/) * [Bővített nézet](https://hu.wordpress.org/plugins/cf7-google-sheets/advanced/) ## Vélemények 3.7 out of 5 stars. * [ 2 5-star reviews ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=2) * [ 1 1-star review ](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/cf7-google-sheets/reviews/) ## Közreműködők * [ Alex Agranov ](https://profiles.wordpress.org/alexagr/) ## Támogatás Vélemény? Segítségkérés? [Támogatói fórum megtekintése](https://wordpress.org/support/plugin/cf7-google-sheets/) ## Adomány Szeretnénk támogatni ennek a bővítménynek a fejlődését? [ Ha tehetjük, támogassuk ezt a bővítményt ](https://paypal.me/alexagr)