You can improvise this by providing roles in system content, and tasks as well as data as two different user roles in our FetchData() function. Note: Since this is not a tutorial on how to use ChatGpt optimally, I provided instructions as the system content instead of role-play, and then just provided data in the user content. The main thing to notice here is the different system content. Input.flat().map(text => fetchData(systemContent, text)) : Provide atleast 3 and atmost 5 bullet points." const CHAT_GPT_API_KEY = "paste your API key here" įunction fetchData(systemContent, userContent) input The value to summarize.Ĭonst systemContent = "Summarize the given text. We'll create a function called fetchData here. Let's open the app script for this spreadsheet, rename it to GPT_integration, and also rename the existing file to utils.gs. I have named my spreadsheet GPT_Integration with three columns: Passage, Simplified Passage, and Summarized Text. Step 2 – Fetch the Data From the ChatGpt API with Apps Script Spreadsheet Sample You will not be able to see this API key again, so be sure to copy it somewhere safe. Once you have an account, you can create a new API key by going to the API keys section under the User tab.Ĭlick the Create new secret key button and copy the key after it has been created. Step 1 – Get the ChatGPT API Key Get ChatGpt API Keyįirst, if you don't already have an account with OpenAI, you'll need to create one. If you are new to either of these, I recommend that you start with a beginner tutorial before attempting this one. This tutorial is for intermediate to advanced users who have a basic understanding of Apps Script and JavaScript. This is also not a tutorial on how to use and optimize ChatGPT – instead we'll focus on how to integrate GPT in Google Sheets. I will not be explaining every method or classes used in the code. “These new AI features will begin rolling out on Google Search soon.This tutorial is not meant for beginners in Apps Script or JavaScript. Pichai added: “Soon, you’ll see AI-powered features in Search that distill complex information and multiple perspectives into easy-to-digest formats, so you can quickly understand the big picture and learn more from the web: whether that’s seeking out additional perspectives, like blogs from people who play both piano and guitar, or going deeper on a related topic, like steps to get started as a beginner. Sign up here to get the latest marketing news sent straight to your inbox each morningĪs well as introducing a chatbot AI, Google will also launch new AI tools for its search engine. “Bard can be an outlet for creativity, and a launchpad for curiosity, helping you to explain new discoveries from NASA’s James Webb Space Telescope to a 9-year-old, or learn more about the best strikers in football right now, and then get drills to build your skills.” “It draws on information from the web to provide fresh, high-quality responses. “Bard seeks to combine the breadth of the world’s knowledge with the power, intelligence and creativity of our large language models,” Alphabet and Google CEO Sundar Pichai said. A Google engineer told the BBC that the tech giant’s AI is so “human-like in its responses” that he believed it was sentinent. An offshoot of Artificial Intelligence, software like that of Chat GPT and Bard, use algorithms and preexisting content to create text, images, code, video and more.īard is reportedly built on Google’s pre-existing language model Lamda. The news comes as many marketers begin to question whether ‘Generative AI’ can create better content than humans and as a result replace people in the marketing profession. Google has announced that it will launch an Artificial Intelligence (AI) chatbot technology called Bard to rival OpenAi’s Chat GPT.īard is set to be used by a group of testers before being released to the public in the coming weeks, according to the BBC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |