Alex Agranov

<p>This plugin provides integration between <a href="https://wordpress.org/plugins/contact-form-7/" rel="ugc">Contact Form 7</a> and <a href="https://www.google.com/sheets/" rel="nofollow ugc">Google Sheets</a>.<br />
It adds new processor to Contact Form 7 that enables sending of submitted forms to Google Sheets.</p>
<h4>Connecting the Plugin to Google Sheets</h4>
<p>After installing the plugin you must go to it’s <strong>Settings</strong> screen and create application credentials needed to establish connection with Google Sheets. All instructions are provided in the <strong>Settings</strong> screen.</p>
<p>After successfully creating application credentials and uploading them (i.e. completing steps 1 and 2), you will see <em>Client ID</em> and <em>Client Email</em> that represent your instance of “Google Sheets for Contact Form 7” plugin. You will need to share your sheets with <em>Client Email</em> (as <em>Editor</em> role) to grant “Google Sheets for Contact Form 7” plugin permissions to edit them.</p>
<h4>Using the Plugin</h4>
<p>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.</p>
<p><em>In Google Sheets</em></p>
<ul>
<li>Create a new Google Sheet</li>
<li>Switch to the tab where you want to capture the data</li>
<li>
<p>Determine <em>Sheet ID</em> and <em>Tab ID</em> from the sheet’s URL that looks as follows: https://docs.google.com/spreadsheets/d/<em>sheet-id</em>/edit#gid=<em>tab-id</em></p>
<p>For example, for URL https://docs.google.com/spreadsheets/d/142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64/edit#gid=0 <em>Sheet ID</em> is “142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64” and <em>Tab ID</em> is “0”</p>
</li>
<li>
<p>Enter “datetime” in the the first column if you want to capture time and date of submission</p>
</li>
<li>There is no need to enter names for other columns – they will be automatically added upon form submission</li>
<li>Share the sheet with <em>Client Email</em> that represents your instance of “Google Sheets for Contact Form 7” plugin – as <em>Editor</em> role</li>
</ul>
<p><em>In Contact Form 7</em></p>
<ul>
<li>Open your contact form</li>
<li>Switch to <strong>Google Sheets</strong> tab</li>
<li>Configure <em>Sheet ID</em> and <em>Tab ID</em> and click <em>Save</em></li>
<li>Submit a test form and verify that the data shows up in your Google Sheet</li>
</ul>
<h4>Automatic Header Generation</h4>
<p>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.</p>
<h4>Capturing Submission Metadata</h4>
<p>In addition to the <em>datetime</em> and regular form fields, you may also capture Contact Form 7 <a href="https://contactform7.com/special-mail-tags" rel="nofollow ugc">special mail-tags</a>. In order to do so, add <em>manually</em> corresponding headers to your spreadsheet. Remove square brackets and first underscore from the tag name, and replace remaining underscores with dashes. For example, add <em>remote-ip</em> header to capture <em>[_remote_ip]</em> mail-tag.</p>
<h4>Integration with “Contact Form 7 Database Addon – CFDB7”</h4>
<p>If you use <a href="https://wordpress.org/plugins/contact-form-cfdb7/" rel="ugc">Contact Form 7 Database Addon – CFDB7</a> 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 <em>Send to Google Sheets</em> button.</p>
<h4>Acknowledgements</h4>
<p>Initial version of this plugin was inspired by <a href="https://wordpress.org/plugins/cf7-google-sheets-connector/" rel="ugc">CF7 Google Sheets Connector</a> plugin.</p>
<p>However it’s implementation is quite different:</p>
<ul>
<li>it uses service principle for authentication with Google Sheets</li>
<li>it has completely different and much more reliable sheets update logic</li>
<li>it implements automatic header generation, to ensure that no submission data is lost</li>
<li>it supports capturing submission meta-data</li>
<li>it provides integration with CFDB7 plugin for forms re-submission</li>
</ul>


Integration with Google Sheets for Contact Form 7

Send your Contact Forms 7 submissions directly to your Google Sheets spreadsheet.

raoinfotech

