CF7 Google Sheet Connector Version 4.0 Updates

Update –
I recreated both the sheet and the form from scratch, pasting each field and then testing one by one and it seems to be working now.

OK, after many attempts, finally got this working.
The solution as suggested by jolive is to start again – right from the beginning.
I deleted the plugin and re-installed it
I created a new CF7 form
I deleted my Sheet and made a new one with the CF7 form field names copy/pasted
I got a new Access code from Google
Now it works – I’m hoping it will continue to work
Happier now

Question –

When sending a date to the sheet it shows up as YYYY-MM-DD
Even if I set the cells in the sheet to mm-dd-yyyy it still shows up wrong.

Is there a way to have C7 send the date to the sheet as mm-dd-yyyy?

Thank you,
Joe

@jolive
Date format works as per you have configured in your WordPress Backend Settings page
Whatever date format you have selected in backend, it will work accordingly.

Please check and let me know further.

@trcwebmaster and @jolive

Thanks for sharing that perfect configuration works.

Other users of CF7 please read the comments and configure accordingly to avoid issues.

Thanks

The “date” in column A is following the WP settings (this works fine)
I am referring to the date chooser when having a user fill in a date in the form (For example I want to capture Date of Birth in a form and show in US format mm-dd-yyyy)

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

How I got this to work:
I downloaded the latest version from the repository again. link here. It worked in one form I had, but not the other form.

For the form that did not work:
1) I created a new google sheets tab in the same googles sheets TAB.
2) I copy and pasted the data from the non-working tab.
3) I used the same SheetID and the new TabID.
4) I deleted the non-working TAB.

It’s now working, but I am not feeling very confident in the product reliability because I do not understand what broke it. It seems that this plugin update is NOT backwardly compatible and instantly broke most installations of the plugin.

Same issue for me.
I followed all the instructions here but no data has been added to the Google Sheet.
emails from the form are arriving fine.
This is the error in the log:
15 ???‘?¨?????¨ 2020 19:13:59 PHP 7.3.14Array
(
[ERROR_MSG] => Auth, Invalid OAuth2 access token
[TRACE_STK] => #0 /home/damorgi1/public_html/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(131): cf7gsc_googlesheet->auth()
#1 /home/damorgi1/public_html/wp-includes/class-wp-hook.php(288): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
#2 /home/damorgi1/public_html/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters(”, Array)
#3 /home/damorgi1/public_html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
#4 /home/damorgi1/public_html/wp-content/plugins/contact-form-7/includes/submission.php(214): do_action(‘wpcf7_mail_sent’, Object(WPCF7_ContactForm))
#5 /home/damorgi1/public_html/wp-content/plugins/contact-form-7/includes/submission.php(34): WPCF7_Submission->submit()
#6 /home/damorgi1/public_html/wp-content/plugins/contact-form-7/includes/contact-form.php(740): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
#7 /home/damorgi1/public_html/wp-content/plugins/contact-form-7/includes/rest-api.php(285): WPCF7_ContactForm->submit()
#8 /home/damorgi1/public_html/wp-includes/rest-api/class-wp-rest-server.php(946): wpcf7_rest_create_feedback(Object(WP_REST_Request))
#9 /home/damorgi1/public_html/wp-includes/rest-api/class-wp-rest-server.php(329): WP_REST_Server->dispatch(Object(WP_REST_Request))
#10 /home/damorgi1/public_html/wp-includes/rest-api.php(305): WP_REST_Server->serve_request(‘/contact-form-7…’)
#11 /home/damorgi1/public_html/wp-includes/class-wp-hook.php(288): rest_api_loaded(Object(WP))
#12 /home/damorgi1/public_html/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters(”, Array)
#13 /home/damorgi1/public_html/wp-includes/plugin.php(544): WP_Hook->do_action(Array)
#14 /home/damorgi1/public_html/wp-includes/class-wp.php(387): do_action_ref_array(‘parse_request’, Array)
#15 /home/damorgi1/public_html/wp-includes/class-wp.php(729): WP->parse_request(”)
#16 /home/damorgi1/public_html/wp-includes/functions.php(1255): WP->main(”)
#17 /home/damorgi1/public_html/wp-blog-header.php(16): wp()
#18 /home/damorgi1/public_html/index.php(17): require(‘/home/damorgi1/…’)
#19 {main}
)

What have I done wrong?

Thanks,

Udi

@garryheath

Your solution worked for me too.
Thanks a lot.

Since I re-created everything (forms and sheets) from scratch and got a new Google access code, this seems to be working fine again.
Just one more thing… I still see the nag screen about re-authentication with Google, even though I clearly have. Clicking Yes I have done or Remind me later makes no difference. Clicking the X closes the nag, but it returns when I changes pages.
Any ideas?

@trcwebmaster
Yes! click Yes on a different browser than Chrome and it will be closed.
I used FF for that.

Guys, I’ve just noticed what is cocking things up. Trailing spaces in column headers!

@westerndeal Any chance to process that before parsing data? This might catch so many users, as they are invisible.

Thanks.

@007me
Brilliant – that works. No more nag screen. I used MS Edge.
Begs 2 questions – why?
and… How did you work that out?!!
Cheers

ummm let me clarify a bit about my situation.

On the Google Sheet, I have put date and time (without any special characters) on the 1st row of the sheet and the record showed something like ’17/02/2020 instead of 17/02/2020

Is it a bug or something normal? Thanks for your help =]

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

Gone through this with a fine tooth comb, made all the changes recommended for the new version and sadly does not work anymore – no data appearing in spreadsheet. V3 worked without any problems – v4 needs a fix.