Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I'm encountering a recurring issue with my Zapier setup involving Google's BigQuery. Every 24 hours, the connection to BigQuery expires, and I have to manually reconnect it to keep my Zaps running smoothly. This is becoming quite a hassle, especially since my workflows depend on continuous data syncing.

Here are the details:

  • Issue: BigQuery connection in Zapier expires every 24 hours.
  • Impact: My Zaps fail to run as the connection needs to be reauthenticated daily.
  • Steps Taken: I've checked the authentication settings and ensured that my BigQuery account permissions are correctly set up.

Has anyone else faced this issue? Are there any workarounds or solutions to prevent the connection from expiring daily? Any insights or suggestions would be greatly appreciated!

Hi there @mentor,

I did some digging into this, and found that the error message requiring re-authentication every 24 hours or less usually means that you need to change your "Reauthentication Policy" in your Google Admin console. 

You can set Zapier as a Trusted App and then exempt Trusted Apps from reauthentication. Or, you can change your settings to never require reauthentication for any app. See https://support.google.com/a/answer/9368756 for details. 

After you have changed your settings in Google Admin, please reconnect your Google BigQuery account to Zapier.

Hopefully, this helps!

Reply


Terms & Conditions