Contact Form DB
Google Live Data Solution is here (2 posts)

  1. micmicwang
    Posted 2 years ago #

    Finally, I found the solution to Google Live Data. All the error came from WordPress Login authentication.

    This is not the perfect solution, but it works.

    1. In http://wordpress.org/support/topic/wordpress-to-google-drive-spreadsheet-step-by-step , cardboardmonet says:

    On line 62
    var url = "http://my-domain.tld/wp-content/plugins/contact-form-7-to-database-extension/export.php?form=myform";

    I used the following one:

    var url = "http://my-domain.tld/wp-content/plugins/contact-form-7-to-database-extension/export.php?form=";
    url += formName;

    2. In http://wordpress.org/support/topic/cfdb-with-google-spreadsheet-error-500, azghanvi says:

    1) contact-form-7-to-database-extension/ExportToCsvUtf8.php: Added new If and commented old if.

    if($_REQUEST["secret"] != "redacted"){
    // Security Check
    if (!$this->isAuthorized()) {

    2) In Code.gs (script editor) added secret param.

    url += '%26'+encodeURI("secret=redacted");
    return UrlFetchApp.fetch(

    Do exactly as he says in step 1, but in step 2, use

    url += encodeURI("&secret=redacted");

    You may want to change the secret code to something complex.

    Also, an improved step one is here, this one will not influence the original export function:

    if($_REQUEST["secret"] != "redacted"){
    if (!$this->isAuthorized()) {

    Hope this helps.


  2. cardboardmonet
    Posted 1 year ago #

    I'm glad my post could help! At the moment I'm trying to get the new entries to appear at the bottom of the spreadsheet (opposed to the top). If you have any insight into how to get this to work, please let me know! I'll be playing around with it a bit.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Contact Form DB
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic