Tag Archives: Google Apps Script

Export Tweets from Twitter with Google Apps Script

The Twitter Archiver app will archive tweets for any hashtag to a Google Spreadsheet using the Twitter API and Google Apps Script.

You can set a time-based trigger to run downloadTweets() every 5 minutes or even 1 minute for hash tags that are extremely popular.

How to Learn Google Apps Script

The best resource for learning Google Script is the official documentation available at developers.google.com. Here are other learning resources where you can get up to speed using Google Apps Script.

Also see: How to Learn Programming Online

  1. Awesome Google Scripts by +Amit Agarwal
  2. Case Studies – Sample Google Script Projects (google.com)
  3. Google Apps Scripts – Snippets
  4. scoop.it/t/gas by +Martin Hawksey
  5. O’Reilly – Apps Script – by +James Ferreira
  6. Apps Script Webinars – YouTube – by +Eric Koleda
  7. scriptsexamples – by +James Ferreira +Romain Vialard
  8. StackOverflow Q&A – Got a question? Ask here.
  9. lynda.com – Scott Simpson (Up and Running with Google Scripts)
  10. Tutorial – Written Google Docs Addons
  11. Known Issues & Bugs – Report a bug here.

This list is maintained by Amit Agarwal. Send me a tweet @labnol to suggest another resource.

Sell Digital Downloads with Google Scripts

You can set up your own digital shop on the Internet with the help of PayPal and Google Scripts. You upload your file on Google Drive, the buyer makes a purchase through PayPal and Google Apps Script will deliver the file to the buyer through Gmail.

See: Sell Digital Products Online

Delete Old Tweets Automatically with Google Scripts

The Google Script will read your Twitter timeline and auto-delete tweets that are older than ‘n’ days excepts the ones that are retweets or favorited.

You can run this function Delete_Old_Tweets manually in the Google Apps Script editor or setup a time-based trigger to keep your Twitter profile void of any old tweets. The author of the script is unknown.

Cleanup your Gmail Inbox with Apps Script

The Google Script will automatically archive all the messages in your Gmail inbox that are older than 2 days. You can either use a Gmail search filter to find read messages or you can compare the message date with the current date through the script and archive messages accordingly.

Write Gmail Filters with Google Apps Script

The Google Script uses regular expressions to create advanced Gmail filters that works just like the native filters of Gmail but are more powerful at parsing email.