Bulk upload

  • This script provides functionalities to bulk upload data into Google Ads from various sources like Google Drive, remote servers, and Google Sheets.

  • It utilizes Google Ads Scripts' bulk upload feature to manage and update campaigns, using CSV or spreadsheet files formatted according to specified templates.

  • The examples demonstrate how to preview changes before applying them, ensuring accuracy in bulk operations.

  • The script allows creation or updating of existing campaigns by providing the necessary campaign details like name, budget, bid strategy, and type.

  • Before execution, users should consult the provided link for understanding supported bulk upload templates and their required column names.

Bulk upload from Google Drive

function bulkUploadFromGoogleDrive() {
  // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload
  // for the list of supported bulk upload templates.
  // You can upload a CSV file, or an EXCEL sheet.
  const file = DriveApp.getFilesByName('BulkCampaignUpload.csv').next();
  const upload = AdsApp.bulkUploads().newFileUpload(file);
  upload.forCampaignManagement();

  // Use upload.apply() to make changes without previewing.
  upload.preview();
}

Bulk upload from remote server

function bulkUploadFromRemoteServer(csvFileUrl) {
  // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload
  // for the list of supported bulk upload templates.
  const blob = UrlFetchApp.fetch(csvFileUrl)
      .getBlob()
      .getAs(MimeType.CSV);

  const upload = AdsApp.bulkUploads().newFileUpload(blob);
  upload.forCampaignManagement();

  // Use upload.apply() to make changes without previewing.
  upload.preview();
}

Bulk upload from Google Sheets

function bulkUploadFromGoogleSpreadsheet(spreadsheetUrl) {
  // The format of this spreadsheet should match a valid bulk upload template.
  // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload
  // for the list of supported bulk upload templates.
  const spreadSheet = SpreadsheetApp.openByUrl(spreadsheetUrl);
  const sheet = spreadSheet.getActiveSheet();

  const upload = AdsApp.bulkUploads().newFileUpload(sheet);
  upload.forCampaignManagement();

  // Use upload.apply() to make changes without previewing.
  upload.preview();
}

Create/update campaigns

function createOrUpdateCampaigns() {
  // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload
  // for the list of supported bulk upload templates and their column names.
  const columns = [
    'Campaign', 'Budget', 'Bid Strategy type', 'Campaign type'
  ];

  const upload = AdsApp.bulkUploads().newCsvUpload(
      columns, {moneyInMicros: false});

  // Google Ads identify existing campaigns using its name. To create a new
  // campaign, use a campaign name that doesn't exist in your account.
  upload.append({
    'Campaign': 'Test Campaign 1',
    'Budget': 234,
    'Bid Strategy type': 'cpc',
    'Campaign type': 'Search Only'
  });
  // Use upload.apply() to make changes without previewing.
  upload.preview();
}