AdsApp.BulkUploads
Stay organized with collections
Save and categorize content based on your preferences.
outlined_flag
Provides methods to create CSV and general file uploads for bulk operations.
newCsvUpload
creates a CSV upload with specified column headers, supporting optional arguments like file locale, money representation, and time zone.
newFileUpload
facilitates uploading data from Google Sheets, Drive files (.csv, .tsv, .xls, .xlsx), or Blobs with supported MIME types, also with optional arguments for locale, money, and time zone.
Optional arguments for both upload methods allow customization for parsing numbers, dates, and currency values.
Access to bulk uploads:
FileUpload ,
CsvUpload .
Methods:
newCsvUpload(columnNames, optArgs)
Creates a
CsvUpload with the given
column headers.
This method accepts an optional arguments object. The following optional
arguments are supported:
Name Type Description
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.
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:
Name Type Description
columnNames
String[]
The names of column headers.
optArgs
Object
Optional arguments.
Return values:
Type Description
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:
Name Type Description
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.
Arguments:
Name Type Description
sheet
SpreadsheetApp.Sheet
The Sheet in Google Spreadsheet to be uploaded.
optArgs
Object
Optional arguments.
Return values:
Type Description
AdsApp.FileUpload
A Bulk Upload with the content in the given Google Sheet.
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:
Name Type Description
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.
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:
Name Type Description
file
DriveApp.File
The File in Drive to be uploaded.
optArgs
Object
Optional arguments.
Return values:
Type Description
AdsApp.FileUpload
A Bulk Upload with the content in the given File in Drive.
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:
Name Type Description
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.
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:
Name Type Description
blob
Blob.Blob
The Blob in Drive to be uploaded.
optArgs
Object
Optional arguments.
Return values:
Type Description
AdsApp.FileUpload
A Bulk Upload with the content in the given Blob in Drive.