CF7 Google Sheet Connector Version 4.0 Updates

This is not working. The CF entries are not being captured in the Google sheets even after reauthentication.

@avinashk30 You need edit your contact form in tab Sheets and add the Sheet Id
and the Tab Id.

@jhosman55 I did. Still not working. Only the date is being captured now.

• This reply was modified 4 years, 9 months ago by avinashk30.

Same here. I reauthenticated, added Sheet ID and Tab ID, but it’s not updating my sheets.

(Also, your nag box keeps reappearing despite clicking the “Yes, I have done.”)

Same problem.

I also followed the link and put in the code.
Not working.

Log file says
ERROR_MSG] => Auth, Invalid OAuth2 access token

Mine looks like it connects to the sheet after entering the URL and TAB ID
however the cells are all blank. It keeps inserting blank rows above the existing data.

Anyone else seeing this?

12 February 2020 15:46:03 PHP 7.3.13Array
(
[ERROR_MSG] => Auth, Invalid OAuth2 access token
[TRACE_STK] => #0 /home1/public_html/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(131): cf7gsc_googlesheet->auth()
#1 /home1/public_html/wp-includes/class-wp-hook.php(288): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
#2 /home1/public_html/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters(”, Array)
#3 /home1/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
#4 /home1/public_html/wp-content/plugins/contact-form-7/includes/submission.php(214): do_action(‘wpcf7_mail_sent’, Object(WPCF7_ContactForm))
#5 /home1/public_html/wp-content/plugins/contact-form-7/includes/submission.php(34): WPCF7_Submission->submit()
#6 /home1/public_html/wp-content/plugins/contact-form-7/includes/contact-form.php(740): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
#7 /home1/public_html/wp-content/plugins/contact-form-7/includes/rest-api.php(285): WPCF7_ContactForm->submit()
#8 /home1/public_html/wp-includes/rest-api/class-wp-rest-server.php(946): wpcf7_rest_create_feedback(Object(WP_REST_Request))
#9 /home1/public_html/wp-includes/rest-api/class-wp-rest-server.php(329): WP_REST_Server->dispatch(Object(WP_REST_Request))
#10 /home1/public_html/wp-includes/rest-api.php(305): WP_REST_Server->serve_request(‘/contact-form-7…’)
#11 /home1/public_html/wp-includes/class-wp-hook.php(288): rest_api_loaded(Object(WP))
#12 /home1/public_html/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters(”, Array)
#13 /home1/public_html/wp-includes/plugin.php(544): WP_Hook->do_action(Array)
#14 /home1/public_html/wp-includes/class-wp.php(387): do_action_ref_array(‘parse_request’, Array)
#15 /home1/public_html/wp-includes/class-wp.php(729): WP->parse_request(”)
#16 /home1/public_html/wp-includes/functions.php(1255): WP->main(”)
#17 /home1/public_html/wp-blog-header.php(16): wp()
#18 /home1/public_html/index.php(17): require(‘/home1…’)
#19 {main}

SOLUTION: I downloaded the same version number 4.0 and uploaded all the files to overwrite the 4.0 version I have, and now its working. Although the nag screen remains.

Hi Guys,

I also follow step by step after doing the update, and it’s still not working properly. Submissions are not coming into the sheet.

Please help or update the plugin to fix this issue asap. Thanks

Hi,
I followed as what has been instructed. The Data from the CF7 were transferred to the Spreadsheet.

HOWEVER, the only problem is it does not entered in the right COLUMN.
For every NEW Entry, it will be entered in a new gap COLUMN. As if it has some sort of “STEP SIZE” for every entry.

Please Fix this. Thank you.

This is not working for me as well. I connected the sheet with new API and made sure the col names are correct and all it records is the date. I need this fixed ASAP!

Thank You

garryheath (@garryheath)

What files did you upload to overwrite?
Can you be more specific?

@garryheath Hi. Could you please explain more on how you got it to work? Did you upload the files through FTP?

Hello Everyone,
Sorry to see you that you guys are facing the same issue.

Just to make sure about the configuration you have done, can you let us know that while reauthentication did you get the scope authentication like https://ibb.co/DrTS3dC

Also, make sure the Sheet Id and Tab Id is correct without any space.

Note: Please organize your sheet perfectly, Don’t use square braces in naming fields
example: [name] must be written as a name either [Name] should be Name
Use the same as you have used in naming fields.
Again, if you have named the field as [name] and used in a sheet as Name then it will not work with lower versions of WordPress or PHP, so better to write exactly.

Also, the special mail tags would be the same as previous settings _date must be date _remote_ip must be remote-ip.

As at our end, we have tested with WordPress 5.3 to 5.3.2 and also with the PHP version from 5.6.x to 7.3.x. But we are not able to replicate the issue like you guys are facing. [So let me know with Current WP Version and Current PHP Version which would be found in System Status under our plugin.]

Thanks
Abdullah