The most useful tools and tricks that you can implement with the help of Google Apps Script
Technologies / / December 19, 2019
Not all users know that as part of Google's web applications exist powerful tool for automation of work called Google Apps Script. In this article we briefly describe what it is, and will introduce you to the most useful scripts for email, calendar, and spreadsheet files.
Google Apps Script - a programming language based in JavaScript. With it, you can add additional features to Google Docs, Google Sheets, and Google Forms, as well as to process the data in Google Sheets. Moreover, with this language, you can even create your own applications that will interact not only with Google products, but also with other online services. Developers will find all the needed information on special help pagesAnd we move on to the promised list of useful tools, built using Google Apps Script.
- Files Permissions Explorer. Through accounts that have access to your shared files to Google Drive with the ability to change permissions.
- Google Form File Uploads. With this form, you will be able to receive files directly to Google Drive from any page in which it is embedded.
- Mail Merge with Gmail. Sending personalized email messages to their contacts through expansion gmail Merge.
- Send to Google Drive. Saving attachments from Gmail directly to Google Drive with the help of expansion Save Emails.
- Retweet & Favorite Bot. Boat for Twitter, written in the Google Scripts, which can automatically retweet suitable posts.
- gmail Autoresponder. The answer to one or more emails in Gmail using pre-built templates.
- Website Uptime Monitor. Receiving notifications via email and SMS, if your site is unavailable. You can free to monitor any site on the web.
- Amazon Price Tracker. Tracking changes in the prices of selected products on Amazon and receive notifications when the price falls or rises.
- gmail Unsubscriber. Automatic unsubscribing from mailing lists and promotional messages.
- Read Receipts in Gmail. Use the Apps Script and Google Analytics, to be notified when sent through Gmail messages are opened and read by the addressee.
- Advanced Gmail Filters. Additional functions for sorting incoming messages into Gmail.
- Send Google Spreadsheets as PDF. Converting your spreadsheet to PDF format and send specified contacts on schedule.
- Download Tweets Permanently. Specify any tag, and this script will automatically download and save the relevant tweets in the table.
- Schedule Gmail Emails. Write a letter and send it to any person designated by you while using Apps Script and the Google Sheets.
- Sell Digital Products Online. Use PayPal and Google Drive bundle to launch its own online digital store.
- Save Google Voicemails as MP3. This web application is automatically copied to your MP3 on the Google Voice calls from Gmail to Google Drive.
- Gravity Forms to Google Sheets. Launch the Google Script, which will save your values from the mold Gravity WordPress in Google Spreadsheet.
- gmail Encrypt. You can encrypt your emails in Gmail, using powerful algorithms AES-encryption, and no one can intercept your correspondence.
- 1-click Website Hosting. This Google Script can arrange hosting websites, images, podcasts and other files in Google Drive with one click.
- Google Web Scraping. Import Google search results in Google with the Spreadsheet using ImportXML analysis functions.
- Flipkart & Snapdeal Price Tracker. Track and compare prices on products listed in Flipkart and Snapdeal, and receiving the report by email.
- Bullk Tweets & DMs. You can send mass personalized tweets and private messages on Twitter, using the Google Spreadsheet.
- Save Gmail Images. This script keeps track of Gmail and automatically saves any image from Google Drive files attached to your inbox.
- Sort Gmail by Size. Handy when running low on space in Gmail. This script allows you to find the greatest messages in your email account.
- Bulk Forward Gmail. Automatic transfer only works normally with the new messages coming in to Gmail. But with the help of this script you will be able to organize a mass shipment even old messages.
- Update Google Contacts. This script allows your friends and family members to update their contact information directly into your Google address book.
- Google Contacts Map. Look at the location of all of your contacts from your address book on the Google map. It is possible to export data in KML format for viewing in Google Earth.
- Email Form Data. Google Forms - the best tool for creating online surveys and raffles. This script sends you the data as soon as someone fills out your form.
- Auto Confirmation Emails. Sending a confirmation letter after filling Google Forms user.
- Schedule Google Forms. Setting the validity period for Google Forms, which automatically closes the poll at the appointed time.
- twitter Bot. Learn how to create your own Twitter-bot that will automatically reply to tweets. This particular bot asks Wolfram Alpha to answer queries.
- WordPress Authentication with Google Scripts. This script allows you to allow some action, such as downloading a document or file from Google Drive, just after the WordPress-authentication.
- Twitter Out-of-Office. Answering machine for Twitter. It is designed for those people who want to contact you at a time when you can not answer yourself.
- SMS Alerts for Gmail. Receive notification via SMS of the arrival of the important messages in your Gmail mailbox via connection to a personal Twitter account.
- Extract Email Addresses. This script parses the contents of your mailbox and create a list of addresses of people who have previously communicated with you. Useful to start a personal campaign.
- Transfer Gmail. This script will automatically copy all your emails with Gmail old account to another mailbox, which can be in any service.
- Reminder for Starred Messages. Getting a daily report listing all the emails you have recently marked with an asterisk in Gmail.
- Advanced Gmail Search. Gmail supports a large number of search commands, but now you can use regular expressions to search for relevant messages in your mailbox.
- Twitter RSS Feeds. Twitter no longer provides RSS-feeds, but you can use Google Apps Script to create their own channels that contain data from Twitter tape, the search results and listings.
- Google+ RSS Feeds. This Apps Script, based on the addition of Chrome, will generate a RSS-feeds for any user of Google Plus, or search results.
- Translate RSS. The ability to automatically transfer Foreign RSS-channels in their native language, and subscribe to them via RSS-favorite program or service.
- Gmail Label Feeder. Creating RSS-channel for any label your mailbox Gmail, which you can then send to Evernote, Pocket, IFTTT and so on.
- gmail Meter. This script will help you analyze how you use Gmail, and generate a statistical report with information about how many emails you have sent, what their average value, the most common time correspondence and etc.
- Gmail Delay Send. This script is a simple, convenient and safe way to schedule a time to send emails in Gmail.
- gmail Snooze. Now you will be able to postpone the letter for some time. As a result, it will hide from the "Inbox" folder, but will re-appear there at the appointed hour.
- Gmail Auto Purge. This script is similar to an existing Outlook feature that automatically deletes the oldest messages from specific users by the time you specify.
- Gmail Clean-up. Creating automatic filters in Gmail, which are able in due time to move, archive or even delete all messages marked with a certain label.
- Save Gmail as PDF. This script allows you to save text messages to a PDF-file. You can also send these files to your email contacts.
- instagram Downloads. Upload photos marked certain tags from Instagram to your Google Drive.
- GDocs2MD. This script converts documents from Google Drive in popular Markdown format (.md), that allows their import and publication on other platforms.
- gmail NoResponse. Tracking emails in Gmail, which you have not received a response. Useful to once again remind myself.
- Force Password Change. If you're a Google Apps domain administrator, use this script to force all users to change their passwords.
- Text Browser. Lynx-like browser that allows you to surf on the Internet in plain text. This browser can also be used as a proxy server to access web content.
- Self-destructive Messages. Send confidential messages that automatically disappear after you read them.
- Auto-Expire Shared Folders. Ability to assign a term, after which users will lose access to shared folders earlier in Google Drive.
- reddit Scraper. Use the API along with Reddit Google Scripts, to get all posts with any topic Reddit directly in a Google Spreadsheet.
Do you have experience using Google Apps Script? Tell us about it in the comments.