Google Sheets Integration Failure in Forminator – Fatal Error

  • Resolved Sakshi Tyagi

    (@sakshityagi343)


    4 weeks, 1 day ago

    Hi,

    Google Sheets integration is no longer working, even though it was functioning perfectly for all forms previously. I attempted reauthorization in the Forminator configuration with Google Console, but the issue persists, and data is still not passing to the sheet.

    To troubleshoot, I tried disconnecting an already connected Google Sheet from a form and then attempted to reconnect it. However, upon doing so, I encountered the following fatal error in the log file:

    PHP Fatal error:  Uncaught TypeError: Cannot access offset of type string on string in /var/www/html/wp-content/plugins/forminator/addons/pro/googlesheet/class-forminator-addon-googlesheet.php:548
    Stack trace:
    #0 /var/www/html/wp-content/plugins/forminator/addons/pro/googlesheet/class-forminator-addon-googlesheet-settings-trait.php(336): Forminator_Googlesheet->refresh_token_if_expired()
    #1 /var/www/html/wp-content/plugins/forminator/addons/pro/googlesheet/class-forminator-addon-googlesheet-settings-trait.php(170): Forminator_Googlesheet_Form_Settings->setup_existing_sheet()
    #2 /var/www/html/wp-content/plugins/forminator/library/addon/class-integration.php(1157): Forminator_Googlesheet_Form_Settings->setup_spread_sheet()
    #3 /var/www/html/wp-content/plugins/forminator/library/addon/class-integration.php(1035): Forminator_Integration->get_wizard()
    #4 /var/www/html/wp-content/plugins/forminator/library/addon/class-integration.php(1015): Forminator_Integration->get_form_settings_wizard()
    #5 /var/www/html/wp-content/plugins/forminator/library/addon/admin/class-integration-admin-ajax.php(531): Forminator_Integration->get_form_settings_wizard()
    #6 /var/www/html/wp-includes/class-wp-hook.php(324): Forminator_Integration_Admin_Ajax->module_settings()
    #7 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()
    #8 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action()
    #9 /var/www/html/wp-admin/admin-ajax.php(192): do_action()
    #10 {main}
      thrown in /var/www/html/wp-content/plugins/forminator/addons/pro/googlesheet/class-forminator-addon-googlesheet.php on line 548

    Could you please assist in resolving this issue as soon as possible? Let me know if you need any additional details.

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

    (@wpmudevsupport13)

    Hi @sakshityagi343

    I hope you are doing well today.

    We have bug reported already in that matter and future update of Forminator 1.40 will fix this issue. Release is planned for middle February. Please stay tune to our roadmap https://wpmudev.com/roadmap/#upcoming-forminator-1-40

    Kind Regards,
    Kris

    Plugin Support Nithin – WPMU DEV Support

    (@wpmudevsupport11)

    Hi @sakshityagi343,

    Since we have identified this as a bug and we can acknowledge this will be fixed in a future update, I’ll mark it as resolved for now.

    For any new feature updates, you can get notifications on our progress by subscribing to our roadmap at https://wpmudev.com/roadmap/

    Once new versions are released, any pertinent changes will be described in the changelog, which you can find at:

    https://www.ads-software.com/plugins/forminator/#developers

    Kind Regards,

    Nithin

    Plugin Support Imran – WPMU DEV Support

    (@wpmudev-support9)

    Hello @sakshityagi343,

    I hope things are going well for you.

    The issue has been resolved on Forminator 1.40.0. Can you please update the plugin to the latest version and check further?
    Fix: Fatal Error when Google Sheet API token is invalid

    Please feel free to let us know in case you have any questions.

    –
    Thanks & Kind Regards,
    Imran Khan

    Thread Starter Sakshi Tyagi

    (@sakshityagi343)

    Hi,

    Thanks for the update!

    Earlier, I could see only one Google Sheet connection option, but now it appears three times. Please take a look at this screenshot: https://prnt.sc/hUXzCtwLWSCa.

    Additionally, the existing Google Sheet connections in our forms seem to have been disconnected. Is there a way to restore these connections? We have around 50 forms in Forminator, and reconnecting each one manually would be extremely time-consuming.

    Please let me know if there’s a solution to retrieve the connection data.

    Thanks for your help!

    Plugin Support Imran – WPMU DEV Support

    (@wpmudev-support9)

    Hello @sakshityagi343,

    I hope things are going well for you.

    Earlier, I could see only one Google Sheet connection option, but now it appears three times.

    Can you please navigate to the WordPress Admin Dashboard > Forminator > Integrations > Applications > Check if three Google Spreadsheet integrations have been added. If yes, you can remove the ones that aren’t in use.

    Additionally, the existing Google Sheet connections in our forms seem to have been disconnected. Is there a way to restore these connections? We have around 50 forms in Forminator

    You can manually reconnect them using the same Google account to re-integrate. However, you’ll have to manually re-integrate each form, which is time-consuming.
    While integrating, you’ll have an option to choose the spreadsheet > existing spreadsheet.
    Also, you can refer to this guide https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#google-sheets-existing.

    Please try with one form or on the staging site and see how it goes.

    –
    Kind Regards,
    Imran Khan

    Thread Starter Sakshi Tyagi

    (@sakshityagi343)

    Hi,

    Can you please navigate to the WordPress Admin Dashboard > Forminator > Integrations > Applications > Check if three Google Spreadsheet integrations have been added. If yes, you can remove the ones that aren’t in use

    This I checked and found same APP connection details were duplicated two more times. So I delete them.

    Manually will take time to re-connect all the forms. Is there no way we can retrieve those connections back?

    Plugin Support Nithin – WPMU DEV Support

    (@wpmudevsupport11)

    Hi @sakshityagi343,

    Unfortunately, manual reconnection will be necessary, as there is no alternative workaround at this time. I will be sure to bring this matter to the attention of our developers so they are aware of the issues that have been observed.

    Regards,

    Nithin

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.