How to Send Tweets with Google Scripts and Twitter API

October 16, 2017

This example shows how you can setup your own Twitter Client using Google Apps Script and publish tweets programmatically from inside a Google Document, a spreadsheet or even a web app.

To get started, go to apps.twitter.com and create a new Twitter application. Switch to Keys and Access Tokens tab and generate your Access Token and Secret. This will help you send tweets from your Twitter account without manual authorization. Next in the Apps Script project, include the Twitter library (key: MKvHYYdYA4G5JJHj7hxIcoh8V4oX7X1M_) with the identifier set to Twitter.

function sendTweet(status) {
  status = status || "I found this snippet on @labnol's ctrlq.org";

  var twitterKeys = {
    TWITTER_CONSUMER_KEY: '<<consumer key>>',
    TWITTER_CONSUMER_SECRET: '<<consumer secret>>',
    TWITTER_ACCESS_TOKEN: '<<access token>>',
    TWITTER_ACCESS_SECRET: '<<access secret>>',
  };

  var props = PropertiesService.getScriptProperties();

  props.setProperties(twitterKeys);

  var service = new Twitter.OAuth(props);

  if (service.hasAccess()) {
    var response = twit.sendTweet(status);

    if (response) {
      Logger.log('Tweet ID ' + response.id_str);
    } else {
      // Tweet could not be sent
      // Go to View -> Logs to see the error message
    }
  }
}

Google Apps Script Twitter

ShareWhatsAppTwitterFacebook

Amit Agarwal

Google Developer Expert, Google Cloud Champion

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory