Integrating Forminator with Google Sheets ERROR

  • Resolved jokubas2000k

    (@jokubas2000k)


    3 years, 11 months ago

    Hi,

    I need some help integrating Forminator with Google Sheets.

    I have found the tutorial in your documentation: https://premium.wpmudev.org/docs/wpmu-dev-plugins/forminator/#google-sheets

    The process has a bit changed since your tutorial was made but I think I did everything it said.

    However, when I click “Authorize” and try logging into my Google account, an error appears. It says that I do not have access and I should contact the developer, which is me. And then my personal Email Address is shown.

    Error screenshot: https://ibb.co/cgYN9TR (I covered most of the Request Details because I don’t know if it’s sensitive information or not)

    I used the same Google account (my personal one) to create the APIs and to log in after clicking “Authorize”. I am also listed as the owner of the project with the same Email Address at Access > IAM.

    What could be the issue?

    • This topic was modified 3 years, 11 months ago by jokubas2000k.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @jokubas2000k

    Sorry to hear you are having this issue.

    The error is 403 forbidden, could you please double check:

    – You are using the same account for Google drive and API
    – The credentials are allowed to be used for the sheet API.
    – The Authorised URL and JS has the domain:
    https://monosnap.com/file/nh228zcIvCIxtt8kiCE7SgRRNNVlXA

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

    Thread Starter jokubas2000k

    (@jokubas2000k)

    Hi @wpmudevsupport12,

    Could you please guide me through the process of checking these 3 things? I have no idea where to look.

    Here’s what I got:

    When I go to APIs & Services > Dashboard > Google Drive API > Credentials the OAuth 2.0 Client I created is there.

    When I go to APIs & Services > Dashboard > Google Sheets API > Credentials the OAuth 2.0 Client I created is also there.

    When I go to APIs & Services > Credentials and click on the OAuth 2.0 Client that I created here’s what I see: https://ibb.co/DGwTv7Q
    The tutorial in the documentations didn’t mention anything about the Authorised JavaScript origins field so I left it empty. In the Authorised redirect URIs field I pasted the URI from the popup.

    When I go to APIs & Services > OAuth consent screen here’s what I see: https://ibb.co/YkXxKLV
    Should the Publishing status be Testing? Should I add myself as a test user?

    I have also added my domain name at APIs & Services > Domain verification

    Both the Google Drive API and the Google Sheets API are enabled and visible at APIs & Services > Dashboard. Screenshot: https://ibb.co/YWZ2Nkk

    That’s all I got. Don’t know what other information might be useful and where else to look.

    Looking forward to your response.

    Thread Starter jokubas2000k

    (@jokubas2000k)

    Also, when I go to APIs & Services > Dashboard > Google Drive API > Drive UI Integration everything is empty.

    Screenshots:
    https://ibb.co/jkt1Pnf
    https://ibb.co/cDVpd7Q

    Should this information be filled in?

    Thread Starter jokubas2000k

    (@jokubas2000k)

    Hi @wpmudevsupport12,

    Just wanted to let you know that I’m still waiting for your response.

    Best regards
    Jokubas

    Plugin Support Dimitris – WPMU DEV Support

    (@wpmudev-support6)

    Hello there @jokubas2000k

    I’m really sorry for the huge delay here. Somehow we missed the email notification with your reply.

    When I go to APIs & Services > OAuth consent screen here’s what I see: https://ibb.co/YkXxKLV
    Should the Publishing status be Testing? Should I add myself as a test user?

    App should be published, please do so, there is a “Publish App” button right below.

    Let us know if that makes any difference.

    Thank you,
    Dimitris

    Thread Starter jokubas2000k

    (@jokubas2000k)

    Hi @wpmudev-support6,

    It worked, thanks.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Integrating Forminator with Google Sheets ERROR’ is closed to new replies.