Can’t save Google Access Code

@semikola
Hey Simone,
After adding access code, save it and wait for 30 seconds, automatically page will reload, either refresh the page, it will show you active.
Yes, it’s supported in Multisite as well.

Thanks

Sorry, but it is not working. I tried to get the code on diffrent browsers and on privat-windows. I saved it and waited. There is no reload automaticly. If i reload the page after 1 minute, the code is not there anymore and nothing is saved.

Please help! Thanks

I have the same problem. Token can’t be saved.

@doppellecker, @assoscoupa

If the authentication box displays “Currently Active” it means you have successfully authenticated.

But if during authentication the spinning wheel continues then check the log.txt file for any error printed.

The log file can be opened by clicking the “View” link below the authentication box.

If there is no error printed then make sure that your site is SSL verified. As the new plugin update with API V4 version requires your site to be SSL verified.

And if it is SSL verified then there can be a CURL issue.

To confirm the exact issue add the following code in the wp-config.php file before “/* That’s all, stop editing! Happy publishing. */” and again test it out.

define(‘WP_DEBUG’, true);

define(‘WP_DEBUG_LOG’, true);

define(‘WP_DEBUG_DISPLAY’, true);

define(‘SCRIPT_DEBUG’, true);

define(‘SAVEQUERIES’, true);

If there is any error then the debug.log file would be created under the wp-content folder.

Check that out and let us know.

@westerndeal Sorry but, I tried your directions but there was no progress. I didn’t find any related messages in the logs. The plugin does not save the token number.

I am disappointed that you are offering a good solution with this add-on but I can’t get it to work.

@assoscoupa
Can you make sure quickly following
1. Open a Private window and click to get code and get a new auth code and copy the code and click on save, and wait for 2 mins for auto-reload, if did not reloaded automatically reload manually.
2. Make sure you have added SheetName, SheetID, TabName and Tabid exactly as suggested.
3. While setting headers in Google sheet make sure not to use square braces[], spaces or any special characters like underscore, single or double colon etc.

If still did not work, contact us through our website, will definitely help you to solve your issue.

Thanks
Abdullah

Hello.

It is the same for me. It still not working.
I tried to put some Numbers in the Goggle Code Field. After Pressing “SAVE” it shows “Your Google Access Code is Authorized and Saved.”

If i put the real Code in it, it is stoill not working. After refreshing the site, the Code is not there anymore.

Here is the Error from the LogFile

4 M?¤rz 2020 15:43:40 	 PHP 7.3.5Array
(
    [ERROR_MSG] => Auth, Invalid OAuth2 access token
    [TRACE_STK] => #0 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(131): cf7gsc_googlesheet->auth()
#1 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/class-wp-hook.php(288): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
#2 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters(NULL, Array)
#3 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
#4 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-content/plugins/contact-form-7/includes/submission.php(214): do_action('wpcf7_mail_sent', Object(WPCF7_ContactForm))
#5 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-content/plugins/contact-form-7/includes/submission.php(34): WPCF7_Submission->submit()
#6 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-content/plugins/contact-form-7/includes/contact-form.php(740): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
#7 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-content/plugins/contact-form-7/includes/rest-api.php(285): WPCF7_ContactForm->submit()
#8 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/rest-api/class-wp-rest-server.php(946): wpcf7_rest_create_feedback(Object(WP_REST_Request))
#9 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/rest-api/class-wp-rest-server.php(329): WP_REST_Server->dispatch(Object(WP_REST_Request))
#10 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/rest-api.php(305): WP_REST_Server->serve_request('/contact-form-7...')
#11 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/class-wp-hook.php(288): rest_api_loaded(Object(WP))
#12 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters(NULL, Array)
#13 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/plugin.php(544): WP_Hook->do_action(Array)
#14 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/class-wp.php(387): do_action_ref_array('parse_request', Array)
#15 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/class-wp.php(729): WP->parse_request('')
#16 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-includes/functions.php(1255): WP->main('')
#17 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/wp-blog-header.php(16): wp()
#18 /var/www/vhosts/h16753.web137.dogado.net/doppellecker.de/new/index.php(17): require('/var/www/vhosts...')
#19 {main}

Please Help

I’m having the same issue, token is not being saved, wheel just keeps spinning, no auto refresh or anything, also tried in a private window, also no luck.
Also tried reathing with google, getting a new code, but no luck either
Error log:

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

• This reply was modified 5 years ago by raymond1432.

@raymond1432
@doppellecker

First, Open your website using private window incognito mode
Try to validate from there, it may happen because of the browser cache.

If still same can you change browser to FF if using chrome, and switch to chrome if using FF.
Reauthentication is must, without that data is not going to submit in gsheet.
Additionally, look at this video and make sure to check you are not missing any step.

I tried in a private incognito window, and multiple browsers (firefox, chrome and opera)
But still the same problem and same message in error log

Hi. Sorry

But i did everything exact as you wrote.
I tried ff and chrome and ie in private mode.

After refreshing the site, The Code is lost and not saved.
It stills says:

“Click “Get code” to retrieve your code from Google Drive to allow us to access your spreadsheets. And paste the code in the below textbox. ”

And still. I does not matter ehat i write in the field. It allways says:

“Your Google Access Code is Authorized and Saved.”

Sorry. I dont know what to do!

Dear @westerndeal

I followed carefully the instruction you wrote.

Can you make sure quickly following
1. Open a Private window and click to get code and get a new auth code and copy the code and click on save, and wait for 2 mins for auto-reload, if did not reloaded automatically reload manually.

The plugin cannot save the token !!!

Are you SURE the plugin works or do we waste time with no sense?

@assoscoupa

What issue you are having?
Can you send me a screenshot please? if you want to send through email then [email protected] is an email.

Obviously plugin is working, After upgrading to API V4, it needs to configure perfectly for naming headers exactly as instructed.
Have you checked the video to make sure you are not missing any step?

Dear @westerndeal

Assuming the code is entered correctly, should it appear in the field after reloading the page? yes or no?

Yes Reload it, if still showing same auth key error,
https://myaccount.google.com/permissions
Third-party apps with account access
You will see various connections,
go there and you will GSheetConnector, remove access manually while clicking and then again reauthenticate from plugin settings, and let me know.

Thanks
Abdullah