Alex Agranov

What version of WordPress and Contact Form 7 are you using?

I’ve tested this right now on WordPress 6.6 with Contact Form 7 5.9.7 – and all works as expected.

I also tested it on WordPress 5.10 with Contact Form 7 5.6.4 (the last release that supports WordPress 5.x) – and it works there fine as well.

can you please check your WordPress log file for errors? and the debug link in Settings page?

I wrote this plugin for myself – specifically for the site of non-profit organization that I maintain. We use WordPress forms to collect information from presenters for an annual 3-day conference – and existing plugins didn’t work reliably for us (missed some submissions) – so I decided I better write my own code for this crucial part.

If / when the credential expire / get invalidated – you simply generate new ones and update the plugin with them.

Due to Caldera Forms being shutdown/retired the work on this plugin has been seized. I’ve personally switched to Contact Form 7 – see https://wordpress.com/plugins/cf-google-sheets for details.

Since you get “Connection refused” error looks like you either don’t have outbound routing configured on your server or some firewall / network security group is blocking the connection to Google API.

Just create .htaccess file in this directory with the following content:
deny from all

• This reply was modified 4 years, 1 month ago by Alex Agranov.

Sorry – no idea – I’m not using woocommerce plugin.

Did you follow the video instructions?

Can you please post the full error here?

Sure. PM me the details.

Can you please check wordpress logs for any errors / warnings? The plugin only works on the backend (triggered by the submit callback) so it’s hard to imagine how it can cause slowness on the frontend.

Are you using Sheet on some Google Apps organization account?
Try to google “sheets api the caller does not have permission”.
For example, it finds this: https://www.roelpeters.be/solved-the-caller-does-not-have-permission-using-the-api-with-a-private-google-spreadsheet/

@zpiritespen that’s a different story – you get “permission denied” error from Sheets API – which means that access key that your plugin is using is not valid.
Try to activate the plugin again. And make sure that:
1) you include ../auth/spreadsheets scope when you create credentials
2) you’re using the same Google account where sheet is located during the activation (in case you have multiple Google accounts)

• This reply was modified 4 years, 4 months ago by Alex Agranov.

Are you sure about 7.79 version?
Because the last official version released by curl project is 7.73.0:
https://curl.haxx.se/download.html

And according to some forums – e.g. https://www.ads-software.com/support/topic/curl-error-2-easy-handle-already-used-in-multi-handle/page/3/ – 7.79 is a compromised version that was deployed by some hosters (e.g. GoDaddy) due to some hacking on their servers.

Interesting. I’ll update GuzzleHttp library version in next maintenance release – hopefully this will resolve the issue.