<p>Get real time POST, CPT, Woocommerce Order along with meta fields mapping on sheets, easy mapping and configuration with each column and Post Column.</p>
<p>This plugin uses <a href="https://sheets.googleapis.com/v4/spreadsheets/" rel="nofollow ugc">Google Sheets API</a> and <a href="https://www.googleapis.com/drive/v3/files" rel="nofollow ugc">Google Drive API</a> to sync<br />
wordpress data with google sheets.<br />
<a href="https://oauth2.googleapis.com/token" rel="nofollow ugc">Google Oauth</a> for generating the token for authorizing Google API’s.</p>
<h3>Configuration</h3>
<ol>
<li>Visit <a href="https://console.cloud.google.com/" rel="nofollow ugc">Google Cloud</a></li>
<li>Create New Project</li>
<li>Enable Google Sheets API & Google Drive API from API & Services Library</li>
<li>Create Credentials for Service Account</li>
<li>Save JSON object Credentials under plugin settings page</li>
<li>Share Service accouts email on Google sheets with edit access</li>
<li>Create first Sheetlink Integration</li>
</ol>
<h3>Creating Integration</h3>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/qbxnyyoab48?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<h3>Available Filter Hooks</h3>
<p>GSheets Connector is developer friendly and has some filters available to add the custom fields</p>
<ol>
<li>
<p>Add additional data options while creating integrations</p>
<pre><code>apply_filters( 'rgsi_data_options', $data );

add_filter( 'rgsi_data_options', function($data) {
    //Need to add prefix _custom_ in order to feed the custom data in rgsi_mapped_data hook
    $data['_custom_company_id'] = "Company ID"
    return $data;
});
</code></pre>
</li>
<li>
<p>Filter Output data before being sent to sheet</p>
<pre><code>apply_filters( 'rgsi_mapped_data',$parsed_data, $post,$custom_keys );

add_filter( 'rgsi_mapped_data', function( $parsed_data, $post, $custom_keys ){ 
    return $parsed_data;
});
</code></pre>
</li>
</ol>
<h3>Data Privacy</h3>
<p>The Application obtains the following information when you use the built-in app for authentication and link the Application with your Google Drive Account:<br />
1. Your WordPress website address.<br />
2. A short-lived access token gets generated by the OAuth flow.<br />
3. Service account Credentials in JSON format are encrypted and saved into the database. This credential is used for fetching and validating the access token.<br />
4. Access token is validated using <a href="https://www.googleapis.com/oauth2/v1/tokeninfo" rel="nofollow ugc">GoogleApis Token Info</a> endpoint<br />
5. A short lived access token is retrieved using endpoint <a href="https://oauth2.googleapis.com/token" rel="nofollow ugc">Googleapis Oauth2</a> by sending JWT encoded Private key and client_email<br />
6. Retrieved access token is used to accesss list of spreadsheets with the help of <a href="https://www.googleapis.com/drive/v3/files" rel="nofollow ugc">Google Drive API</a> and <a href="https://sheets.googleapis.com/v4/spreadsheets/" rel="nofollow ugc">Google Spreadsheets API</a> that has been shared with client email <a href="https://www.googleapis.com/drive/v3/files" rel="nofollow ugc">Google Drive</a> and update spreadsheet data with the help of <a href="https://sheets.googleapis.com/v4/spreadsheets/" rel="nofollow ugc">Spreadsheers API</a></p>
<p><strong>IMPORTANT:</strong> When you use the Application, all other communications are strictly between your server and the cloud storage service servers. The communication is encrypted and the communication will not go through our servers. We do not collect and do not have access to your files.<br />
Read more : <a href="https://raoinformationtechnology.com/privacy-policy/" rel="nofollow ugc">RaoInformation Technology Privacy Policy</a></p>
<h3>Privacy Policy</h3>
<p>GSheets Connector uses <a href="https://appsero.com" rel="nofollow ugc">Appsero</a> SDK to collect some telemetry data upon user’s confirmation. This helps us to troubleshoot problems faster & make product improvements.</p>
<p>Appsero SDK <strong>does not gather any data by default.</strong> The SDK only starts gathering basic telemetry data <strong>when a user allows it via the admin notice</strong>. We collect the data to ensure a great user experience for all our users.</p>
<p>Integrating Appsero SDK <strong>DOES NOT IMMEDIATELY</strong> start gathering data, <strong>without confirmation from users in any case.</strong></p>
<p>Learn more about how <a href="https://appsero.com/privacy-policy/" rel="nofollow ugc">Appsero collects and uses this data</a>.</p>
<h3>v1.0.0</h3>
<p>= Initial Version</p>
<h3>v1.1.0</h3>
<p>= Fix Create Type Integration adding multiple times</p>
<h4>Added registeration date support for user type</h4>
<p>Add custom filter hooks to support custom fields</p>
<h3>v1.1.0</h3>
<p>= Fix Feedbackform Url<br />
= Integrate AppSero Analytics</p>


GSheets Connector

Sync your WordPress posts, custom post types, and WooCommerce orders, including custom fields, to Google Spreadsheets using available filter hooks.

Integration with Google Sheets for Contact Form 7 vs GSheets Connector