I can’t connect to Google Sheets

Hello @asiergana

I hope you’re doing well!

The error means that the project was not created correctly. The redirect_url_mismatch error is a common Google error when the redirect URL entered is not correct. Please see for more:
https://stackoverflow.com/questions/11485271/google-oauth-2-authorization-error-redirect-uri-mismatch

Please try creating a new project by following step by step provided instructions.

Please make sure that Google Drive API and Google Sheets API libraries are enabled.

When creating an application, please make sure the redirect URI is added.

Let us know how it went!

Kind regards,
Nastia

Thank for all.
I copied the URL from the web.
With the mouse, triple click for select all and I copied it on authorized URI, but when I try to integrate Google Sheets, on the error, instead of https://www.lacompasionescolapios.org/wp-admin/admin.php?page=forminator-integrations&slug=googlesheet&section=authorize puts https://www.lacompasionescolapios.org/wp-admin/admin.php?page=forminator-integrations

Hello @asiergana ,

Can you make a screenshot of the URI in the Google console? Maybe URL there is not correct after saving? Can you make sure there are no spaces or characters that are not supposed to be there?

kind regards,
Kasia

Hi.

This is the screenshot: Error screenshot
And this is the copied URL:
https://www.lacompasionescolapios.org/wp-admin/admin.php?page=forminator-integrations&slug=googlesheet&section=authorize

There isn’t blank after or before.

Hi @asiergana

Thanks for sharing settings screenshot.

Please go to your Google Developers Console where you set the Redirect URI and once the URL is added to the field, make sure that you press “Enter” while still in that field.

That URl that you added should then show up right below the filed (between the field and the “ANADIR URI” button – only then it’s added so then save these settings. Unfortunately, Google developers console interface is a bit confusing sometimes and even though it looks like the URL is added, it really isn’t.

Give it a try please and let us know if that helped.

Best regards,
Adam

Hi.
I did press Enter on console interface on URI. Then, automatically Save button has been pressed and it has changed the screen to the credential list, but when i have try to connect forminator with Google Sheets I have the same error. Maybe it can be a SSL certificate problem. We have it wit Let’s encrypt.
Thank you.

Hello @asiergana

Could you please send me an email to [email protected] using this template:

Subject: “Attn: Dimitris”

Message: link back to this thread for reference

Keep in mind the subject line, as it ensures that it gets assigned to me.

Thank you,
Dimitris

Hello @asiergana

I hope you are doing well!

We haven’t heard back from you for a while now so we’re going to mark this ticket as resolved, if you do have any followup questions or require further assistance feel free to reopen it and let us know here.

Kind regards,
Nastia