If your colleagues have been emailing you Microsoft Excel spreadsheets in xls or xlsx format, here’s a little snippet that will help you convert those Excel sheets into native Google Spreadsheet format using the Advanced Drive API service of Google Apps Script.
The enterprise editions of Google Drive Auditor and Gmail Address Extractor use the Google Apps Admin SDK (Directory API) with Google Apps Script to create a list of all users that are part of a G Suite (Google Apps) domain.
Google Slides API lets you programmatically create new presentations and edit existing ones. You can pull data from an external data source, like a Google Spreadsheet or Salesforce CRM, and create a nice-looking report in the form of a presentation.
When a user connects to an application that uses OAuth 2 authentication, they are presented with a consent screen that describes what information about their account will be shared with the application and it may also includes a list of various Google APIs that the application has requested access to.
This sample code shows how to use OAuth in Google Apps Script using Service Accounts. The G Suite admin can access the Google Drive files of any user – the username or email address of the user you are trying to impersonate specified with the method setSubject.
OAuth 2, in simple English, is a simple protocol that makes it easy for third-party applications to access a user’s account without the user having to give out their username and password to the application.
Google Apps Script helps you automate tasks across G Suite and other Google products. Here are some interesting problems that people have solved with Google Scripts and G Suite (formerly known as Google Apps).
The best resource for learning Google Script is the official documentation available at developers.google.com. Here are other video tutorials and online learning resources where you can get up to speed using Google Apps Script that will let you programmatically access various Google Apps and services include Gmail, Google Drive, Calendar, Google Forms, Google Docs and more.
Google Apps Script doesn’t offer a method for moving files from one folder in Google Drive to another one but there’s an option to add a file in Drive to multiple folders (similar to symbolic links in Unix).
Google Apps allows domain administrators to update the Gmail signatures programatically. This helps you maintain a standard email signature for all users of your organisation but certain fields like employee’s name, email address, title or phone number can be variable.
The official Google Translate API is available for businesses only but you can use Google Apps Script to create your own Google Language Translation API without having to pay the enterprise license fee.
You can store your Microsoft Office files (Word Documents, PowerPoint Presentations and Excel Spreadsheets) in Google Drive in their native format but then it takes up storage space, the files cannot be edited in the cloud and you’ll not be able to embed the files on other web page.
The Apps Script Execution API lets you call Google Apps Scripts from standard HTML pages. I’ve been working on a project that involved Apps Script Execution API, it was running perfect in the developer account but as soon as the code was migrated to the client’s Google account, it failed.
Google Drive supports OCR for image and PDF uploads. That means if you upload a, say, JPEG file containing text, Google Drive can automatically extract the text from the image and save it to an editable Google Document.
The school has a Google Form where teacher enter the performance grades of their students. This form data is stored in a Google Spreadsheet and they are using Google Charts with the Google Visualization API to convert these tables of rows into visual charts that can be easily visualized.
This Google Script, originally published by @rboyd, scans for lengthy emails in your Gmail mailbox (messages that have more than 100 words) and sends an auto-reply requesting the sender to resend the email after editing to less than 100 words.
Like WordPress, you can also manage your Blogger blogs using Google Apps Scripts. You need to enable the Blogger API from your Google Developers console and also include the Apps Script oAuth2 library in your Google Apps script project.
TallTweets uses the HTML2Canvas library to convert text into PNG images. The generated images is converted into base64 (data URI) which is then sent to the server over a HTTP POST request for uploading to twitter.
You can easily write a Twitter bot with the help of Google Apps Script. It fetches tweets addressed (@mentions) to the bot through the Twitter API, computes the answer with Wolfraph Alpha and replies with a tweet.
Gravity Forms is an extremely popular Forms plugin for the WordPress. When someone submits a form created with Gravity Forms, the form data is saved inside the MySQL database associated with your WordPress installation.
The Mail Merge Add-on uses the new Gmail API to create and save draft messages Gmail programmatically, something which cannot be done using the standard GmailApp or MailApp service of Google Apps Script.
You can easily convert any Google Spreadsheet or Google Document in your Google Drive to other formats like PDF, XLS, etc with Google Apps Script and either email the converted file or save it back to Google Drive.
The Amazon API returns the response in XML format with the ItemAttributes node containing the bulk of the information about the product including the title, author’s name, list price, physical dimensions and so on.
If you happen to a click a link pointing to the Apple apps store on your desktop, the browser opens a temporary web page with a message saying “Connecting to the Mac App Store..” and then redirects to the actual page.
If a visitor mistypes a URL to your WordPress blog or clicks on a link that does not exists, you can show them a more helpful 404 error page that will have suggestions pointing to related articles that they can check out on your WordPress site.
You can use the Amazon Advertising API (AWS) to fetch the current prices, item description, customer reviews, product images, quantity available and other details of any product listed on various Amazon websites.