Chronoforms 7 and Google API

Hello.

I'm having trouble configuring the Google API Service.

At first when creating the service it gave me an error, since in the database table #_chronog3_users_service_accounts. The user_id field is set to Not NULL.

When saving the data from the Crhonoforms Services option, the error appeared that this field could not be empty. I had to modify the behavior of the database so that this could be saved.

At this time I have managed to configure the service and the token appears.

I can't save the data in the spreadsheet.

The steps I follow are:
1. Fill in the form.
2. I press the save button
3. I see the google login (Something that in my opinion should not appear)
4. I start the session and it redirects me to my website.

But in the debug I get the following error:

 [google_sheets_write_9] => Array
         (
             [token] => Access token found
             [var] => false

In the Google console it appears to me that the request has been received but it marks me as 100% errors.


That could be happening. Could someone give me a manual on how to configure this in Chronoforms7? Since I have not found anything since 2016 and this system has already changed in this update

Thank you so much.

I did not work on this since long time and can not give a hint on why its not working now, but did you try to use some web service like Zapier to do the Sheet save ? is this a good solution for you ?

if it's not then what is the reason ?