19 Useful Google Apps Scripts to Automate Google Drive

Google Drive offers good facilities for storing and operative with opposite forms of files though it does miss during some facilities that are essential for your work. Google Apps Scripts is an easy-to-use scripting denunciation to get things done, that are differently not accessible in Drive.

10 Free Apps To Help Automate Tasks On Your Android Device

10 Free Apps To Help Automate Tasks On Your Android Device

One thing many people adore about Android is a leisure to emanate that is open source temperament affords…Read more

There are scripts that can let we read/extract calm from images, modify files, auto-backup amicable photos or store Gmail attachments. Most scripts let we automate these services as well.

Let’s check out how to make use of Google Apps Scripts to fill a blank holes in Google Drive and do many some-more things though third-party tools.

Prerequisite: How to Run Google Apps Scripts

To emanate and run a book in Drive, follow these steps:

  1. Create/open a Google Doc or Sheet. From Tools menu, name Script editor.
  2. Remove existent formula and supplement your code. Go to File Save supplement book name Click OK.
  3. To execute, click ►, or from a Run menu, name a function. If regulating a book for initial time, it will ask for your authentication. Check a compulsory permissions and click Allow.
  4. A yellow bar will seem during a centre-top, to prove that a book is running.

Please note these stairs are for ubiquitous scripts and certain scripts competence need specific additional instructions to run.

Convert and Email Google Sheets

What it does:

  • Converts Google Sheets to PDF and mails them regulating your Gmail account
  • Lets we convert and send usually one sheet regulating a piece id.
  • Send a PDF to multiple persons by adding their addresses, distant by commas.

Use Case Scenario:

It’s useful in scenarios like when we wish to send selling information to a third celebration though don’t wish to share a whole spreadsheet. You can use this book to send a PDF version. This approach compulsory information is common though compromising your whole spreadsheet’s info.

Convert Images to Text regulating OCR

What it does:

  • Converts images to text papers regulating a OCR technology; saves them in your drive.

Use Case Scenario:

This book proves profitable in situations when we need to revise calm in imges or do investigate on a vast series of images. It creates a converted images editable and searchable. It saves your time and efforts and gives infallible calm outlay as it uses a Google’s local OCR technology.

Track File Editors in Google Drive

What it does:

  • Finds out that user finished changes to your Google Drive’s local files.
  • Displays a dates and times when a record was mutated along with a name and email address of users who finished a changes to your common documents/files.

Use Case Scenario:

This book is useful for tracking a modifications finished in your drive, including Sheets, Documents, Presentations and other Google Drive formats.

Save a Webpage to Google Drive

What it does:

  • Saves or backs adult webpage on any URL to Google Drive.
  • Fetches a web page and saves a same as HTML record (by default) or your configured extension.
  • Maintains a good folder structure for storing mixed web pages or their copies.

Use Case Scenario:

This book is many useful for researchers, scholars, bloggers and such who need to investigate lots of websites and competence need to save them for destiny reference. Do remember to change a RESOURCE_URL in a dash to a couple we wish to download.

Send a Google Doc around Email

What it does:

  • Sends a Google Doc by email to anyone and places a doc’s calm as a email’s body (rather than an attachment).
  • Converts a doc to HTML and sends a same around email

Use Case Scenario:

If we wish to send something not as an connection though as partial of a email, this is a that gets a pursuit done. Do note we contingency change documentId, recipient, subject to their tangible values in a 4th line.

Host a Website on Google Drive

What it does:

  • Host any immobile website including files like HTML, CSS, JS, image, podcast, etc on Google Drive. (Drive can’t be used to offer energetic sites like those regulating PHP or Java backends.)

Use Case Scenario:

This book is useful when we don’t wish to buy a hosting devise or domain for your site. It’s totally giveaway of assign and Google’s servers are a lot faster than many hosting providers in a world.

Download Instagram Photos to Drive

What it does:

  • Downloads multiple Instagram photos and save them to your expostulate automatically.
  • Download photos regulating certain tags or from any specific Instagram URL.
  • Images are kept in a apart folder in Drive for easy maintenance.

Use Case Scenario:

It’s useful for Instagram fans, collectors and researchers who say information backups in Drive.

Convert a Google Doc to Markdown

What it does:

  • Converts a Google Doc to a markdown (.md) format.
  • It mails we a converted request along with images automatically. (Note it competence get into problems with information regulating formidable formatting.)

