Cant access Spreadsheet using SpreadsheetApp.openByUrl()

23 views
Skip to first unread message

Hamza Ansari

unread,
May 11, 2020, 7:39:58 AM5/11/20
to AdWords API and Google Ads API Forum
Im trying to write a script for my MCC Adwords account which is pretty straight forward. Every thing is working great except when i try to access a spreadsheet using function below
SpreadsheetApp.openByUrl

but i am getting an error saying

Service Spreadsheets failed while accessing document with id.
kindly let me know the solution for this, it will be very helpful, thanks.

Google Ads API Forum Advisor Prod

unread,
May 11, 2020, 11:30:30 AM5/11/20
to hamx...@gmail.com, adwor...@googlegroups.com
Hi Hamza,

Thank you for reaching out to us. Could you confirm with me if you're using Google Ads Scripts API? If so, you can find support from the Scripts Support Team here, as they are better equipped to assist you with your scripts related concern. Let me know if you have further questions.

Thank you,
Bryan, Google Ads API Team

ref:_00D1U1174p._5004Q1zLET6:ref

Hamza Ansari

unread,
May 11, 2020, 11:38:46 AM5/11/20
to AdWords API and Google Ads API Forum
Thank you for your reply.
Im Writing a simple script to use within my MCC account. The one that we implement in Bulk action menu.

Google Ads API Forum Advisor Prod

unread,
May 11, 2020, 12:51:45 PM5/11/20
to hamx...@gmail.com, adwor...@googlegroups.com
Hi Hamza,

Are you referring to Batch Processing? Could you confirm if you're using Google Ads/AdWords API or Google Ads Scripts API? Please let me know so that I may further assist you with your concern.
Reply all
Reply to author
Forward
0 new messages