AUTOMATION FROM GOOGLE SHEET TO GOOGLE ADS

[Giovanni Curcio]

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]

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]

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]

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.