Use Case Scenario:

It’s useful for bloggers and publishers who frequently use a discount format for edition online. Using this, they can equivocate primer work of converting their calm for each draft.

Set Auto-Expiry for Shared Data

What it does:

  • Sets an auto-expiry interlude on a common files and folders in Drive
  • Automatically removes entrance to other users after a certain duration (of auto-expiry).

Use Case Scenario:

This book is useful for permitting singular entrance to your drive’s information and relieves we from worrying about forgetful to unshare data. This underline is already accessible for Google Apps for Work users, though if you’re giveaway user, afterwards it’s for you.

Save Gmail Attachments in Drive

What it does:

  • Extracts and saves all Gmail attachments to a sold folder in your drive.
  • Notify swell of fetched attachments, around email though requires environment adult presentation preferences.

Use Case Scenario:

If we cite to store attachments into cloud storages like Drive, afterwards this is a book to get.

Search All Files in Google Drive

What it does:

  • Searches all your files in a expostulate and displays a formula in simple-to-digest character in a Google Sheet.
  • Supports docs, sheets, presentations and few other calm formats.

Use Case Scenario:

Search by your files and piles of information fast with this.

List Directory in Google Drive

What it does:

  • Lists all files and folders of a Google Drive’s directory recursively
  • Write this information in easy-to-see format in a spreadsheet.

Use Case Scenario:

Good for creation clarity of all a information in your Drive, and for record government purposes. Do note that for this book to work, we contingency set a folderId initial in a code. A folder id is all after a ‘folders/‘ apportionment of a folder’s address.

Convert Google Docs to HTML

What it does:

  • Converts Google Docs to HTML format for easy pity or regulating in web pages or source formula editors.
  • Supports several simple HTML tags or formatting options though do know it doesn’t work really good for formidable calm formatting.

Use Case Scenario:

Helpful mostly for writers, bloggers and publishers seeking posts for HTML-ready tools. Do remember to set a KEY and FILE_ID variables in a code.

Combine Data from Multiple Sheets

What it does:

  • Merges information from multiple sheets of a sold spreadsheet into a singular piece in a stream spreadsheet.

Use Case Scenario:

This book is useful in situations wherein we have got mixed sheets of common information (including common headers and structure) and we wish to mix them into one vast piece of data.

Export Google Sheets to CSV Files

What it does:

  • Exports sheets in a stream spreadsheet as individual CSV files in Drive.

Use Case Scenario:

It’s useful for people who frequently use Sheets for handling and storing information and need information in CSV format for pity or use in other apps. Without this, Google Sheets usually modify and download one piece during a time.

After duplicating formula into a Script Editor, re-open that spreadsheet and check a Add-ons menu.

Convert a Google Sheet to PDF Invoice

What it does:

  • Converts any sold piece to a PDF invoice and save to your Drive.

Use Case Scenario:

Good for users who frequently use a Google Apps ecosystem as their work apparatus and have to understanding with product invoices and such.

Upload a URL directly to Google Drive

What it does:

  • Uploads any particular file (or mixed files) from a specific URL to your expostulate automatically.
  • Files are saved in a specific folder in a expostulate and it can simply upload mixed files from mixed links supposing it’s given one during a time.

Use Case Scenario:

For people who like to keep information from a Web in Drive. All it needs is a couple of a page we need. To use, duplicate formula into a Script Editor and go to Publish Deploy as web app…

Download Google+ Profiles to Google Sheets

What it does:

  • Fetches publicly accessible Google+ profiles’ data to a Google Sheet. The fetched information includes name, work info, form picture and more.
  • The usually submit it requires is a form id of a chairman we wish to get information about and this works for mixed profiles.

Use Case Scenario:

This is intensely useful for information entrance and amicable media analysts for information collection.

Convert PDF Attachments to Plain Text

What it does:

  • Converts all PDF attachments from Gmail to plain calm format for easy sharing/storing
  • You can specify a PDF’s strange language (for extracting a text) and save a outlay plain calm files along with the strange PDF files in Google Drive.

Use Case Scenario:

You frequently accept PDFs around mails and wish to save them in Drive in strange or plain calm form. It does a pursuit in batches.

How did we find this list? Do we know any some-more Google Apps Scripts that assistance palliate life of a Drive user? Please let us know regulating a comments territory below.

Add Comment