Digital Download: You will receive a download link via your order email
Should you have any question, please contact us: cs.hodollar@gmail.com
Stone River Elearning – Google Script Form Submission Response and Spreadsheet Data
Stone River Elearning – Google Script Form Submission Response and Spreadsheet Data
Explore how you can submit data to Google Spreadsheet, update the data and send emails on form submission
Please note this course covers how to use Google Apps Script to automate and increase productivity within gSuite – Coding is required
Google Apps Script is based off JavaScript and you can write code online in the online editor, only requirement is a Google Account to get ed.
This is a coding course! – JavaScript experience is a prerequisite to write Google Apps Script code.
Using Spreadsheets to track data
Setting up triggers of scripts to automate content
Coding includes below :
- 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.
Step by step learning
Fast friendly support is always available within the Q&A section
Experienced instructor with over 20 years of experience ready to help you learn
You have nothing to lose – Join now and learning to create your own version of this helpful application today!!!
Who this course is for:
- Web developers
- Application Developers
- Anyone who wants to learn to automate workflow with Spreadsheets
Requirements:
- JavaScript Experience
- Computer access
- Google Account
Course Curriculum
- Introduction Google Scripts. Getting ed with Apps Script (3:29)
- Google Forms Setup. (4:59)
- Send Email via Script. (9:03)
- Setup Trigger. For automation of scripts on event (7:05)
- Copy to another Sheet. (8:55)
- Copy content on Submit (4:33)
- Sheet data sorter. (4:38)
- Check Sheet Data for Value (7:17)
- Quick Fixes and Updates (2:13)
- Update Spreadsheet UI. (3:58)
- Conclusion Spreadsheet Data (3:59)
Sale Page: https://stoneriverelearning.com/p/google-script-form-submission-response-and-spreadsheet-data
Archive: https://archive.ph/wip/8aIbk
Shipping method
– After making a purchase, you will see a View your order link to the Downloads page. Here you can download all the files related to your order.
– In case the link is broken for any reason, please contact us and we will resend a new download link.
– If you can’t find the download link, please don’t worry about it. This course is usually available and shipped within one day
– The course you purchased will have lifetime access
– Our support staff is the best by far! Please contact us at email: cs.hodollar@gmail.com and we will be happy to help!