Bulk upload

  • The content demonstrates how to perform bulk uploads to Google Ads using Google Drive, a remote server, or Google Sheets.

  • Supported bulk upload templates for CSV or Excel files are mentioned.

  • The examples show how to use AdsApp.bulkUploads().newFileUpload() and AdsApp.bulkUploads().newCsvUpload().

  • The preview() method is used in the examples, with a note about using apply() for direct changes.

  • A specific example shows how to create or update campaigns using a CSV upload with defined columns.

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(); }