About This Course
Who this course is for:
- Web developers
- App Developers
- Anyone who wants to learn to automate workflow with Spreadsheets
What you’ll learn:
- How to connect spreadsheet to form data
- Explore how Google Scripts works
- Setup automation and triggers on Script function
- Send emails using Google Apps Script
Requirements:
- JavaScript experience
- Computer access
- A Google account
Google Apps Script is based on JavaScript and you can write code online in the online editor, the only requirement is a Google Account to get started. Please note this course covers how to use Google Apps Script to automate and increase productivity within GSuite – coding experience is required.
This is a coding course, JavaScript experience is a prerequisite to write Google Apps Script code. It covers the basics of setting up form submission, using spreadsheets to track data, and setting up triggers of scripts to automate content.
Coding includes the following :
- Setting up form to submit data
- Sending an email on form submission, setup of trigger to catch form submissions
- Use of Spreadsheet to track data
- Update and getting content from the Spreadsheet to use in Google Apps Script code
- Update set and get of Sheet data
- Sending of emails from sheet data – checking to see if user from sheet already has email sent
- Adding UI for advanced menu option within spreadsheet
Source code is included so you can copy and paste the code to try for yourself, together with step-by-step learning from an instructor with over 20 years of experience, ready to help you learn. You have nothing to lose – join now and start learning to create your own version of this helpful application today!
Our Promise to You
By the end of this course, you will have learned to connect spreadsheets to form data using Google Apps Script.
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about script function.
Course Curriculum
Section 1 - Introduction | |||
Introduction Google Scripts – Getting Started With Apps Script | 00:00:00 | ||
Google Forms Setup | 00:00:00 | ||
Send Email Via Script | 00:00:00 | ||
Setup Trigger For Automation Of Scripts On Event | 00:00:00 | ||
Copy To Another Sheet | 00:00:00 | ||
Copy Content On Submit | 00:00:00 | ||
Sheet Data Sorter | 00:00:00 | ||
Check Sheet Data For Value | 00:00:00 | ||
Quick Fixes And Updates | 00:00:00 | ||
Update Spreadsheet UI | 00:00:00 | ||
Conclusion Spreadsheet Data | 00:00:00 | ||
Automate Spreadsheet Data Using Google Script – Source Codes | 00:00:00 |