Udemy

Advanced Google Apps Script and API with 10 Projects

立即報名
  • 760 名學生
  • 更新於 4/2023
4.4
(78 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
15 小時 19 分鐘
教學語言
英語
授課導師
Shahbaz Haidar
評分
4.4
(78 個評分)

課程簡介

Advanced Google Apps Script and API with 10 Projects

Connect Apps Script with Google Analytic, Youtube, Classroom, Trello, Pipedrive, WooCommerce and other apps

Disclaimer:Since I am a full time Google Spreadsheet and Apps Script consultant, with clients all over the world, I know what are the things that are important and should be taught to students.

In our course on Google Script for beginners, we learnt how to open the editor and write some basic function. Now it is time to master the art of writing Apps script code and exploit all the options and facilities given by Apps Script. Some of the things we will be learning in this course are:

  • Custom Function

  • Apps Script Library

  • JSON

  • doGet & doPost

  • Connecting tools with API

    • Google Analytics

    • Youtube

    • Pipedrive

    • Trello

    • Woo Commerce

We will learn how to explore API Documentation of any tools. You would be able to automate many processes once you are comfortable with all API documentation and knowledge on how to implement it.

Once you have mastered the concepts taught in this course, you will be equivalent of a Software Developer. Software development is so big an area that it can not be taught in a course. But thanks to our time, everything is available on Google. So in this course, I have focused on teaching how to google for an answer while writing codes.

Happy Scripting !!!

課程章節

  • 14 個章節
  • 57 堂課
  • 第 1 章 Introduction
  • 第 2 章 Useful Commands in Apps Script
  • 第 3 章 Filter and Date-Time
  • 第 4 章 Drive API
  • 第 5 章 Introduction to API
  • 第 6 章 Pulling and Pushing Data from and to a CRM
  • 第 7 章 Other Google Services: Google Calendar
  • 第 8 章 New Course: Introduction
  • 第 9 章 New Course: JSON & Project Property
  • 第 10 章 New Course: Advance Workspace Tools
  • 第 11 章 New Course: Libraries
  • 第 12 章 New Course: API
  • 第 13 章 New Course: GET, POST & Webhooks
  • 第 14 章 New Course: Projects

課程內容

  • You will be able to use Google Spreadsheet more efficiently, You will be able to write Advance Google Scripts codes and function, You will be able to use array of data, manipulate them and use them., You will be able to search on google for any problem that you face, and get a solution for yourself., You will be able to connect to other apps using their API and get data., You will be able to send data to 3rd party Apps., You will be able to use other services by Google Scripts like Calendar service etc.


評價

  • F
    Fred Clarke
    5.0

    Very clear instructions and explanations!

  • S
    Simon Bluck
    4.0

    Great course so far

  • P
    Pitsi Idyllic
    5.0

    I'm new to GAS and Google APIs, this is a great course and is easy to follow if you have a programming background.

  • D
    DeeKay789
    1.5

    1) The teaching so far is using an outdated application editor, an outdated Log function ( has been replaced by amuch more advanced and API appropriate Execution Datalogger) plus it's using an outdated ES5 GAS and not V8 ES6 GAS conventions. 2) Half way through and there's been no mention of js Promises and Async/Await. Specifically, no mention of the concept of handling API call successes and failures.

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意