Google Sheet integration works only at the beginning

Hello @simd59

Hope you are doing well today.

There are several items that could be causing your issue:

1. Quota Limits:
Google APIs have daily and per-minute quotas. Check the Google Cloud Console under “APIs & Services” > “Dashboard” for your project to see if you’re hitting any usage limits.

2.API Configuration:
Verify that your API credentials are correctly set up, and that they have appropriate permissions (scopes) for the actions required by your integration.
https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#google-sheets

3. Error Handling:
if you couldn’t find any issues with previous items please enable forminator debug mode by adding the following codes to your wp-config.php file and check the error logs

define( 'WP_DEBUG', true );
// Enable Debug logging to the /wp-content/debug.log file
define( 'WP_DEBUG_LOG', true );
define('FORMINATOR_DEBUG', true);
define('FORMINATOR_ADDON_DEBUG', true);

Please share the logs with us if you find anything related, you can upload the file to a third-party free storage site like Google Drive or Dropbox.

Kind Regards
Amin

Hello Amin,

1. I check the quota it’s ok. I have for the moment not too many people comung to my form.
2. I check again API Credential, all seems ok
3. here are the log, thank you https://drive.google.com/file/d/1zJLP9QTP5HpEIK5fSsfC8kL1-eSQOqTQ/view?usp=sharing

“[09-Feb-2025 13:58:04 UTC] [Forminator] [“[ADDON]”,”googlesheet”,”failed to form add_entry_fields”,”Redirect URI must be absolute”]”

• This reply was modified 1 month ago by simd59.

In addition to that I’ve checked on my side and copy/paste again the “Redirect URI” and it’s well “absolute”:
It’s like this:
https://mydomain.com/wp-admin/admin.php?page=forminator-integrations&slug=googlesheet&section=authorize&global_id=67a3a7e90c6921.31991234

I’ve changed the part in Bold And Italic

Hello @simd59,

Thank you for providing the details.

Could you please check if Authorized JavaScript origins, and Authorized redirect URIs options are set for your client ID in APIs & Services >> Credentials: https://prnt.sc/V5GI-aovfbWp

Please try re-adding both URIs (your domain with https, like “https://example.com“), and save the changes.

After that please give it about 5 minutes to update, and then reauthorize Google Sheets integration in Forminator.

I hope this helps. Please let us know if the issue persists.

Best Regards,
Dmytro

Hey @wpmudevsupport16
Unfortunately it works only for some minutes/hours again. I can’t really said the exact time but I thought i was ok and suddenly same message:

[10-Feb-2025 11:47:50 UTC] [Forminator] [“[ADDON]”,”googlesheet”,”failed to form add_entry_fields”,”Redirect URI must be absolute”]

Before I didn’t put anything on the Authorized JavaScript origins, so I add my domain. (They don’t want “/” in this url part)
And for Authorized redirect URIs?I’ve put the enter URL you gave + just my https domain only “https://example.com“ plus i case “https://example.com/wp-admin/admin.php?page=forminator-integrations&slug=googlesheet&section=authorize“

But no, after several time it just don’t working anymore, I have to reauthorize it…
Something else ?
Here is the last log where you can see when it works and when it doesn’t: https://drive.google.com/file/d/1zJLP9QTP5HpEIK5fSsfC8kL1-eSQOqTQ/view?usp=sharing

Hi @simd59

Please email us at: [email protected]
Subject: ATTN: WPMU DEV support – wp.org

Please send:
– Link back to this thread for reference (https://www.ads-software.com/support/topic/google-sheet-integration-works-only-at-the-beginning/)

so that we can review this case more for you and see what will be possible in this case.

Kind Regards,
Kris

@wpmudevsupport13 @wpmudev-support2 @wpmudevsupport16 Email sent thank you

Hi @simd59,

Seems like switching to “Page Reload” under the Behavior tab > Method resolved your issue.

Please do let us know if you need any further assisance

Regards,

Nithin

No it’s the opposite, you need to switch back to “Ajax” instead of “Page reload”.

I don’t need further assistance for the Google Sheet issue. But for the other one here https://www.ads-software.com/support/topic/radio-1-doesnt-exist-anymore/

HI @simd59,

No it’s the opposite, you need to switch back to “Ajax” instead of “Page reload”.

Yes, correct. Sorry for any confusion.

I don’t need further assistance for the Google Sheet issue. But for the other one here?https://www.ads-software.com/support/topic/radio-1-doesnt-exist-anymore/

We have already replied in your ticket. Feel free to follow up in the above ticket.

Regarding the issues noticed in the current ticket, 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