function main() {
addNegativeKeywordsForNonConvertingSearchTerms();
}

function addNegativeKeywordsForNonConvertingSearchTerms() {
var report = AdsApp.report(
“SELECT Query, AdGroupId, CampaignId, Cost, Conversions ” +
“FROM SEARCH_QUERY_PERFORMANCE_REPORT ” +
“WHERE Conversions = 0 AND Cost > 0 ” +
“DURING LAST_30_DAYS”
);

var rows = report.rows();
var negativeKeywords = [];
while (rows.hasNext()) {
var row = rows.next();
var query = row[‘Query’];
var adGroupId = row[‘AdGroupId’];
var campaignId = row[‘CampaignId’];

var adGroupIterator = AdsApp.adGroups().withIds([adGroupId]).get();
if (adGroupIterator.hasNext()) {
  var adGroup = adGroupIterator.next();
  var existingNegativeKeywords = adGroup.negativeKeywords().withCondition("Text = '" + query + "'").get();

  if (!existingNegativeKeywords.hasNext()) {
    adGroup.createNegativeKeyword(query);
    negativeKeywords.push("Termo: " + query + " | Campanha: " + campaignId);
    Logger.log("Adicionado termo de pesquisa como palavra-chave negativa: " + query + " na campanha: " + campaignId);
  }
}

}

if (negativeKeywords.length > 0) {
sendEmailNotification(negativeKeywords);
}
}

function sendEmailNotification(negativeKeywords) {
var email = “adm@agencianovofoco.com.br”; // Seu endereço de e-mail
var subject = “Novos Termos de Pesquisa Negativados”;
var body = “Os seguintes termos de pesquisa foram negativados:\n\n” + negativeKeywords.join(“\n”);
MailApp.sendEmail(email, subject, body);
}