Apps 指令碼執行

/**  * Executes an Apps Script function in a remote Apps Script.  * See: https://developers.google.com/google-ads/scripts/docs/features/third-party-apis#refresh_token_grant  * for details on configuring this script.  *  * NOTE: This script also requires the OAuth2 library to be pasted at the end,  * as obtained from https://developers.google.com/google-ads/scripts/docs/examples/oauth20-library  */ const CLIENT_ID = 'INSERT_CLIENT_ID'; const CLIENT_SECRET = 'INSERT_CLIENT_SECRET'; const REFRESH_TOKEN = 'INSERT_REFRESH_TOKEN'; // Enter scopes which should match scopes in File > Project properties // For this project, e.g.: https://www.googleapis.com/auth/drive const SCOPES = 'ENTER_SPACE_DELIMITED_SCOPES'; // Script ID taken from 'File > Project Properties' const SCRIPT_ID = 'ENTER_SCRIPT_ID';  let authUrlFetch;  // Call this function just once, to initialize the OAuth client. function initializeOAuthClient() {   if (typeof OAuth2 === 'undefined') {     const libUrl = 'https://developers.google.com/google-ads/scripts/docs/examples/oauth20-library';     throw Error(`OAuth2 library not found. Please take a copy of the OAuth2 ` +         `library from ${libUrl} and append to the bottom of this script.`);   }   const tokenUrl = 'https://accounts.google.com/o/oauth2/token';   authUrlFetch = OAuth2.withRefreshToken(tokenUrl, CLIENT_ID, CLIENT_SECRET,     REFRESH_TOKEN, SCOPES); }  /**  * Execute a remote function.  * @param {string} remoteFunctionName The name of the function to execute.  * @param {Object[]} functionParams An array of JSON objects to pass to the  *     remote function.  * @return {?Object} The return value from the function.  */ function executeRemoteFunction(remoteFunctionName, functionParams) {   const apiParams = {     'function': remoteFunctionName,     'parameters': functionParams   };   const httpOptions = {     method: 'POST',     headers: {       'Content-Type': 'application/json'     },     payload: JSON.stringify(apiParams)   };   const url = `https://script.googleapis.com/v1/scripts/${SCRIPT_ID}:run`;   const response = authUrlFetch.fetch(url, httpOptions);   const data = JSON.parse(response.getContentText());   // Retrieve the value that has been returned from the execution.   if (data.error) {     throw Error(`There was an error: ${response.getContentText()}`);   }   return data.response.result; }  // Paste in OAuth2 library here, from: // https://developers.google.com/google-ads/scripts/docs/examples/oauth20-library