Slow form submission when CF7 google sheet connector enabled

Hello Armand,
Glad to hear from you that you troubleshoot in different ways.

Did not face such issues for slow down in submitting the form.
I would like to know 2 things.
1. Which PHP version is used on site?
2. Are you using any SMTP for sending emails?
May be there would be a minor conflict with other plugins you are using.

If you can provide me more details of site with its credentials on email: [email protected] we would like to troubleshoot and identify the issue more for better idea.

Feel free to let me know further.

Thanks
Abdullah.

Hi . I have a sample issue !
I using PHP 7 and plugin WP Mail SMTP to sent Email .
is there any fix we can apply?

Hi,

Just circling back here in case the information is useful to anyone else.
In our case, Google sheet connector was actually not the main culprit of the slow contact form submission.

Google sheet connector does add some time to the submission, approximately 1-3 seconds because it calls the Google Apis.

But it is another plugin that was adding a significant amount of time to the submission: Flamingo. Flamingo is a plugin to save contact form 7 submissions to the database.
At the time of the issue at least, this plugin had 2 problems.
– Performing inefficient checks, going through all posts of the website while submitting a form.
– Saving spam attempts to the database, even though they were blocked by the new Recaptcha v3.

To solve the issue we had to remove all spam messages from the database (sometimes tens of thousands), and amend the code of flamingo a little to prevent it from saving rejected submissions to the database.
We also cleaned posts by removing old revisions and orphaned meta, to make the database leaner, considering flammingo is doing some inefficient checks.

Links:
– Inefficient checks report: https://www.ads-software.com/support/topic/extremely-slow-logging-in-inbound-message-save/
– Prevent flamingo from saving rejected submissions: https://www.ads-software.com/support/topic/disabled-javascript-submission-with-recaptcha/

Hopefully, this will help someone.
Armand.

I have same issue, but I am not use Flamingo.

Just Elementor 5.2.2 + Contact form 7 + GoogleSheet connect.
The visitors tend to click several times, thinking nothing happens and I receive many record to the sheet.

Any idea?

Thanks.

Jiri

Hello @jurry09
Sorry for the trouble,

We have troubleshoot with few points, and had updated google library to sort out this issue and it may works fine as per our last test.
Still we are testing and expecting to release new version in next week.
You will see update shortly.

We have updated the library in PRO version and seems to be working perfectly.
If you have urgently required then you can upgrade to PRO, otherwise we are expecting to update in next week for sure to sort out this issue specially.

Thanks
Abdullah

Hi Adbullah,

We’re having this exact same problem on our site. Has the update with the fix been released yet?

Our users are typically clicking submit several times as there is a 5 second delay and that is enough to make them keep clicking. As a result we get several submissions in our google sheet per user and that leads to manual work of deleting, plus the user experience is not great.

The form submits quickly when Google Sheets Connector is deactivated but slowly when it is active. We have the PRO version too.

Thanks for your efforts in fixing this bug. Much appreciated!

Chris

Hello we have the same problem…

9 seconds to confirm the form is sent.

When I delete the name of the sheets, the form is sent in 0,7 seconds.

For sure the problem is this extension…

I can’t continue to lose contacts…
Please do you have a solution ?

Thanks

Hello @kzou13 @chriswordpress3000
The issue has already been resolved in the latest version.
Can you update the plugin and let me know if still, issues are there.

Alternatively, If your form is too large with too many fields, then obviously it will take a bit of time.
Secondly, If you are using some other addon related to google sheet, then you have to enable debug log from wp-config.php and check what makes conflicts.

Thanks
Abdullah

Thanks for your reply.

I use the last version (3.0).
WP 5.3.2
PHP 7.3

I save only 5 fields on the sheet.

I tried on new page with new form… without Google Sheet connector 0,7sec, when enabled 9sec.

Extensions CF7 : Contact Form 7 Conditional Fields & Contact Form CFDB7

It’s the same without it.

Debug log seems don’t work on my website. May you help me please ????

I am having the same issue on my site after enabling the Google Sheet connector, the form is taking too much time in submission and not further entries in the sheet.

Is there any update ? Tks all
The form take 10s to finish. I thought that it should be asycn all the task: send email, and send data to sheet. no need to wait until once of them to be completed