DCM Reporting API to Google Sheet

[Keke]

Hi!

The plan here is to create Google Sheet script that uses DCM's Reporting API to import report data directly into the sheet file. Does anyone have similar system or code examples how to achieve this?

Found some code samples but they're now quite what I'm looking for here...

https://github.com/googleads/googleads-dfa-reporting-samples

Examples receiving auth token from Google Api's are highly appreciated! :)

[Lakshmi Prathipati (DCM API Team)]

Hi,

Please check some of the Apps Script samples from here. The samples which you are referring are DCM API specific samples.  I recommend contacting Apps Script support. 

Thanks,

Lakshmi, DCM API Team

[Chris Liberti]

Hi Keke,

Just add the DCM API and the Google Sheets api to your project and then you can start using it.  There will be a DCM Campaigns resource that you can use with auto complete.  When you run any of the commands the sheets will automatically pop up on authorization dialog.  No need to follow the instructions to authenticate with oath.