This is the legacy documentation for Google Ads scripts. Go to the current docs.

AdsApp.​BulkUploads

Stay organized with collections Save and categorize content based on your preferences.
Access to bulk uploads: FileUpload, CsvUpload.

Methods:

MemberTypeDescription
newCsvUpload AdsApp.CsvUpload Creates a CsvUpload with the given column headers.
newFileUpload AdsApp.FileUpload Creates a FileUpload with the given Google Sheet.
newFileUpload AdsApp.FileUpload Creates a FileUpload with the content in the given Blob.
newFileUpload AdsApp.FileUpload Creates a FileUpload with the content in the given File in Drive.

newCsvUpload(columnNames, optArgs)

Creates a CsvUpload with the given column headers.

This method accepts an optional arguments object. The following optional arguments are supported:

NameTypeDescription
fileLocale String File locale, specified in ISO format. Affects how numbers and dates are parsed. Defaults to en_US. See a full list in Supported Locales.
moneyInMicros boolean Whether or not to represent money in micros ('1370000') or in currency ('1.37'). Defaults to true.
timeZone String The time zone to use for dates. No default. The following formats are supported:
  • A timezone in tz database (e.g. America/Los_Angeles etc.). See a full list in List of tz database time zones;
  • Standard offsets in the form [+-]hhmm (e.g. +0800, -0500).
NOTE: this field is required for offline conversion uploads.
useLegacyUploads boolean When false, uses a new enhanced upload experience to match the UI. This gives access to new features such as the ability to change Labels and manipulate manager accounts. For full details, see the upload documentation. Defaults to false for the updated upload behavior.

Example usages: 

 // Creates a CsvUpload with 3 columns named 'columnA', 'columnB' and 'columnC', respectively.
 var upload1 = AdsApp.bulkUploads().newCsvUpload(
     ['columnA', 'columnB', 'columnC']);

 // Creates a CsvUpload which represents money in currency (e.g. 1.37) instead of in micros
 // (e.g. 137000).
 var upload2 = AdsApp.bulkUploads().newCsvUpload(
     ['columnA', 'columnB', 'columnC'], {
       moneyInMicros: false
     });

Arguments:

NameTypeDescription
columnNames String[] The names of column headers.
optArgs Object Optional arguments.

Return values:

TypeDescription
AdsApp.CsvUpload A CSV Bulk Upload with the given column headers, ready to have data appended.

newFileUpload(sheet, optArgs)

Creates a FileUpload with the given Google Sheet.

This method accepts an optional arguments object. The following optional arguments are supported:

NameTypeDescription
fileLocale String File locale, specified in ISO format. Affects how numbers and dates are parsed. Defaults to en_US. See a full list in Supported Locales.
moneyInMicros boolean Whether or not to represent money in micros ('1370000') or in currency ('1.37'). Defaults to true.
timeZone String The time zone to use for dates. No default. The following formats are supported:
  • A timezone in tz database (e.g. America/Los_Angeles etc.). See a full list in List of tz database time zones;
  • Standard offsets in the form [+-]hhmm (e.g. +0800, -0500).
NOTE: this field is required for offline conversion uploads.
useLegacyUploads boolean When false, uses a new enhanced upload experience to match the UI. This gives access to new features such as the ability to change Labels and manipulate manager accounts. For full details, see the upload documentation. Defaults to false for the updated upload behavior.

Arguments:

NameTypeDescription
sheet SpreadsheetApp.Sheet The Sheet in Google Spreadsheet to be uploaded.
optArgs Object Optional arguments.

Return values:

TypeDescription
AdsApp.FileUpload A Bulk Upload with the content in the given Google Sheet.

newFileUpload(blob, optArgs)

Creates a FileUpload with the content in the given Blob.

This method only accepts Blobs with supported MIME types (CSV, MICROSOFT_EXCEL, MICROSOFT_EXCEL_LEGACY).

This method accepts an optional arguments object. The following optional arguments are supported:

NameTypeDescription
fileLocale String File locale, specified in ISO format. Affects how numbers and dates are parsed. Defaults to en_US. See a full list in Supported Locales.
moneyInMicros boolean Whether or not to represent money in micros ('1370000') or in currency ('1.37'). Defaults to true.
timeZone String The time zone to use for dates. No default. The following formats are supported:
  • A timezone in tz database (e.g. America/Los_Angeles etc.). See a full list in List of tz database time zones;
  • Standard offsets in the form [+-]hhmm (e.g. +0800, -0500).
NOTE: this field is required for offline conversion uploads.
useLegacyUploads boolean When false, uses a new enhanced upload experience to match the UI. This gives access to new features such as the ability to change Labels and manipulate manager accounts. For full details, see the upload documentation. Defaults to false for the updated upload behavior.

Example usages: 

 // Creates a bulk upload with the content fetched from url.
 var url = "www.example.com/content.csv";
 var blob = UrlFetchApp.fetch(url).getAs(MimeType.CSV);
 var upload = AdsApp.bulkUploads().newFileUpload(blob);

Arguments:

NameTypeDescription
blob Blob.Blob The Blob in Drive to be uploaded.
optArgs Object Optional arguments.

Return values:

TypeDescription
AdsApp.FileUpload A Bulk Upload with the content in the given Blob in Drive.

newFileUpload(file, optArgs)

Creates a FileUpload with the content in the given File in Drive.

This method only accepts files in supported formats (.csv, .tsv, .xls, .xlsx).

This method accepts an optional arguments object. The following optional arguments are supported:

NameTypeDescription
fileLocale String File locale, specified in ISO format. Affects how numbers and dates are parsed. Defaults to en_US. See a full list in Supported Locales.
moneyInMicros boolean Whether or not to represent money in micros ('1370000') or in currency ('1.37'). Defaults to true.
timeZone String The time zone to use for dates. No default. The following formats are supported:
  • A timezone in tz database (e.g. America/Los_Angeles etc.). See a full list in List of tz database time zones;
  • Standard offsets in the form [+-]hhmm (e.g. +0800, -0500).
NOTE: this field is required for offline conversion uploads.
useLegacyUploads boolean When false, uses a new enhanced upload experience to match the UI. This gives access to new features such as the ability to change Labels and manipulate manager accounts. For full details, see the upload documentation. Defaults to false for the updated upload behavior.

Example usages: 

 // Creates a Bulk upload from an .xls file under the given Drive folder.
 var files = DriveApp.getFolderById("folder_id").getFilesByType(MimeType.MICROSOFT_EXCEL);
 if (files.hasNext()) {
   var file = files.next();
   var upload = AdsApp.bulkUploads().newFileUpload(file);
 }

Arguments:

NameTypeDescription
file DriveApp.File The File in Drive to be uploaded.
optArgs Object Optional arguments.

Return values:

TypeDescription
AdsApp.FileUpload A Bulk Upload with the content in the given File in Drive.