|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/transform-your-spreadsheets-with-openai-api-and-apps-script/
课程评论：没有评论
课程名称：将人工智能集成到 Google 表格中（使用 Apps Script） 课程概述：本课程将教您如何使用 OpenAI API 和 Apps Script 将人工智能集成到您的 Google 表格中。您将学习如何构建 AI 驱动的电子表格，利用 AI 转变现有的表格，并创建能够自动化和增强数据分析的新应用。完成课程后，您将掌握将电子表格提升到新的水平的知识和技能，释放人工智能在工作流程中的潜力。您将能够构建：在 Google 表格中启用 AI 的网络应用、无缝的 Google 表格与 AI 集成、帮助您更快速完成工作的内部工具。 课程内容概览： - 引言：介绍课程及三大支柱：人工智能、API 和电子表格；讲解 OpenAI API 及如何获取 API 密钥；展示使用 OpenAI API 构建的 AI 驱动的表格和应用的示例；讨论在电子表格中使用人工智能的利弊。 - 人工智能概念：讲解 OpenAI API 中使用的人工智能概念，如温度和 top_p；讨论人工智能如何用于生成文本、回答问题等。 - API 概念：解释 API 及其工作原理；概述 UrlFetchApp 及如何使用它访问 OpenAI API；提供 OpenAI API 与 Google 表格的快速入门教程。 - 提示工程：解释提示工程及其与 OpenAI API 的工作原理；提供有效提示的写作技巧及在表格中的存储方法；展示提示工程的实例，如回答问题和生成文本；通过提示工程构建项目，如城市描述生成器或 Google 表格中的 ChatGPT 克隆。 通过本课程，您将能够提升您的工作效率，发挥人工智能技术的强大作用。
This course will teach you how to integrate AI into your Google Sheets using OpenAI API and Apps Script. You will learn how to build AI-powered spreadsheets, transform your existing sheets with AI, and create new apps that utilize AI to automate and enhance your data analysis.By the end of the course, you will have the knowledge and skills to take your spreadsheets to the next level and unlock the power of AI in your workflow.You'll be able to build:AI enabled web apps in Google SheetsSeamless ai google sheets integrationInternal tools for your business to help you do more, fasterGetting Started:Introduction to the course and the three pillars: AI, API, and SheetsExplanation of OpenAI API and how to obtain an API keyExamples of AI-powered Sheets and apps built using OpenAI APIPros and cons of using AI in SheetsAI Concepts:Explanation of AI concepts used in OpenAI API, such as temperature and top_pDiscussion of how AI can be used in Sheets to generate text, answer questions, and moreAPI Concepts:Explanation of APIs and how they workOverview of UrlFetchApp and how to use it to access OpenAI APIQuickstart tutorial on using OpenAI API with Google SheetsPrompt Engineering:Explanation of prompt engineering and how it works with OpenAI APITips for writing effective prompts and storing them in SheetsExamples of prompt engineering in action, such as answering questions and generating textProjects to build using prompt engineering, such as a city description writer or a ChatGPT clone in Google Sheets
