Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Google Apps Script (GScript)

( Duration: 2 Days )

Google Apps Script is a powerful tool to automate your Google G Suite apps such as Google Docs, Sheets, Gmail, Calendar, and Drive. This JavaScript-based platform allows you to access data from the Google cloud, edit files, automate tasks, and extend apps' power. You can even share your scripts with others in the form of add-ons.

This Google Apps Script (GScript) training course provides skills to use simple scripts to edit documents and spreadsheets, work with files in Drive.

By attending Google Apps Script (GScript) workshop, delegates will learn about:

  • Google Script for Sheets
  • Google Script for Slides
  • Google Script for Doc
  • Google Script for Calendar
  • Google Script for Drive
  • Triggers
  • Create Auto Email Alert

  • Basic Google G Suite knowledge
  • Basic Javascript knowledge

COURSE AGENDA

1

Getting Started

  • What is Google Apps Script
  • Google Apps Script Editor
  • Write Your First Google Apps Script
  • Mail Service
  • Run You Script
2

Google Sheet Script

  • Spreadsheet Service
  • Sheet Methods
  • Range Methods
  • Get and Change Cell Values
  • Apply Formula
3

Google Doc Script

  • Document Service
  • Document Methods
  • Body Methods
  • Text Methods
  • Modify and Append Text
4

Google Slide Script

  • Slide Service
  • Presentation Methods
  • Slide Methods
  • Modify Slide Font
5

Google Calendar Script

  • Calendar Service
  • Event Methods
  • Recurrence Methods
  • Create Calendar Events
  • Create Recurrence Events
6

Google Drive Script

  • Drive Service
  • Create Folder and File
7

Triggers

  • What is Trigger
  • Time Driven Trigger
  • Setup an Auto Email Alert

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X