Explore how to apply Google Apps Script to create amazing functionality within your Google Workspace Sheets Gmail Drive
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
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!
Content