Full Google Workspace Automation - Apps Script

Focused View

Gaurav Gosain

7:05:26

30 View

1. Introduction to Google Workspace Automation

1.1 Lecture 1 - Transcript Notes.pdf

1.2 Lecture 1.pptx

1. Introduction.mp4

05:58

2. How to create Apps Scripts Projects

1.1 Lecture 2 - Transcript Notes.pdf

1. Ways to create Apps Scripts Projects.mp4

11:35

3. Introduction to Robotic Process Automation

1.1 Lecture 3 - Transcript Notes.pdf

1. RPA in Apps Scripts.mp4

12:06

4. Google Sheets Automation

1.1 Lecture 4 - Section 1 Notes.pdf

1. Accessing files on Google Ecosystem - The Unique Id.mp4

03:59

2.1 Lecture 4 - Section 2 Notes.pdf

2. SpreadsheetApp and Sheet Classes and Methods.mp4

10:50

3.1 Lecture 4 - Section 3 Notes.pdf

3. Reading and Writing Functions.mp4

25:40

4.1 Lecture 4 - Section 4 Notes.pdf

4. Setting Formulas and SQL Queries.mp4

17:00

5.1 Lecture 4 - Section 5 Notes.pdf

5. Calculating Metrics and Column Fields.mp4

42:38

6.1 Lecture 4 - Section 6 Notes.pdf

6. Creating Custom UI in Google Sheets.mp4

05:18

7.1 Lecture 4 - Section 7 Notes.pdf

7. Automating Calculation - Through Unattended Bots.mp4

01:25:55

5. Gmail Automation

1.1 Lecture 5 - Section 1 Transcript Notes.pdf

1. Marketing Campaign Automation - Sending Emails Part 1.mp4

55:55

2. Marketing Campaign Automation - Sending Emails Part 2.mp4

08:11

3.1 Lecture 5 - Section 2 Transcript Notes.pdf

3. Reading Emails from Gmail.mp4

19:35

4.1 Lecture 5 - Section 3 Transcript Notes.pdf

4. Gmail Attachment Processing.mp4

01:00:49

6. Google Forms and Drive Automation

1.1 Lecture 6 - Transcript Notes.pdf

1. Invoice Management System.mp4

24:29

7. Google Document Automation

1.1 Lecture 7 - Transcript Notes.pdf

1. Document Generator App.mp4

35:28

Description

Robotic Process Automation, Google Apps Script, Google Sheets, Google Docs, Mail Merge, Document Generator

What You'll Learn?

Learn how to automate google workspace through apps scripts including multiple apps like Sheets, Documents, Gmail, Forms and Drive
Learn robotic process automation through creation of unattended bots
Learn to develop different productivity tools for google workspace
Learn and enhance knowledge of Javascript and data structures

Who is this for?

Enterprise professional users with Google Workspace accounts

Beginners and experienced professionals learning Robotic Process Automation

Startup software engineers with Google Workspace accounts

What You Need to Know?

Working hands on knowledge of Javascript is required

More details

Description
Welcome to full google workspace automation through apps script course. In this course you will learn to Create, Integrate and finally automate different services offered within the google workspace ecosystem. Apps Script is Google's cloud native wrapper around Javascript that lets you do wonderful things easily - increasing your productivity and efficiency.
With detailed documentation and community support apps script is surely the best choice for robotic process automation in google workspaces. You can create files, integrate different services, build web applications, and automate all repetitive tasks with fairly less coding experience.
The course is designed to expose you step by step to different apps script functionalities and best practices. Within this course, you will learn how to set up apps script projects, automate google sheets, google forms, documents, drive and lastly GMail all doing so while building real world productivity tools. This course should take you approximately 7-8 hours to finish and is packed with code samples, live examples and mini exercises.
While creating this course we made sure that anyone who is interested in learning robotic process automation will find this course useful. Although app scripts is native to google workspace, the concepts that you are expected to learn throughout this course are applicable to other ecosystems as well.
So, If you are a student having an interest in RPA, or a professional working in an enterprise that uses google workspace, or an entrepreneur running your own startup this course will help you solve a lot of your problems driving productivity.
The only prerequisite for the course is beginner level exposure to web technologies primarily Javascript. This course shall also create ample opportunities to hone your javascript skills and data structures. Hope, you learn something new and are able to apply these learnings in your journey.

Who this course is for:
Enterprise professional users with Google Workspace accounts
Beginners and experienced professionals learning Robotic Process Automation
Startup software engineers with Google Workspace accounts

User Reviews

Rating

average 0

Total votes0

Focused display

Google Apps Script

Gaurav Gosain

Instructor's Courses

Hi, I am Gaurav Gosain! I have spent over 10 years in variety of industries including engineering in a Fortune 500 company, entrepreneurship startup in hospitality and tech consulting in a Big4 - helping clients and teams do their work better. I specialise in Artificial Intelligence and Machine Learning, helping develop cloud native scalable solutions.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.