function main() { // 1. Data Source: Google Sheet var spreadsheetUrl = "https://docs.google.com/spreadsheets/d/..."; // Replace with your spreadsheet URL var dataSheet = SpreadsheetApp.openByUrl(spreadsheetUrl).getSheetByName("CampaignData"); // 2. Campaign Template Settings var campaignNameTemplate = "Dynamic Campaign - {Product Category}"; var budget = 100; // Daily budget // ... other desired campaign settings ... // 3. Iterate through Spreadsheet Data var dataRange = dataSheet.getDataRange().getValues(); dataRange.shift(); // Remove header row for (var i = 0; i < dataRange.length; i++) { var productCategory = dataRange[i][0]; // ... extract other data from the row ... // 4. Create New Campaign (Simplified) var campaignBuilder = AdsApp.newCampaignBuilder(); var campaign = campaignBuilder .withName(campaignNameTemplate.replace("{Product Category}", productCategory)) .withBudget({ amount: budget, currencyCode: "USD" }) .build() .getResult(); // 5. (Optional) Create Ad Groups, Keywords, Ads based on Spreadsheet Data } }
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter