【FANZA対応】googleスプレッドシートから動画付きツイートを自動投稿するTweetBotの作り方

function myFunction() {

const twitterService = getService();
const sample_movie_url = 'https://cc3001.dmm.co.jp/litevideo/freepv/4/422/422base00035/422base00035_sm_s.mp4';
const content　= 'これはテスト投稿です';

  if (twitterService.hasAccess()) {

    const endpoint_status = 'https://api.twitter.com/1.1/statuses/update.json';
    const endpoint_media  = 'https://upload.twitter.com/1.1/media/upload.json';

    //動画の取得
    const movie_blob = UrlFetchApp.fetch(sample_movie_url).getBlob();
    const movie_file_size = movie_blob.getBytes().length;
    console.log(movie_file_size);
    const movie_64  = Utilities.base64Encode(movie_blob.getBytes());
    const movie_64_file_size = movie_64.length;
    console.log(movie_64_file_size);

    //INIT
    const movie_init_option = { 
      'method' : "POST", 
      'payload': {
        'command':'INIT',
        'media_type':'video/mp4',
        'media_category':"tweet_video", //30秒超え対策
        'total_bytes':movie_file_size
      } 
    };

    const movie_init = JSON.parse(twitterService.fetch(endpoint_media, movie_init_option)); 
    console.log(movie_init);
    
    //APPEND
    const segment_index = 0;
    const bytes_sent = 0;
    const chunk_size = 1000000;
    const chunk_num = Math.ceil(movie_64_file_size / chunk_size);
    for (let index = 0; index < chunk_num; index++) {
      const chunk = movie_64.slice(chunk_size * index, chunk_size * (index + 1));
      console.log(chunk.length);
      const movie_append_option = { 
        'method' : "POST",
        "muteHttpExceptions" : true,
        'payload': {
            'command':'APPEND',
            'media_data':chunk,
            'media_id':movie_init['media_id_string'],
            'segment_index':index
        } 
      };
      twitterService.fetch(endpoint_media, movie_append_option); 
    }

    //FINALIZE
    const movie_finalize_option = { 
      'method' : "POST", 
      "muteHttpExceptions" : true,
      'payload': {
        'command':'FINALIZE',
        'media_id':movie_init['media_id_string']
      } 
    };
    const movie_finalize = JSON.parse(twitterService.fetch(endpoint_media, movie_finalize_option)); 
    console.log(movie_finalize);
    
    // STATUS
    while (true) {
      var movie_status_option = { 'method':"GET" };
      var movie_status = JSON.parse(twitterService.fetch(endpoint_media+"?command=STATUS&media_id="+movie_init['media_id_string'], movie_status_option));
      console.log(movie_status);
      if (movie_status["processing_info"]["state"] == "succeeded") {
        break;
      } else if (movie_status["processing_info"]["state"] == "failed") {
        sheet.getRange(i, 14).setValue(movie_status["processing_info"]["error"]["message"]);
        throw new Error(movie_status["processing_info"]["error"]["message"]);
      } else {
        Utilities.sleep(movie_status["processing_info"]["check_after_secs"] + 1);
      }
    };

    // tweet
    const movie_tweet_option = { 
      'method' : "POST", 
      "muteHttpExceptions" : true,
      'payload': {
        'status':content,
        'media_ids':movie_init['media_id_string']
      } 
    };

    const tweet = JSON.parse(twitterService.fetch(endpoint_status, movie_tweet_option));
    console.log(tweet);
  } else {
    Logger.log(service.getLastError());
  }
}

// サービス取得
function getService() {
  return OAuth1.createService('サービス名')
    .setAccessTokenUrl('https://api.twitter.com/oauth/access_token')
    .setRequestTokenUrl('https://api.twitter.com/oauth/request_token')
    .setAuthorizationUrl('https://api.twitter.com/oauth/authorize')
    .setConsumerKey(PropertiesService.getScriptProperties().getProperty("CONSUMER_API_KEY"))
    .setConsumerSecret(PropertiesService.getScriptProperties().getProperty("CONSUMER_API_SECRET"))
    .setAccessToken("1323717410482909184-r7CiM0WpDzMaT9m9rQrba1AswRcSXw", "L54jND63Y2e5qAjMh8IcDUrhPBNhQrDJ2U7VaXoM3gyeh")
    .setCallbackFunction('authCallback')
    .setPropertyStore(PropertiesService.getUserProperties());
}