Google Apps Script Archives

Google Apps Script: Download mailbox of a domain user using Email Audit API in a Google Apps Domain

February 9, 2013July 27, 2018WebEmail Audit API, Google Apps Script

Reading Time: 4 minutes The Google Apps Email Audit API allows Google Apps administrators to audit a user’s email, email drafts, and archived chats. In addition, a domain administrator can retrieve account login information and download a user’s mailbox. This API only applies to Google Apps for Business, Education, and ISPs accounts. It is not used with a Google Apps or Gmail account not hosted by the Google Apps Continue Reading

Google Apps Script: Read Google Document as Template

February 4, 2013February 5, 2013WebGoogle Apps Script

Reading Time: < 1 minute DocsList services provides access to the document list This services provides access to the document list and the files and folders in the document list. we can create files, folders, and subfolders that appear in the document list. Here, we are going to read a Google Document as a template by Google Apps Script. Step 1: Create a Document: Create a document and write some Continue Reading

Google Apps Script : Connectivity with Google Cloud SQL Database that lives in Google’s cloud

February 1, 2013July 27, 2018WebDatabase, Google Apps Script, GoogleCloud SQL

Reading Time: 2 minutes Google Cloud SQL is a MySQL database that lives in Google’s cloud. It has all the capabilities and functionality of MySQL. Google Cloud SQL is easy to use, doesn’t require any software installation or maintenance and is ideal for small to medium-sized applications. Google Cloud SQL allows you to create, configure, and use relational databases that live in Google’s cloud. It is a fully-managed service Continue Reading

Google Apps Script: Create user interface using HTML/ CSS/ JavaSript

January 27, 2013March 19, 2013WebGoogle Apps Script

Reading Time: 5 minutes The Html Service in Google Apps Script provides ability to create and serve HTML output from a script. Scripts that create user interfaces with the Html Service can contain HTML, JavaScript, and CSS. Our scripts can display the user interface in the following three ways: As a stand-alone web app Embedded in a Site Directly from a Spreadsheet In this blog, we are going to Continue Reading

Google Apps Script: Documents and Files Sharing Between the Google Apps Domain

January 20, 2013January 21, 2013WebGoogle Apps Script

Reading Time: 2 minutes The Google Documents List API allows client applications to view and manipulate files in a user’s Documents List. In this blog we would learn how to share documents and files between the Google Apps Domain. When our application requests non-public user data, it must include an authorization token. The token also identifies your application to Google. Requests to the Google Documents List Data API for Continue Reading

Google Apps Script : To store data on google Cloud Sorage

January 19, 2013July 27, 2018WebGoogle Apps Script, Google Cloud Storage

Reading Time: 3 minutes Google Cloud Storage is a new service for developers to store and access data in Google’s cloud. It offers developers direct access to Google’s scalable storage and networking infrastructure as well as powerful authentication and data sharing mechanisms. Developers can store objects of any size and manage access to their data on an individual or group basis using Google Cloud Storage. Google Cloud Storage is Continue Reading

Google Apps Script :To set signature block for users automatically in a Google Apps Domain :

January 11, 2013July 27, 2018WebGoogle Apps Script

Reading Time: < 1 minute A signature block (often abbreviated as signature, sig block, sig file, .sig, dot sig, siggy, or just sig) is a block of text automatically appended at the bottom of an e-mail message. Information usually contained in a signature block includes the poster’s name, phone number and email address, along with other contact details if required, such as URLs for sites owned or favoured by the Continue Reading