Schedule Google Ads Report to Google Sheets

[Kevin Montel]

Dear Google Ads Community,

I am trying to achieve a pretty simple task, which unfortunately seems to be pretty complex in nature.

I would like to create an automation (any kind of automation) that will send daily Google Ads data to Google Data Studio. 

I thought that scheduling the creation of a Google Sheets spreadsheet would be enough, since Data Studio accepts Google Sheets as source as well.

The problem is that the scheduled task produces a new Google Sheets (with the same name) everyday, without overwriting the previous file. This is forcing me to change the Google Sheets datasource by hand everyday.

I am currently exploring various solutions to achieve this, such as:

- Ads Script to update a targeted spreadsheet (which would come in handy, but I am unable to run it on MCC level properly)

- Another Ads Script (MCC level) to update a targeted spreadsheet (which throws an AWQL error for every FROM clause I set)
- Google Ads add-on for Google Sheets (which is not available in Italy...)

- Setup an ImportXML trigger in Google Sheets (which seems to surpass the purpose of my task)

- Some hidden setting in Google Drive that would make overwrite files with the same name in the same folder (which would be the simplest solution)

- An external Python script that reads the daily e-mail attachment and somehow feeds it directly to Data Studio (?)

Could somebody help me find a quick solution / workaround to this?

Thanks a lot for the attention.

Kevin

[Google Ads API Forum Advisor Prod]

Hi Kevin,

Since you mentioned Google Ads Scripts as a possible solution and since it can post data on Google Sheets, I'd recommend reaching out to the Google Ads Scripts forum for assistance on this.

Regards,
Anthony
Google Ads API Team 

ref:_00D1U1174p._5004Q1zKB5D:ref

[Kevin Montel]

Dear Anthony, thank you for your suggestion. I will try to forward my issue on the other forum as well.