Sheet integration – one form doesn’t update in sheet

  • Resolved solgudinde

    (@solgudinde)


    3 years, 8 months ago

    Hi!

    I have four different Forminator forms with integrated Google Sheets, but one of them doesn’t work.

    What can I do?

    The first time I had to make it work, it took a long time with a lot of support from your amazing team, so I’m hesitant to re-connect the integration to my page.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Kris – WPMU DEV Support

    (@wpmudevsupport13)

    3 years, 8 months ago

    Hi @solgudinde

    I hope you are doing good today.

    I see you talk about this topic here:
    https://ww.wp.xz.cn/support/topic/google-sheets-error-400-redirect_uri_mismatch/

    Could you follow Adam’s solution and only part about to not disconnect instances
    https://ww.wp.xz.cn/support/topic/google-sheets-error-400-redirect_uri_mismatch/#post-15897799
    and see will this help in this matter?

    Kind Regards,
    Kris

    Thread Starter solgudinde

    (@solgudinde)

    3 years, 8 months ago

    Dear Kris,

    Do you mean this advice:

    `If you cannot disconnect them, try this:
    – regenerate secret key in Google
    – update it in Google Sheets integration and try to re-authorize
    – at some point it will say redirect_uri_mismatch error but then the integration popup in Forminator will keep the spinning wheel; if you close it now and reload the Integrations page – Google Sheets will be gone from the “Connected Apps” section.

    Once that’s done, go to your Google App and remove the OAuth key from there; if there are more than one, remove all of them.

    Then set the new one (just like when creating the app from scratch) and make sure to save it in Google before clicking authorize button in Forminator. It should work right away this way (note: if you are using multiple Google accounts make sure that the browser is logged in to correct one).`

    Plugin Support Laura – WPMU DEV Support

    (@wpmudev-support8)

    3 years, 8 months ago

    Hi @solgudinde

    Actually, you got multiple forms sending data to Google Sheets and only one of them is not working, right?

    If yes – do you have only one Google Sheets integration configured on “Formiantor -> Integrations” page?

    If so, it would mean that integration itself is probably working but there’s something more specific to that form. If you look at that form’s submissions and check any of the recent submissions that didn’t get passed over to Google Sheets – do you see any error message below submission fields values, near the bottom?

    Kind regards,
    Adam

    Thread Starter solgudinde

    (@solgudinde)

    3 years, 8 months ago

    Hi Adam,

    Yes exactly. Only one sheet is not updating its form, the others are.

    In terms of how many integrations I have: I have 25… ‘:D

    They’re all there for the same thing, but I think only one of them is working and actually serve as the integration to Sheets.

    As I lost counts whilst trying to make it all work initially, I don’t dare to delete any of the many that doesn’t work, as they’re all named pretty much the same. Lol.

    I don’t see any error messages though!

    Best wishes,

    • This reply was modified 3 years, 8 months ago by solgudinde.
    Plugin Support Jair – WPMU DEV Support

    (@wpmudevsupport15)

    3 years, 8 months ago

    Hi @solgudinde,

    I hope you are doing well today!

    Since you don’t see any errors and have only one sheet is not being updated by its form, please check what are the differences between other forms and integration on that one.

    You can also make a test by disabling that from, creating one from scratch with minimum fields and try to integrate into the same sheet.

    Kind regards,
    Zafer

    Thread Starter solgudinde

    (@solgudinde)

    3 years, 8 months ago

    Dear Zafer and Adam,

    I disconnected the integration and activated it again, and it’s working fine now. Thank you both for your help!

    Best wishes, and have a great day.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Sheet integration – one form doesn’t update in sheet’ is closed to new replies.