Location Scripts - Auto Update Location Criteria For Campaigns

[Cory Johnson]

Hey Team, 

We have a campaign that we would like to make daily updates to the zip codes we’re marketing to. The hope is to have a scripts connection to a Google Sheet where the business can populate zip code updates each day at 1am and then Google goes and retrieves those zip codes from the Google Sheets document at 2am. This way there’s no manual intervention on changes and they are always accurate. Does anyone have experience with a script that does this or another way to automate this task? 

Thanks,

Cory

[Google Ads Scripts Forum Advisor]

Hi Cory,

Thank you for reaching out to us.

Since your concern here is to automate the updates of zip codes in the campaign, I'm afraid that setting campaign's zip code through Google Ads Script is not possible. However, you can make use of location ranges by creating proximity targets. With regard to your input file coming from Google sheets, you can also refer to this documentation.

Regards,

Mark Kevin Albios Google Ads Scripts Team

ref:_00D1U1174p._5004Q2AzkSn:ref

[Cory Johnson]

Thanks Mark!