Learn Google Apps Script Coding Project Examples

Explore how to apply Google Apps Script to create amazing functionality within your Google Workspace Sheets Gmail Drive

4.25 (55 reviews)
Udemy
platform
English
language
Web Development
category
instructor
Learn Google Apps Script Coding Project Examples
3,292
students
1 hour
content
Feb 2023
last update
FREE
regular price

What you will learn

How to write code with Google Apps Script

How to output Sheet data into a web app as JSON data

How to create a web app URL with Apps Script

How to send emails using Google Apps Script

How to create a document PDF and email it as an attachment

How to make a fetch request to GET and POST data to an endpoint

How to create a web app API endpoint with Sheet data

How to create a Google Sheet and populate data

How to use the UrlFetchApp Service within Google Apps Script

Why take this course?

Google Apps Script is based on JavaScript, it runs in the cloud and allows you to connect the Google Workspace Services together.  Build functionality, use Sheets data within your frontend code.  Create spreadsheets with code!  Connect to web URLs and APIs to populate your sheet data.  Create PDFs within Google Apps Script and email them, with email MailApp advanced options, sending multiple emails, attachments, and much more.   

Please note that this course is for JavaScript Coders, and those who already have experience with Google Apps Script.  Prior Coding experience is required!!!!!

The upcoming lessons are based on commonly asked questions about Google Apps Script and how it can be used and connected to with other applications.  The lessons are based around fetch requests to APIs, and URLS to get data.  Post data to an endpoint with Google Apps Script. 

Explore using Google Apps Script :

  • Create a Spreadsheet with rows and columns values from a loop

  • Use array data to create a spreadsheet and populate the values

  • Apps Script UrlFetchApp Get URL Data and output to Web App

  • Populate Spreadsheet data from Web API

  • How to send data to an endpoint UrlFetchApp POST JSON

  • Sending Emails with MailApp Class using Google Apps Script

  • Advanced options for send emails with MailApp

  • How to check your daily quota of remaining emails to send in MailApp with Apps Script

  • JSON output from Object Data into a web app URL

  • Create an Object using Sheet Data

  • Sheet Data as JSON Object connect with JavaScript output into a web page

Useful code snippets for anyone who uses Google Apps Script or wants to make use of the Google Workspace.

All you need is a Google Account and you can start coding.

Bonus downloadable PDF guide included..   with Source code, and code resources to get you started quickly.

Taught by a Google Developer Expert ready to help you learn, and answer any questions you might have.

Join now, start coding today!

Screenshots

Learn Google Apps Script Coding Project Examples - Screenshot_01Learn Google Apps Script Coding Project Examples - Screenshot_02Learn Google Apps Script Coding Project Examples - Screenshot_03Learn Google Apps Script Coding Project Examples - Screenshot_04

Reviews

Vaibhav
June 5, 2023
pretty simple and concise. Have been looking for a long time for a leaerning resource like this for app scripting.
Adi
October 5, 2022
i already there some code to generate spread sheet to google drive, It's great for temporary DB, or make the DB that user need data on spread sheet
Paul
May 27, 2022
A very good course. A bit technical in places, but this is just a challenge to understand each topic. Using commenting before the functions would be helpful in explaining their role in the over all project. Although, a verbal description of each project is given, it wold be helpful to have it written in a comment at the start of each new project for reference, when reviewing/following up, later. Thank you for your efforts, they are very much appreciated.

Charts

Price

Learn Google Apps Script Coding Project Examples - Price chart

Rating

Learn Google Apps Script Coding Project Examples - Ratings chart

Enrollment distribution

Learn Google Apps Script Coding Project Examples - Distribution chart
4618720
udemy ID
3/29/2022
course created date
4/2/2022
course indexed date
Bot
course submited by