IIRF Online > Office Productivity > Google > Google Apps Script > Google Apps Script: From Level Zero with 20 Projects (2023)
Google Apps Script: From Level Zero with 20 Projects (2023) by Udemy
Automate your day to day tasks like a pro
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
Skills you will learn!
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
Google Apps Script: From Level Zero with 20 Projects (2023)
Related Google Apps Script Courses
Thank You!
Your review has been submitted successfully.