課程資料
課程簡介
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.
此課程所涵蓋的技能
評價
-
FFred Clarke
Very clear instructions and explanations!
-
SSimon Bluck
Great course so far
-
PPitsi Idyllic
I'm new to GAS and Google APIs, this is a great course and is easy to follow if you have a programming background.
-
DDeeKay789
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.