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

سرفصل های دوره

Automate your day to day tasks like a pro

1 - Introduction

1 - Important Information

1 - Know about Google App Script.html

2 - Writing the first line of code

3 - Introduction

4 - script Editor Where codes are written

5 - Good Practices for writing Codes

2 - Handling Spreadsheet and For Loop

6 - Accessing an outside spreadsheet

7 - What can we do with the Spreadsheets

8 - Introduction to for Loop

9 - More on For Loop

3 - IF Statement and Array

10 - IF Statements

11 - Array of Variables

12 - Combining Array and For Loop

4 - Commonly used Functions in Spreadsheet

13 - Get Last Row of Spreadsheet

14 - CopyTo Copying from one cell to another

15 - Change Name Hide and Show Sheets

16 - Customized Menu

17 - Pop Up Dialogue Box

5 - Live Project 1 Send email with details of Google Form

18 - Creating Google Form

19 - Setting up For Loop

20 - Writing code for Loop

21 - Automatically trigger the code

6 - NEW COURSE Introduction

22 - Introduction

23 - What is Google Apps Script and how code runs

7 - NEW COURSE Interacting with Google Sheets

24 - Clarification on Authentication

25 - Google Sheet used in the Video.txt

25 - Read Data from Google Sheet

26 - Write data to Google Sheet

27 - More action with Google Sheet

8 - NEW COURSE ARRAY

28 - What is an Array

29 - Read and Write Array in Google Sheet

30 - Functions associated with Array

9 - NEW COURSE Conditional Executions IF and Loops

31 - IF statements

32 - FOR Loop

33 - WHILE Loop

10 - NEW COURSE Basic Projects

34 - Google Sheet with the Project Script.txt

34 - Project 1 Combining Data from Individual Sheets

35 - Google Sheet with the Project Script.txt

35 - Project 2 Combining Multiple Rows of Data

36 - Google Sheet with the Project Script.txt

36 - Project 3 Combining Data from Different Google Spreadsheets

11 - NEW COURSE GMAIL APP

37 - Read Email from Inbox

38 - More action on Inbox

39 - Send Email via Apps Script

12 - NEW COURSE CALENDAR APP

40 - Read Events from Google Calendar

41 - Write or Update Events in Google Calendar

13 - DOCUMENT APP And SLIDE APP

42 - Read and Write to a Google Doc

43 - Read from Google Slide

44 - Write to Google Slide

14 - NEW COURSE Interact with Google Drive and UI Elements

45 - Get Files and Folders

45 - Google Sheet used in the Video.txt

46 - Create PDF

47 - Google Sheet used in the Video.txt

47 - UI Alert and Prompt

15 - NEW COURSE Projects

48 - Google Sheet with the Project Script.txt

48 - Project 4 Get Item from Orders

49 - Google Sheet with the Project Script.txt

49 - Project 5 Salary Report And History

50 - Google Sheet with the Project Script.txt

50 - Project 6 Attendance Sheet

51 - Google Sheet with the Project Script.txt

51 - Project 7 Merge Assemblies

52 - Google Sheet with the Project Script.txt

52 - Project 8 Pingpong Winning Streak

53 - Project 8 Annexure

54 - Google Sheet with the Project Script.txt

54 - Project 9 Compare Data

55 - Google Sheet with the Project Script.txt

55 - Project 10 Managing Vendors And Quotations

55 - Quotation Template used in the Project.txt

56 - Google Sheet with the Project Script.txt

56 - Project 11 Invoice Management

57 - Google Sheet with the Project Script.txt

57 - Project 12 Client onboarding

58 - Google Sheet with the Project Script.txt

58 - Project 13 Send Certificate from Sheet

59 - Certificate Template.txt

59 - Google Sheet with the Project Script.txt

59 - Project 14 Send Certificate using Google Doc

60 - Google Sheet with the Project Script.txt

60 - NOC Template.txt

60 - Novation Template.txt

60 - Project 15 Create Real Estate Documents

61 - Google Sheet with the Project Script.txt

61 - Project 16 Scrap Gmail Data

62 - Google Sheet with the Project Script.txt

62 - Project 17 Store all Gmail Attachment in Google Drive

63 - Google Sheet with the Project Script.txt

63 - Google Slide Template used in the Project.txt

63 - Project 18 Create Profile Card in Google Slides and save as PDF

64 - Google Sheet with the Project Script.txt

64 - Project 19 Slot Booking System

65 - Google Sheet with the Project Script.txt

65 - Project 20 Creating Personal Library of Images and PDF

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy