YouTube動画管理自動化プロジェクト

const CLIENT_ID = 'YOUR_CLIENT_ID_HERE';
const CLIENT_SECRET = 'YOUR_CLIENT_SECRET_HERE';

/**
 * OAuth2サービスを作成して返す関数
 * @returns {OAuth2Service} YouTube 用のOAuth2サービスオブジェクト
 */
function setupOAuthService() {
  return OAuth2.createService('youtube')
      .setAuthorizationBaseUrl('https://accounts.google.com/o/oauth2/auth')
      .setTokenUrl('https://accounts.google.com/o/oauth2/token')
      .setClientId(CLIENT_ID)
      .setClientSecret(CLIENT_SECRET)
      .setCallbackFunction('authCallback')
      .setPropertyStore(PropertiesService.getUserProperties())
      .setScope('https://www.googleapis.com/auth/youtube')
      .setParam('access_type', 'offline')
      .setParam('prompt', 'consent')
      .setCache(CacheService.getUserCache());
}

/**
 * OAuth2サービスを利用してアクセストークンを取得する関数
 * @returns {string|null} アクセストークンまたはnull（取得できなかった場合）
 */
function getAccessToken() {
  const service = setupOAuthService();
  
  if (!service.hasAccess()) {
    Logger.log('リフレッシュトークンがありません。認証が必要です。');
    service.reset();
    return null;
  }

  let accessToken = service.getAccessToken();

  if (!accessToken) {
    Logger.log('アクセストークンの取得に失敗しました。リフレッシュトークンを使用して再取得を試みます。');
    if (service.refresh()) {
      accessToken = service.getAccessToken();
      Logger.log('新しいアクセストークンを取得しました。');
    } else {
      Logger.log('アクセストークンの再取得に失敗しました。認証が必要です。');
      service.reset();
      return null;
    }
  }
  return accessToken;
}

function fetchVideos(maxResults = 50, totalResults = 50) { // 50件更新
  const sheet1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('シート1');
  const sheet2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('シート2');
  const accessToken = getAccessToken();
  let nextPageToken = '';
  let videoCount = 0;

  sheet1.clear();
  sheet1.appendRow(['曜日', '時間', '動画ID', 'YouTubeリンク', 'タイトル', 'アップロード年月日', '概要欄', 'タグ', '再生リストID']);

  while (videoCount < totalResults) {
    const searchUrl = `https://www.googleapis.com/youtube/v3/search?part=snippet&forMine=true&type=video&order=date&maxResults=${maxResults}&pageToken=${nextPageToken}`;
    const searchOptions = {
      headers: { Authorization: 'Bearer ' + accessToken },
      method: 'get',
      contentType: 'application/json',
      muteHttpExceptions: true
    };

    const searchResponse = UrlFetchApp.fetch(searchUrl, searchOptions);
    const searchResult = JSON.parse(searchResponse.getContentText());
    if (searchResult.error) {
      Logger.log('Error: ' + searchResult.error.message);
      return;
    }
    if (!searchResult.items) {
      Logger.log('Error: No items found in search results.');
      break;
    }

    searchResult.items.forEach(function(video) {
      if (videoCount >= totalResults) return;

      const videoId = video.id.videoId;
      const videoDetailsUrl = `https://www.googleapis.com/youtube/v3/videos?part=snippet,liveStreamingDetails&id=${videoId}`;
      const videoDetailsOptions = {
        headers: { Authorization: 'Bearer ' + accessToken },
        method: 'get',
        contentType: 'application/json',
        muteHttpExceptions: true
      };

      const videoDetailsResponse = UrlFetchApp.fetch(videoDetailsUrl, videoDetailsOptions);
      const videoDetails = JSON.parse(videoDetailsResponse.getContentText());
      if (videoDetails.error || !videoDetails.items || !videoDetails.items[0]) {
        Logger.log('Error retrieving video details: ' + (videoDetails.error ? videoDetails.error.message : 'No video details available'));
        return;
      }

      const snippet = videoDetails.items[0].snippet;
      const liveStreamingDetails = videoDetails.items[0].liveStreamingDetails;
      const actualStartTime = liveStreamingDetails && liveStreamingDetails.actualStartTime
                              ? new Date(liveStreamingDetails.actualStartTime)
                              : new Date(snippet.publishedAt);
      const dayOfWeek = Utilities.formatDate(actualStartTime, Session.getScriptTimeZone(), 'EEEE');
      const time = Utilities.formatDate(actualStartTime, Session.getScriptTimeZone(), 'HH:mm');
      const uploadDate = Utilities.formatDate(actualStartTime, Session.getScriptTimeZone(), 'yyyy/MM/dd');
      const title = snippet.title;
      const description = snippet.description;
      const tags = snippet.tags ? snippet.tags.join(', ') : '';
      const videoLink = `https://www.youtube.com/watch?v=${videoId}`;

      sheet1.appendRow([dayOfWeek, time, videoId, videoLink, title, uploadDate, description, tags, '']);
      videoCount++;
    });

    nextPageToken = searchResult.nextPageToken;
    if (!nextPageToken) break;
  }

  sheet2.clear();
  const range = sheet1.getDataRange();
  sheet2.getRange(1, 1, range.getNumRows(), range.getNumColumns()).setValues(range.getValues());
}

