Posts

Showing posts from February, 2018

Hello World Using Google App Script

Image
Hello world in Google App Script Go to Your Google drive Go to your Google drive  Login your Google Drive account ( https://drive.google.com/drive/ ) Click on NEW button Go to More  → Click on Google Apps Script apps Google Apps Script link redirect to App Script editor Rename untitled project to meaning full one Here we are using “First App Script Project” Add below code in Coding area. function myFunction() {    var msg="Hello World..!"; Logger.log(msg) } Save code (Ctrl+S/⌘+S ) Run functions: Click on Run-- > Run function --> myFunction (Ctrl+R /⌘+R) View Logs: Click on View → Logs (Ctrl+Enter / ⌘+Enter) Script Output: It will show result with timestamp. Now your ready for dive in Google Apps Script coding…! Happy Coding...

Google Apps Script IDE overview

Image
Google App Script IDE overview Google Update: This version of the Apps Script editor will be completely turned off soon. Google Apps Script IDE having multiple options as below... Project Name : Save project with given name  Menus : File : To perform file operations New : It allows to create New Project, Code(.gs), HTML files and other Google files. Open …: It will redirect to App Script Dashboard See version history : Compare code file changes (Don't expect like git) Rename …: Rename existing project/script file. Make a copy : Make copy of current project Save : It saves written code (Single) Save all : It saves written code (Multiple) Manage versions …: It is useful when you publish App Script as Library. Share …: Sharing file with other users. Project Properties : It contain project key details like Info : Basic information about current apps script project Scopes : List of all scopes used in current project User properties : It will manage Use

Enable Google App Script IDE

Image
Enable Google App Script IDE Login your Google Drive account ( https://drive.google.com/drive/ ) Click on NEW button. Click on More Click on Connect More apps, It will redirect Drive app center. Search App Script → Click on +CONNECT   ( It will take few second to install ) After installation CONNECT will change to RATE IT Close Connect apps to Drive popup, Google App Script now added in Drive app list. Click on More → Click on Google Apps Script apps Google Apps Script will redirect to App Script editor. Project Name: It will help to save app script project file in Google drive Menus: More options to perform activities Quick Menus: Useful menu shortcuts  Code save (Indicator): Helps to monitor code is saved or not Coding area: Actual part to write code File list: Display all project files (script file .gs & HTML file .html) Google account details: User email ID Coding File sharing options: Helps to share file like Google docs
I am developing this blog for the G suite & GCP developers seeking  to learn Google Apps Script to automate daily business needs & repetitive tasks using Google Apps Script and Google products. What is Google Apps Script? Google Apps Script is a scripting language based on JavaScript that lets you do new and cool things with G Suite products like Docs, Sheets, Slides, and Forms. There's nothing to install — Google gives you a code editor right in your browser, and your scripts run on Google's servers. Happy Coding...