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
Free tutorial
Rating: 4.7 out of 5 (6 ratings)
1,224 students
1hr 5min of on-demand video
English
English [Auto]

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

Requirements

  • Google Account
  • Prior Coding experience is required

Description

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!

Who this course is for:

  • Apps Script Coders
  • Google Workspace users
  • Web application developers
  • JavaScript Developers

Instructor

Instructor, GDE, Application Developer
Laurence Svekis
  • 4.4 Instructor Rating
  • 50,754 Reviews
  • 850,005 Students
  • 329 Courses

I'm here to help you learnachieve your dreams, come join me on this amazing adventure today
Google Developers Expert - GSuite

Providing Web development courses and digital marketing strategy courses since 2002.

Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.

"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998.  I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."

"Learning, understanding with a strong passion for education.  The internet has provided us with new opportunities to expand and share knowledge."

Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online.  Technology connects us all in many ways.  It opens up doors to those who embrace it and learn how to make those connections real.

"My courses are designed to help you achieve your goals, learn and update skills"

Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications.  Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO

"Understanding technology provides a means to better connect with users.  It also opens so many doors.   Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"

Top companies trust Udemy

Get your team access to Udemy's top 16,000+ courses