AUTOMATION FROM GOOGLE SHEET TO GOOGLE ADS

30 views
Skip to first unread message

Giovanni Curcio

unread,
Sep 6, 2019, 12:18:48 PM9/6/19
to Google Ads Scripts Forum
Hello, I'm looking for someone who creates an automation from sheet to google ads.

I collect data in google sheet (keywords, budget, link, ecc )  and I want that automatically those data create a campaign in ads.

Is there anyone who can create a script like this?

Thank you

Google Ads Scripts Forum Advisor Prod

unread,
Sep 6, 2019, 3:04:14 PM9/6/19
to adwords-scripts+apn2wqdml_czw3pg...@googlegroups.com, adwords-scripts+apn2wqdml_czw3pg...@googlegroups.co, adwords...@googlegroups.com
Hi Giovanni,

You'll probably have to be more specific with what you're trying to accomplish in your script. 

However, I recommend looking into bulk uploads (1, 2). Scripts support spreadsheet services as well. Here are a few sample snippets to get you started.

Regards,
Matt 
Google Ads Scripts Team

ref:_00D1U1174p._5001UHFyBR:ref

Giovanni Curcio

unread,
Sep 7, 2019, 5:35:13 AM9/7/19
to Google Ads Scripts Forum
Hi Matt, thanks for reaching out. And thank you for the resources.

Basically, I have a spreadsheet with some informations of my clients to create a Video campaign ( their are musicians ).

They give me keywords to target the campaign, date to start the campaign, budget.
I choose the bidding strategy ( fixed CPM for every campaign) , the location ( Italy ).

Than from this spreadsheet I have to create automatically a campaign in google ads with those data.

Was I clearer?
Thanks.
 

Google Ads Scripts Forum Advisor Prod

unread,
Sep 9, 2019, 2:48:47 PM9/9/19
to adwords-scripts+apn2wqdml_czw3pg...@googlegroups.com, adwords-scripts+apn2wqdml_czw3pg...@googlegroups.co, adwords...@googlegroups.com
Hi Giovanni,

I recommend looking into bulk uploads -- here is sample code for creating bulk uploads from Google Sheets. While location targeting is not a supported bulk upload entity, this could be added to the campaigns after they are uploaded. Here is a sample for setting campaign location targets in scripts. You can iterate over campaigns to add locations in bulk.
Reply all
Reply to author
Forward
0 new messages