Google Script How to Update Google Sheet data from a web App

Description

In this course, you will learn :

• output google sheets content
• send api requests to google script
• connect front end html and jQuery with backend Google Script

Syllabus :

Introduction to connecting Google Script with Apps

• Introduction to Google App Script and Google Sheets
• setup Google Script
• Write your first Google Script
• Create dialog and webapp of Google script output
• html output append and update styling with Bootstrap
• Coding exercise add UI item render HTML
• Output content from spreadsheet
• Output Sheet content as Data
• Loop data output array as HTML
• Sheet data in HTML table with inputs
• data passing using jQuery from element
• Class google.script.run (Client-side API)
• Update Google Spreadsheet from HTML
• Launch Webapp
• Styling Tweaks
• Source Code review