Yahoo! JAPAN Ads Script | Developer Center

Read actions for files and folders created outside of Yahoo! JAPAN Ads Scripts on Google Drive.

Functions that will no longer be available:
DriveApp get system processing

DriveApp.getFileById
DriveApp.getFiles
DriveApp.getFilesByName
DriveApp.getFilesByType
DriveApp.getFolderById
DriveApp.getFolders
DriveApp.getFoldersByName
DriveApp.getRootFolderDriveApp.getRootFolder

* The following processes are still available.

• Read files and folders created by Yahoo! JAPAN Ads Script
• Creating files and folders directly under My Drive
• Read, update, and create new spreadsheets directly in My Drive (using SpreadsheetApp)

Read and write fixed spreadsheets

Example function:
Working with Spreadsheets with SpreadsheetApp

SpreadsheetApp.create
SpreadsheetApp.openById
SpreadsheetApp.openByUrl

■ Actions
Processes data from reports and other documents into csv format strings and creates files under specified folders.

■Script

const folderId = 'Folder ID'; // ID of the folder where we want to store the file
const fileContent = ''; // Generate comma separated string from report data
const fileName = 'test'; const folder = DriveApp.getFolderById(folderId);
const blob = Utilities.newBlob(fileContent, 'text/csv', fileName);
folder.createFile(blob); 

Case 1: Change to spreadsheet output
■Script

const spreadsheetId = 'Spreadsheet ID';
const sheetName = 'Sheet1';
const ss = SpreadsheetApp.openById(spreadsheetId);
let sh = ss.getSheetByName(sheetName);
sh.clear();
const reportData = AdsUtilities.getDisplayReport({
  // Define the report you want to get
}).reports[0].rows;
sh.getRange('A1').setValues(reportData);

Reference:

• Sample Script - Google Sheets
• Solution - Basic reporting
  
  

Case 2: Change to file output directly under My Drive
■Script

const fileContent = ''; // Comma separated string
const fileName = 'test';

const blob = Utilities.newBlob(fileContent, 'text/csv', fileName);
const file = DriveApp.createFile(blob); 

* By setting DriveApp.createFile instead of createFile for folder, a file will be created directly under My Drive. 

Reference:

• Sample Script - Google Drive

■ Actions
Get files with a specific name under a specified folder.

■Script

const folderId = 'Folder ID'; // Target Folder ID
const fileName = 'filename'; // target file name
const files = DriveApp.getFolderById(folderId).getFilesByName(fileName);
while (files.hasNext()) {
  const file = files.next();
  const fileData = file.getBlob().getBytes();
  // Action on file
}

■ Actions
Retrieve files with specific file names from across Google Drive.

■Script

const fileName = 'filename'; // target file name
const files =  DriveApp.getFilesByName(fileName);
while (files.hasNext()) {
  const file = files.next();
  const fileData = file.getBlob().getBytes();
  // Action on file
}

■ Actions
Get a file by specifying a specific file ID.

■Script

const fileId = 'fileid'; // target fileid
const file = DriveApp.getFileById(fileId);
const fileData = file.getBlob().getBytes();

* If you are using the retrieved file to perform an automatic upload (Search.OfflineConversionService.upload() or Display.AudienceListService.uploadUserList()).

Prepare a spreadsheet and change its spreadsheet ID to the specified data acquisition.
If you get the list on a regular basis, please update the prepared spreadsheet with the latest information prior to the script periodic run. Then retrieve the contents of the relevant spreadsheet from the script.

When to get a list on a regular basis: offline conversions, uploading an audience list, etc.

Reference:

Offline conversion

• Sample Script - Display Ads - Offline conversion
• Sample Script - Search Ads - Offline conversion
• Solution - Conversion import via Google Drive（available in Japanese)

Audience list

• Sample Script - Display Ad - Audience list
• Solution - Automatic upload of audience list (customer data)