Authorization problem when connecting GAds to BigQuery

17 views
Skip to first unread message

Pablo Marco

unread,
Feb 6, 2019, 5:31:00 PM2/6/19
to AdWords API and Google Ads API Forum
Hi,

I am trying to connect to BigQuery from Google Ads Script for the first time. I am trying to export some data from my accounts, after some treatment with the script.
I am using "Export Google Ads Reports into BigQuery - Single Account" as inspiration.

I have already:

- Created an account and a project in Bigquery
- Authorised Bigquery in the script in "Advanced APIs"
- Authorised Bigquery in the project I am trying to use in google developer console.

When the script reaches this line:

dataSet = BigQuery.Datasets.insert(dataSet, bqProjectId);

I get the following error message:

BigQuery API has not been used in project 467746953204 before or it is disabled. Enable it by visiting https://console.developers.google.com/apis/api/bigquery-json.googleapis.com/overview?project=467746953204 then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry. (file Code.gs, line 304)

Thanks for your help!

googleadsapi...@google.com

unread,
Feb 6, 2019, 10:38:26 PM2/6/19
to AdWords API and Google Ads API Forum
Hi Pablo,

Our team could only provide support on issues/concerns related to AdWords API only. For issues/concerns related to Google Ads Scripts, I would suggest to post it on the Google Ads Scripts Forum as they are better equipped to assist you here.

Thanks and regards,
Luis
AdWords API Team


=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/dccaf73c-0dbe-4bc8-af5e-12a9e0e8dd41%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages