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