Google Live Data Solution is here

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 https://www.ads-software.com/support/topic/wordpress-to-google-drive-spreadsheet-step-by-step , cardboardmonet says:

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

I used the following one:

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

2. In https://www.ads-software.com/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”){
$this->assertSecurityErrorMessage();
return;
}
/*
// Security Check
if (!$this->isAuthorized()) {
$this->assertSecurityErrorMessage();
return;
}
*/

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()) {
$this->assertSecurityErrorMessage();
return;
}
}

Hope this helps.

https://www.ads-software.com/plugins/contact-form-7-to-database-extension/