Course Highlights
  • What is Google Apps Script
  • How Software Code Works
  • IF, LOOP, Array etc.
  • Write Google Apps Script to perform various tasks
  • Connect Google Sheets with Google Doc, Slide, Gmail, Calendar and Drive
  • Generate Documents from Template
  • 20 real life projects
Curriculum

6 Topics
Important Information
Writing the first line of code
Introduction
script Editor: Where codes are written
Good Practices for writing Codes
Know about Google App Script

4 Topics
Accessing an outside spreadsheet
What can we do with the Spreadsheets
Introduction to for Loop
More on For Loop

3 Topics
IF Statements
Array of Variables
Combining Array and For Loop

5 Topics
Get Last Row of Spreadsheet
CopyTo : Copying from one cell to another
Change Name Hide and Show Sheets
Customized Menu
Pop Up Dialogue Box

4 Topics
Creating Google Form
Setting up For Loop
Writing code for Loop
Automatically trigger the code

2 Topics
Introduction
What is Google Apps Script and how code runs

4 Topics
Clarification on Authentication
Read Data from Google Sheet
Write data to Google Sheet
More action with Google Sheet

3 Topics
What is an Array
Read and Write Array in Google Sheet
Functions associated with Array

3 Topics
IF statements
FOR Loop
WHILE Loop

3 Topics
Project 1: Combining Data from Individual Sheets
Project 2: Combining Multiple Rows of Data
Project 3: Combining Data from Different Google Spreadsheets

3 Topics
Read Email from Inbox
More action on Inbox
Send Email via Apps Script

2 Topics
Read Events from Google Calendar
Write or Update Events in Google Calendar

3 Topics
Read and Write to a Google Doc
Read from Google Slide
Write to Google Slide

3 Topics
Get Files and Folders
Create PDF
UI Alert and Prompt

18 Topics
Project 4: Get Item from Orders
Project 5: Salary Report & History
Project 6: Attendance Sheet
Project 7: Merge Assemblies
Project 8: Pingpong Winning Streak
Project 8: Annexure
Project 9: Compare Data
Project 10: Managing Vendors & Quotations
Project 11: Invoice Management
Project 12: Client onboarding
Project 13: Send Certificate from Sheet
Project 14: Send Certificate using Google Doc
Project 15: Create Real Estate Documents
Project 16: Scrap Gmail Data
Project 17: Store all Gmail Attachment in Google Drive
Project 18: Create Profile Card in Google Slides and save as PDF
Project 19: Slot Booking System
Project 20: Creating Personal Library of Images and PDF

  Write a Review

Google Apps Script: From Level Zero with 20 Projects (2023)

Go to Paid Course