function updateVideoDetails() {
  const sheet2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("シート2");
  const lastRow = sheet2.getLastRow();
  const accessToken = getAccessToken();
  const categoryId = '22'; // カテゴリID

  for (let i = 2; i <= lastRow; i++) {
    const videoId = sheet2.getRange(i, 3).getValue();
    const title = sheet2.getRange(i, 5).getValue();
    const description = sheet2.getRange(i, 7).getValue();
    const tags = sheet2.getRange(i, 8).getValue();
    const playlistId = sheet2.getRange(i, 9).getValue();
    const tagsArray = tags ? tags.split(',').map(tag => tag.trim()).filter(tag => tag.length > 0) : [];

    const payload = {
      id: videoId,
      snippet: {
        title: title,
        description: description,
        tags: tagsArray,
        categoryId: categoryId
      }
    };

    const options = {
      headers: { Authorization: 'Bearer ' + accessToken },
      method: 'put',
      contentType: 'application/json',
      payload: JSON.stringify(payload),
      muteHttpExceptions: true
    };

    const response = UrlFetchApp.fetch("https://www.googleapis.com/youtube/v3/videos?part=snippet", options);
    Logger.log(response.getContentText());

    if (playlistId) {
      addToPlaylist(videoId, playlistId);
    }
  }

  /**
   * 指定の再生リストに動画を追加する関数
   * @param {string} videoId - 動画ID
   * @param {string} playlistId - 再生リストID
   */
  function addToPlaylist(videoId, playlistId) {
    const url = "https://www.googleapis.com/youtube/v3/playlistItems?part=snippet";
    const payload = {
      snippet: {
        playlistId: playlistId,
        resourceId: {
          kind: "youtube#video",
          videoId: videoId
        }
      }
    };
    const options = {
      headers: { Authorization: 'Bearer ' + accessToken },
      method: 'post',
      contentType: 'application/json',
      payload: JSON.stringify(payload),
      muteHttpExceptions: true
    };
    const response = UrlFetchApp.fetch(url, options);
    Logger.log(response.getContentText());
  }
}

function runAllProcesses() {
  const accessToken = getAccessToken();
  if (!accessToken) {
    Logger.log('アクセストークンの取得に失敗しました。処理を中断します。');
    return;
  }
  fetchVideos();           // 動画リストをシートに書き出し
  updateSheetFromConfig(); // Configシートの情報でシート2に上書き
  updateVideoDetails();    // シート2の情報でYouTube動画を更新
}