Google Apps Script reuse

main.gs

function doPost(e) {
  log("Received doPost")
  try {
    const { chatId, text, update } = getUpdate(e)
    if (myChatId !== chatId)
      return sendMessage(chatId, `You are not authorized`)

    if (!isDocument(update))
      return sendMessage(chatId, `message is without document`)

    const fileUrl = HandleTelegrmFile(update.message.document, new Date(update.message.date * 1000))
    replyToSender(update, fileUrl)

  } catch (e) {
    log('error', JSON.stringify(e, Object.getOwnPropertyNames(e)))
    sendMessage(myChatId, JSON.stringify(e, Object.getOwnPropertyNames(e)))
    throw e
  }
}

telegram.gs

/**
 * Every time you changing something related to the Bot webhook, you have to
 * 1. Deploy as Webapp
 * 2. Copy the deployment URL
 * 3. Paste it here
 * 4. Run the setWebhook function
 */
const token = '<<Telegram Token>>'
const url = 'https://script.google.com/macros/s/*********/exec'
const myChatId = <<your chat id>>;
const telegramURL = `https://api.telegram.org/bot${token}`
const telegramFileUrl = `https://api.telegram.org/file/bot${token}`

function setWebhook() {
  const res = request('setWebhook', { url })
  Logger.log(res)
}

function request(method, data) {
  var options = {
    'method': 'post',
    'contentType': 'application/json',
    'payload': JSON.stringify(data)
  };
  var response = UrlFetchApp.fetch(`${telegramURL}/${method}`, options);
  if (response.getResponseCode() == 200) {
    return JSON.parse(response.getContentText());
  }
  return false;
}

/**
 * https://core.telegram.org/bots/api#update
 * 
 * @return {{
 *   chatId: number,
 *   text: string,
 *   update: Update
 * }}
 */
function getUpdate(doPostE) {
  // Make sure to only reply to json requests
  if (doPostE.postData.type == "application/json") {

    // Parse the update sent from Telegram
    const update = JSON.parse(doPostE.postData.contents);
    const text = update.message.text
    log(`Message: ${text}`)

    return {
      chatId: update.message.from.id,
      text,
      update
    }
  }
}

function replyToSender(update, text) {
  sendMessage(update.message.from.id, text)
}

function sendMessage(chatId, text, parse_mode) {
  return request('sendMessage', {
    'chat_id': chatId,
    'text': text,
    parse_mode,
  });
}

/**
 * @param update {Update}
 */
function isDocument(update) {
  return !!update.message.document
}

function DownloadFile(fileId) {
  const response = UrlFetchApp.fetch(`${telegramURL}/getFile?file_id=${fileId}`);
  if (response.getResponseCode() != 200) {
    log('getFile', 'response', response.getResponseCode())
    throw new Error()
  }
  const parsed = JSON.parse(response.getContentText())
  log('parsed', parsed)

  const urlFile = `${telegramFileUrl}/${parsed.result["file_path"]}`;

  log('urlFile', urlFile)
  const resa = UrlFetchApp.fetch(urlFile);
  const blob = resa.getBlob();
  return blob;
}

twitter.gs

/*
callback url:                                                   

Click on File > Project properties and copy the value from 'Project key' 
your callback url will be: 
      
  https://script.google.com/macros/d/[Project key]/usercallback 

copy this url and paste it in your app on the Twitter developer dashboard:
      
  https://developer.twitter.com/
      
you should also paste it in the code here, line 18;
*/

var consumer_key = "****"
var consumer_secret = "****"
var project_key = "****" // File > Project properties > Project key


function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Twitter')
    .addItem('Tweet test text', 'sendTestTweet')
    .addItem('revoke', 'authorizationRevoke')
    .addItem('show my callBack url', 'getCallBackUrl')
    .addToUi();
  msgPopUp('<p>Click on Tools > Script Editor and follow instructions</p>');
};

function sendTestTweet() {
  doTweet("hello world");
}

function authorizationRevoke() {
  var scriptProperties = PropertiesService.getScriptProperties();
  scriptProperties.deleteProperty('oauth1.twitter');
  msgPopUp('<p>Your Twitter authorization credentials have been deleted. You\'ll need to re-run "Send a Test Tweet" to reauthorize before you can start posting again.');
}

function getTwitterService() {
  var service = OAuth1.createService('twitter');
  service.setAccessTokenUrl('https://api.twitter.com/oauth/access_token');
  service.setRequestTokenUrl('https://api.twitter.com/oauth/request_token');
  service.setAuthorizationUrl('https://api.twitter.com/oauth/authorize');
  service.setConsumerKey(consumer_key);
  service.setConsumerSecret(consumer_secret);
  service.setCallbackFunction('authCallback');
  service.setPropertyStore(PropertiesService.getScriptProperties());
  const x = PropertiesService.getScriptProperties();
  return service;
}

function authCallback(request) {
  var service = getTwitterService();
  var isAuthorized = service.handleCallback(request);
  if (isAuthorized) {
    return HtmlService.createHtmlOutput('Success! You can close this page.');
  } else {
    return HtmlService.createHtmlOutput('Denied. You can close this page');
  }
}

function msgPopUp(msg) {
  var content = '<div style="font-family: Verdana;font-size: 22px; text-align:left; width: 95%; margin: 0 auto;">' + msg + '</div>';
  var htmlOutput = HtmlService
    .createHtmlOutput(content)
    .setSandboxMode(HtmlService.SandboxMode.IFRAME)
    .setWidth(600)
    .setHeight(500);
  SpreadsheetApp.getUi().showModalDialog(htmlOutput, ' ');

}

function twitterAPIRequest(url, parameters) {
  var service = getTwitterService();
  if (!service.hasAccess()) {
    var authorizationUrl = service.authorize();
    msgPopUp('<p>Please visit the following URL and then re-run "Send a Test Tweet": <br/> <a target="_blank" href="' + authorizationUrl + '">' + authorizationUrl + '</a></p>');
    return;
  }
  var result = service.fetch("https://api.twitter.com" + url, parameters);
  return JSON.parse(result.getContentText());
}

/**
 * @param tweet {string}
 * @return {string}
 */
function doTweet(tweet) {
  var id_str = "";
  var url = "/1.1/statuses/update.json";
  var payload = "status=" + fixedEncodeURIComponent(tweet);
  var parameters = {
    "method": "POST",
    "escaping": false,
    "payload": payload
  };

  try {
    var result = twitterAPIRequest(url, parameters);
    id_str = result.id_str;

  }
  catch (e) {
    Logger.log(e.toString());
    throw e
  }
  return id_str;
}

/**
 * @param tweet {string}
 * @param status_id {string|number}
 * @return {string}
 */
function doReply(tweet, status_id) {
  var url = '/1.1/statuses/update.json';
  var payload = {
    "in_reply_to_status_id": status_id,
    "auto_populate_reply_metadata": true,
    "status": tweet
  }
  var parameters = {
    "method": "POST",
    "escaping": false,
    "payload": payload
  };

  const result = twitterAPIRequest(url, parameters);
  Logger.log(result);

  return result.id_str;
}

function fixedEncodeURIComponent(str) {
  return encodeURIComponent(str).replace(/[!'()*]/g, function (c) {
    return '%' + c.charCodeAt(0).toString(16);
  });
}

Don't know, it is more related to the Telegram API than Google Sheets.

https://stackoverflow.com/a/72070240/839513