About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • Troubleshooting
  • Google BigQuery Error ‘Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials. ​
Question

Google BigQuery Error ‘Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials. ​

  • 18 February 2023
  • 6 replies
  • 1024 views
ETA Data

Hello, 

 

I am trying to automate a Zap that writes and/or appends a table in BQ when a Form is filled out. However, I’m getting an error ‘Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.’

 

I’ve checked all connections and I’m logged in with the proper accounts.

 

Any advice?

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @ETA Data 

Good question.

Since there are no Zap help articles available related to BigQuery, I suggest you try opening a ticket with Zapier Support: https://zapier.com/app/get-help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
ETA Data

Got it. Thanks, Troy!

christina.d
Userlevel 7
Badge +9

Hey there, @ETA Data! I can see you were able to open a ticket with my teammates in support, which is perfect.👌🏽

Once ya’ll are are able to arrive at an end solution, we’d love it if you shared it here! 🤗

L

@ETA Data @christina.d I have the same issue, I have tried so many different things but still getting the error. Can you please share the solution? 🙏 

ken.a
Userlevel 7
Badge +6

Hi @Lili CRV,

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Please show all the setup of the trigger and action step so that I can take a closer look.

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks! 😊

SamB
Rank
Userlevel 7
Badge +11

Hi there @Lili CRV! 👋

I’m not sure whether this was resolved, it looks like the way it was left with the Support team was that @ETA Data was going to reach out to BigQuery’s support team directly to investigate further. 

That said, I did want to share some of the troubleshooting details shared by Support just in case it’s helpful to you:

“I've pulled the below from here: https://docs.getdbt.com/faqs/troubleshooting/access-gdrive-credential#:~:text=Usually%20this%20errors%20indicates%20that,Google%20Drive%20or%20Google%20Sheet.
 

Usually this errors indicates that you haven't granted the BigQuery service account access to the specific Google Drive document. If you're seeing this error, try giving the service account (client email seen here) you are using for your BigQuery connection in dbt Cloud, permission to your Google Drive or Google Sheet.

 
As well as to the account connected, you may need to grant permissions for third party apps so Zapier can access it. If permissions are correct, this may have something to do with the SQL Query. Does that SQL query run without issue outside of Zapier?”


Hope that helps. If you do manage to solve things by adjusting the permissions please let us know. Keen to ensure you’re all set! 🙂

Reply


Terms & Conditions