Script for negative keywords

[Alexander Schwarz]

I'm looking for a way to import negative keyword lists from a google sheet, so I can add to the sheet and the lists are updated automagically. 

I think I've seen a script or a solution for this usecase some months ago, but I can find it.

Any ideas?

[Google Ads Scripts Forum Advisor]

Hello,

Thanks for reaching out. Harry here, from the Google Ads Scripts Team.

We do have the following solution scripts available on our end that could relate to your requirement. Feel free to read through their use case.

• Negative Keyword Conflicts - Single Account
• Master Negative List - Single Account

On the other hand, I can walk you through the process of implementing a script from scratch to meet your specific requirement. Please see initial references below:

• Let's say you already have Google Sheet data that you'd need to create Negative Keywords Lists. 
• You can use the Spreadsheet Service to retrieve data from the Google Sheet. See examples here.
• From there, you can build lists through the AdsApp.​NegativeKeywordListBuilder with the data you pulled from the sheet.
• You can also add the list to specific campaigns via the addNegativeKeywordList(negativeKeywordList) method.
• When you want to update lists, you can only rename it using the setName method or add more negative keywords by using the addNegativeKeyword and addNegativeKeywords methods.

Please note as well that you can add up to 5,000 negative keywords per list, and create up to 20 negative keyword lists in your account. See this link for more information in this regard.

Let me know if you have questions.

Thanks,

Harry Cliford Rivera Google Ads Scripts Team

ref:_00D1U1174p._5004Q2UhA1c:ref

[Alexander Schwarz]

Thanks this was precisely the script I was looking for.

I have some improvements in mind that I can't implement myself, but your pointers are a good start.