In the world automation Google has always been step ahead almost in every terms especially technology. Google apps play an important role in our day-to-day life and to make it more efficient and less time consuming, Google Apps Script example with useful cases is presented here. Keep reading to have some cool insights about apps script.
What is Google Apps Script?
Google Drive offers some great platforms for storing and dealing with distinctive varieties of records however it does lack some facets that are critical on your work. Google Apps Scripts is an handy-to-use scripting language to get matters performed, which can be otherwise not to be had in force.
There are scripts that can let you learn/extract textual content from pix, convert records, auto-backup social snap shots or store G-mail attachments. Most scripts can help you automate these offerings as good.
The predominant objectives of Google Apps Script is to enable you to have programmatically entry to a few cool features and merge a number of “apps” into 1 macro.
Let’s assess out make use of Google Apps Scripts to fill the missing holes in Google drive and do many more things without third party tools.
Just quick start how to run Google apps script example from Google developer site and then you can move with below cases and examples.
Google Apps Script Examples:
Create playlist in YouTube with the help Google apps script by using excel sheets. This script helps you to automate adding of videos related to your playlist.
Students or learners on YouTube can create their specific playlist and automate the process of adding videos as per their needs whenever new video is uploaded for that category.
Uploads any character file (or a couple of files) from a specific URL to your force robotic-ally. Records are saved in a targeted folder within the power and it could comfortably upload multiple files from more than one links supplied it’s given separately.
For people who wish to preserve information from the web in Google drive. All it needs is the hyperlink of the web page you want. To make use of, replica code into the Script Editor and go to publish > install as web app…
Fetches publicly to be had Google+ profiles’ data to a Google Sheet. The fetched knowledge involves name, work info, profile snapshot and more. The only field it requires is the profile id of the person you desire to get data about and this works for more than one profiles.
That is totally useful for knowledge entry and social media analysts for information assortment.
Converts all PDF attachments from Gmail to plain text structure for effortless sharing/storing that you would be able to specify the PDF’s normal language (for extracting the textual content) and save the output simple textual content documents along with the usual PDF records in Google pressure.
You commonly acquire PDFs through mails and need to retailer them in power in normal or plain textual content kind. It does the job in batches.
Host any static website together with records like HTML, CSS, JS, snapshot, podcast, etc on Google drive. (power can’t be used to serve dynamic websites like these utilizing personal home page or Java back ends.)
This script is useful when you don’t want to purchase a website hosting plan or area on your website online. It’s totally gratis and Google’s servers are lots faster than many web hosting providers on this planet.
Downloads multiple Instagram pictures and shop them to your power mechanically. Download portraits utilizing certain tags or from any exact Instagram URL. Pictures are kept in a separate folder in power for easy preservation.
It’s worthy for Instagram enthusiasts, collectors and researchers who maintain information backups in pressure.
Converts a Google Doc to the markdown (.Md) structure. It mails you the modified report along with photographs routinely. (note it’ll get into problems with knowledge utilizing tricky formatting.)
It’s valuable for bloggers and publishers who usually use the markdown structure for publishing on-line. Utilizing this, they may be able to hinder guide work of converting their content for each draft.
Sets an auto-expiry interval on the shared records and folders in power routinely gets rid of access to other users after the specified period (of auto-expiry).
This script is useful for permitting restricted entry to your power’s data and relieves you from worrying about forgetting to unshare data. This option is already available for Google Apps for Work users, but in case you’re free person, then it’s for you.
Extracts and saves all Gmail attachments to a specific folder in your drive. Notify growth of fetched attachments, via e-mail however requires setting up notification preferences.
For those who opt for to store attachments into cloud storages like drive, then this is the script to get.
Searches your whole documents in the drive and shows the outcome in simple-to-digest type in a Google Sheet.
Supports doctors, sheets, shows and few other textual content formats.
Search through your documents and piles of knowledge quickly with this.
Lists all documents and folders of a Google drive’s directory recursively. Write this information in effortless-to-see format in a spreadsheet.
Good for making feel of all the information to your pressure, and for file administration functions. Do notice that for this script to work, you must set the folder Id first in the code. A folder identification is the whole thing after the folder’s section of a folder’s deal with.
Converts Google doctors to HTML structure for easy sharing or utilizing in web sites or supply code editors. Supports quite a lot of common HTML tags or formatting choices but do recognize it doesn’t work very well for elaborate textual content formatting.
Necessary and normal for writers, bloggers and publishers looking for posts for HTML-equipped tools. Do keep in mind to set the important thing and FILE_ID variables within the code.
Merges data from multiple sheets of a distinct spreadsheet into a single sheet within the current spreadsheet.
This script is valuable in situations in which you’ve received a couple of sheets of long-established knowledge (including customary headers and structure) and also you desire to combine them into one big sheet of information.
Exports sheets in the present spreadsheet as character CSV files in force.
It’s worthy for folks who frequently use Sheets for managing and storing data and require knowledge in CSV format for sharing or use in other apps. Without this, Google Sheets handiest convert and down load one sheet at a time.
After copying code into the Script Editor, re-open that spreadsheet and assess the Add-ons menu.
Converts any certain sheet to a PDF bill and keep to your drive.
Excellent for customers who frequently use the Google Apps ecosystem as their work tool and have got to maintain product invoices and such.
Converts Google Sheets to PDF and mails them utilizing your Gmail account means that you can convert and ship just one sheet utilizing its sheet identity. Ship the PDF to multiple persons by means of including their addresses, separated through commas.
It’s precious in situations like while you want to send marketing information to a third social gathering however don’t wish to share the whole spreadsheet. You need to use this script to ship a PDF version. This fashion required knowledge is shared with out compromising your whole spreadsheet’s info.
Converts images to text files utilizing the OCR science; saves them in your force.
This script proves beneficial in circumstances when you ought to edit textual content in images or do study on a big quantity of pix. It makes the converted photographs editable and searchable. It saves your time and efforts and gives trustworthy text output as it makes use of the Google’s native OCR science.
Finds out which consumer made changes to your Google pressure’s native documents. Shows the dates and occasions when the file was once modified together with the name and e-mail deal with of customers who made the alterations to your shared documents/files.
This script is valuable for monitoring the changes made to your drive, including Sheets, records, displays and different Google drive formats.
Saves or backs up webpage on any URL to Google force. Fetches the online web page and saves the identical as HTML file (by using default) or your configured extension. Continues a exceptional folder constitution for storing multiple websites or their copies.
This script is most necessary for researchers, scholars, bloggers and such who have to study tons of internet sites and could need to save them for future reference. Do take into account to vary the resource URL in the snippet to the hyperlink you want to download.
Sends a Google Doc through email to someone and places the doc’s content material as the email’s physique (as an alternative than an attachment). Converts the doc to HTML and sends the equal via e-mail
If you want to send anything not as an attachment however as a part of the email, that is the that gets the job carried out. Do note you have got to change document Id, recipient, discipline to their genuine values within the 4th line.
Find more Google Apps Scripts Example – Ben Collis’ Apps Script Example
You may like: Artificial Intelligence in Digital Marketing Trends 2019
I’ll elongate this list of Google Apps Script as and when I will find new scripts and its use cases.
Do you know any other Google Apps Scripts that can be useful to technology society? Let us know in comment and we will feature you out!
Keep innovating. Keep Sharing.