https://script.google.com/macros/d/{スクリプトID}/usercallback

1B7FSrk5Zi6L1rSxxTDgDEUsPzlukDsi4KGuTMorsTQHhGBzBkMun4iDF

function getService() {
  pkceChallengeVerifier();
  const userProps = PropertiesService.getUserProperties();
  const scriptProps = PropertiesService.getScriptProperties();
  const clientId = scriptProps.getProperty('CLIENT_ID');
  const clientSecret = scriptProps.getProperty('CLIENT_SECRET');

  return OAuth2.createService('twitter')
    .setAuthorizationBaseUrl('https://twitter.com/i/oauth2/authorize')
    .setTokenUrl('https://api.twitter.com/2/oauth2/token?code_verifier=' + userProps.getProperty("code_verifier"))
    .setClientId(clientId)
    .setClientSecret(clientSecret)
    .setCallbackFunction('authCallback')
    .setPropertyStore(userProps)
    .setScope('users.read tweet.read tweet.write offline.access')
    .setParam('response_type', 'code')
    .setParam('code_challenge_method', 'S256')
    .setParam('code_challenge', userProps.getProperty("code_challenge"))
    .setTokenHeaders({
      'Authorization': 'Basic ' + Utilities.base64Encode(clientId + ':' + clientSecret),
      'Content-Type': 'application/x-www-form-urlencoded'
    })
}

function authCallback(request) {
  const service = getService();
  const authorized = service.handleCallback(request);
  if (authorized) {
    return HtmlService.createHtmlOutput('Success!');
  } else {
    return HtmlService.createHtmlOutput('Denied.');
  }
}

function pkceChallengeVerifier() {
  var userProps = PropertiesService.getUserProperties();
  if (!userProps.getProperty("code_verifier")) {
    var verifier = "";
    var possible = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-._~";

    for (var i = 0; i < 128; i++) {
      verifier += possible.charAt(Math.floor(Math.random() * possible.length));
    }

    var sha256Hash = Utilities.computeDigest(Utilities.DigestAlgorithm.SHA_256, verifier)

    var challenge = Utilities.base64Encode(sha256Hash)
      .replace(/\\+/g, '-')
      .replace(/\\//g, '_')
      .replace(/=+$/, '')
    userProps.setProperty("code_verifier", verifier)
    userProps.setProperty("code_challenge", challenge)
  }
}

function logRedirectUri() {
  var service = getService();
  Logger.log(service.getRedirectUri());
}

function main() {
  const service = getService();
  if (service.hasAccess()) {
    Logger.log("Already authorized");
  } else {
    const authorizationUrl = service.getAuthorizationUrl();
    Logger.log('Open the following URL and re-run the script: %s', authorizationUrl);
  }
}

function insertSheet([followers_count, following_count, tweet_count, listed_count, like_count]) {
  const scriptProps = PropertiesService.getScriptProperties();
  const sheetID = scriptProps.getProperty('SHEET_ID');
  const file = SpreadsheetApp.openById(sheetID)
  const sheet = file.getSheetByName("TwitterUserAnalytics")
  const date = Utilities.formatDate(new Date(), 'JST', 'yyyy-MM-dd');

  sheet.appendRow([date, followers_count, following_count, tweet_count, listed_count, like_count])
}

const endpointMe = "https://api.twitter.com/2/users/me?user.fields=public_metrics";

function getUserMe() {
  let service = getService();
  if (service.hasAccess()) {

    const response = UrlFetchApp.fetch(endpointMe, {
      method: "get",
      headers: {
        Authorization: 'Bearer ' + service.getAccessToken()
      },
      muteHttpExceptions: true,

      contentType: "application/json"
    });

    const result = JSON.parse(response.getContentText());

    const public_metrics = result["data"]["public_metrics"]
    insertSheet([public_metrics["followers_count"], public_metrics["following_count"], public_metrics["tweet_count"], public_metrics["listed_count"], public_metrics["like_count"]])

  } else {
    Logger.log("Not Authorized");
    return null;
  }
}

{
  "data": {
    "id": "xxxxxxxxxxxxxxxxx",
    "username": "RyuReina_Tech",
    "name": "龍：Ryu",
    "public_metrics": {
      "followers_count": 0,
      "following_count": 0,
      "tweet_count": 0,
      "listed_count": 0,
      "like_count": 0
    }
  }
}