Google Sheets Integrations not activating

Hi @3rdschulz

Sorry to hear you are having this problem.

Could you please verify if your spreadsheet API is enabled, the domain and the redirect URL is configured on the Google console?

https://monosnap.com/file/HDkqbb1giQDO4YIn0L9TtvRkhXFfkn

You can follow the guide here:
https://premium.wpmudev.org/docs/wpmu-dev-plugins/forminator/#google-sheets

Let us know the result you got,
Best Regards
Patrick Freitas

Hi Patrick
Thanks for the reply! I really appreciate you getting back to me. Both API’s are enabled and I followed the directions to the best of my knowledge. I’ll admit though I don’t often go into the API management screen. Screen shots below of enabled APIs and error.

screen shot 1 https://ibb.co/8sV5fxY

screen shot 2 https://ibb.co/MCTpDbS

Screenshot 3 https://ibb.co/41F2m67

Screenshot 4 https://ibb.co/JCfJw8f

Hello @3rdschulz,

I see the API is enabled but the API needs to be integrated which is why you need to go here: https://console.developers.google.com/cloud-resource-manager

Click on API & Services-> Credentials-> Create OAuth 2.0 Client IDs or edit the existing one if you have created and add an Authorized redirect URIs which will then communicate with the plugin.

The images the link to the documentation would explain the step by step procedure given by Patrick in the above reply. I will add that here too:
https://premium.wpmudev.org/docs/wpmu-dev-plugins/forminator/#google-sheets

Could you please check if the same is added and then check if the integration works?

Thank you,
Prathamesh Palve

Hi @3rdschulz

I hope you are doing well.

We haven’t heard from you in a while, I’ll go and mark this thread as resolved.

However, feel free to let us know if you have any additional question or problem.

Best Regards
Patrick Freitas

Hello,
Thank you for the help Patrick! It appears to be working now. I’m not sure what the issue was since it appeared the APIs where activated and everything was connected. However I started the process over and it works now!

However, I’m only able to make a new spreadsheet. Is it possible to have this upload to an existing spreadsheet?

Thanks

Hello @3rdschulz

Current integration can only be used to create a new spreadsheet and cannot be used to connect to an already existing one.
But working between different Google Sheets shouldn’t be too much of a hustle anyway:
https://help.tillerhq.com/en/articles/2844735-how-to-copy-a-sheet-tab-to-another-google-sheet
https://support.google.com/a/users/answer/9308940?hl=en

Warm regards,
Dimitris