Advanced Google Apps Script and API with 10 Projects

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

Ratings: 4.69 / 5.00




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 !!!

What You Will 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.

Who Should Attend!

  • 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.