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 <https://developers.google.com/google-ads/scripts/docs/solutions/account-summary> (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 <https://gist.github.com/siliconvallaeys/4a198d30f080f76afe4bc0eff24e0797#gistcomment-3211573> (which throws an AWQL error for every FROM clause I set) - Google Ads add-on for Google Sheets <https://gsuite.google.com/marketplace/app/google_ads/288999541255> (which is not available in Italy...) - Setup an ImportXML trigger in Google Sheets <https://www.computerworld.com/article/2469616/business-intelligence-79661-how-to-create-an-automatically-updating-spreadsheet.html> (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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/9f1bc05a-6840-42e1-b62e-efbdf2898a26%40googlegroups.com.
