Schedule Google Ads reports via Google Sheets addon

[Christian Weinke]

Hi there, I'm trying to get Google Sheets addon to pull reporting data from Google Ads every day. There doesn't seem to be any scheduling function. Is there another way of doing this?

[Nils Rooijmans]

here's a script that you can use to automatically pull any Google Ads data to a Google Sheet on a hourly/daily basis:

https://searchengineland.com/script-automates-adding-adwords-data-google-spreadsheet-277724

This script takes a Google spreadsheet as input. Based on the column headers, data filters, and date range specified on this sheet, it will generate different reports.

Hope this helps,

Nils Rooijmans
https://nilsrooijmans.com
See my Google Ads Scripts FAQ to avoid the same mistakes I made: https://nilsrooijmans.com/google-ads-scripts-faq/

[Google Ads Scripts Forum Advisor]

Hi Christian,

 

This is Yasmin from the Google Ads Scripts team.

 

@Nils - Thank you so much for providing your insights to this forum. The community highly appreciates your help.

 

@Christian - You may try to follow Nils' suggestion and let us know if this is sufficient for your use case. In the event that it does not, I would request that you provide more context, such as a screenshot of the data you'd like to pull from the UI, so we can be able to check this on our end and better assist you with your concern.

 

Kindly send the requested items via `Reply privately to author` option. If the said option is not available on your end, you may send those through this email alias <googleadsscr...@google.com> instead.

 

Regards,

 

 

Yasmin Gabrielle Google Ads Scripts Team

ref:_00D1U1174p._5004Q2dIuMS:ref

[Morten Jester]

Hi

@nils - Thanks for input. I'm on your email newsletter and I love it.

@adsscripts OR @nils - I've copied the spreadsheet with the AdWords Data Grabber from Optmyzr.

But already when I Choose Report Type I get an error. It seems Google is blocking the app? How can I get around this?

The below is a message in danish saying "This app is blocked" - It try to get access to sensitive information in my Google-account. Google blocked the access in concern to my account safety.

Best regards

Morten

[Google Ads Scripts Forum Advisor]

Hi Morten,

This is Ciara from the Google Ads Scripts team as well.

For us to investigate further, can you provide us with the following information:

• Google Ads account ID / CID
• Script name
• Shareable link of the involved spreadsheet, you may follow this guide on how you can get the said shareable link.

You may send privately via the reply to author option. If this option is not available on your end, you may send it through our email (googleadsscr...@google.com) instead.

Looking forward to your response.

Regards,

Ciara Google Ads Scripts Team

ref:_00D1U1174p._5004Q2dIuMS:ref