|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/api-json-ajax-google-sheet-data/
课程评论：没有评论
课程名称：Google Sheet 数据作为 JSON 的 JavaScript AJAX Google Apps Script 课程概述： 您是否希望将 Google Sheet 作为网络应用程序的数据源？本课程将指导您使用 Google Apps Script 创建一个网络应用，将 Sheet 数据输出为 JSON。您将学习如何将网络应用作为 API 端点，从中获取 JSON 数据，并使用 AJAX 连接到您的 Google Sheet 数据，从而在网页上展示。 使用 Google Apps Script，您无需数据库即可将 Sheet 数据输出为 JSON，并通过前端代码直接获取 JSON 数据，实现简单的应用开发。课程中的编码项目将帮助您创建一个动态测验，使用 Google Sheet 数据作为问题来源。您将学习如何通过 fetch 请求连接到测验数据，获取 JavaScript 中的测验数据，构建无需后端代码的动态数据驱动测验。 请注意，此课程为编码课程，要求学员具备一定的编码经验。课程内容将教您如何使用 Google Script Web Apps 创建用户与 Google Workspace 之间的互动。您将获得以下内容的编码示例： - 使用 Google Apps Script 输出 Web 应用中的内容 - 客户端与服务器之间的连接与通信 - 将 Apps Script 变量输出到 Web 应用 - 输出 Sheet 内容为 JSON 到 Web 应用 - 使用 Web 应用上传本地文件到 Google Drive - 将 Google Docs 文件加载为 HTML 输出到 Web 应用 - 允许用户在 Web 应用中与 Sheet 内容交互 课程中会逐步讲解如何设置 Google Sheets 与 Web 应用，并通过 AJAX 获取数据到 JavaScript 代码中。您将使用 Google Apps Script 的 GET 和 POST 方法添加和检索 JSON 格式的数据。Apps Script 是 Google 平台上轻量级应用程序开发的脚本语言，旨在帮助您自动化任务并增强 Google 文档、表格和幻灯片的功能。 课程还包括快速友好的 Q&A 支持，以帮助您学习，源代码也将随课程提供！本课程由一位拥有超过 18 年开发经验的讲师教授，将带您从头到尾构建一个功能完善的 Web 应用，同时提供有用的提示和资源。 不要再犹豫，现在就加入我们，开始探索您可以使用 Google Apps Script 和 AJAX 实现的精彩应用吧！
Google Sheet Data as JSON JavaScript AJAX Google Apps ScriptAre you looking to use your Google Sheet as a Data source for your web applications?Create a web app with Google Apps Script to output your Sheet data as JSONWeb app can be used as an API endpoint to get JSON data from your Sheet contentUse AJAX to connect to your Google Sheet Data and output it in your web pages.Connect Google Sheets to your web applications.No Database needed for your content as JSON - you can use Google Apps Script to output the sheet data as JSON in a web app.No Server needed use frontend code to get the JSON data and use it in your web applications. Coding project - Create a dynamic quiz that uses Google Sheet data for questions.Connect to the quiz data from JavaScript with a fetch request to the web app URLGet the quiz data in JavaScript How to build a dynamic data driven quiz with no backend code needed.Please note that this is a coding course and previous coding experience is a prerequisite to the course.Have you ever want to get data from your Google Spreadsheet and use it in a web application?If yes then this course is perfect for you:)Explore how you can use Google Script Web Apps to create interaction between the user and your google Workspace. Web Apps - coding examples of Web apps with Google Apps Script how to output content into a web app- Client side to server side connections and communication- How to output Apps Script Variables to your Web App- Output Sheet contents as JSON to Web App with Google Apps Script- Upload files from your local computer to your Google Drive using a web app with Apps Script- Load you Google Docs file as HTML to be output to your Web App with Google Apps Script- Get Sheet data and allow the user to interact and get Sheet content within a Web AppOutput content with createHTMLOutput service, UrlFetchApp fetch to get URL data, How to use Web app parameters, createHtmlOutputFromFile, Utilities.newBlob, DriveApp.getFolderById, SpreadsheetApp.openById, HtmlService.createHtmlOutputFromFile, ContentService and more coding examples.Step by step instruction on how to setup Google Sheets with a web app outputting data as JSON. Use AJAX from your web application to get that data into your JavaScript code. Extend this even further using Google Apps Script. GET and POST to the Google Script web app adding and retrieving data in JSON format.Apps Script is a scripting language for light-weight application development in the G Suite platform..According to Google, Apps Script "provides easy ways to automate tasks across Google products and third party services." Apps Script is also the tool that powers the add-ons for Google Docs, Sheets and Slides. Power up your application with spreadsheet data no database required!!!!Fast and friendly support in the Q & A section to help you learnSource Code is included!!!Taught by an instructor with over 18 years development experience ready to help you learn.Exercise based course demonstrates building a fully functional web application from start to finish. Reviewing the code and providing useful tips and resources along the way. What are you waiting for join now and start exploring the amazing things YOU CAN DO with Google App Script and AJAX!!!
