Your cart is empty.
Keep shoppingAdvanced Google Apps Script and API with 10 Projects
769 students
Advanced Google Apps Script and API with 10 Projects
Connect Apps Script with Google Analytic, Youtube, Classroom, Trello, Pipedrive, WooCommerce and other apps
Created byShahbaz Haidar
Last updated 4/2023
English
English [Auto],
What you'll learn
- 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.
Explore related topics
Course content
14 sections • 57 lectures • 15h 19m total length
Requirements
- Gmail ID
- Familiar with basic working of Google Spreadsheet
- Has completed the course, or has knowledge of basic Google Apps Script
Description
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 !!!
Who this course is for:
- If you are a student and want to increase your knowledge base, this course is for you.
- If you are in early phase of your career, and want to add a new vertical to your skill set, this course is for you
- If you are a software developer and want to learn yet another language and tool, this course is for you
- If you are a data analyst, and want to perform complex calculations on data, this course is for you.
- If you are an aspiring freelancer and want to take up projects and complete them, this course is for you.