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
