Google Apps Script Tutorial: How to Use ChatGPT In Google Sheets?
In this video, - I will show you how to integrate ChatGPT with Google Sheets using Apps Script. - You'll create GPT_SUMMARY and GPT_SIMPLIFY formulas that can be used to summarize and simplify large chunks of passages in Google Sheets. - You'll also create a menu with the same formula features. - This video is perfect for anyone who wants to learn how to use ChatGPT to automate their work in Google Sheets. - The video includes step-by-step instructions, as well as code. You can find the blog version of this video, I've written at FreeCodeCamp here: https://www.freecodecamp.org/news/create-chat-gpt-formulas-in-google-sheets/. ## Chapters 00:00 - intro 01:20 - Get Chat Gpt API key 02:00 - Fetch Data From Chat GPT 06:45 - More Info On Custom Functions 07:05 - GPT SIMPLIFY Formula 10:21 - GPT SUMMARY Formula 11:25 - GPT API Rate Limit 12:08 - Formula & Auto Refresh Issue 12:40 - GPT Simplify In Menu 15:20 - Adding Function To The Spreadsheet UI 17:20 - GPT Summary In Menu 18:22 - Conclusion ## Links 1. ChatGPT API Docs: https://platform.openai.com/docs/api-reference/chat/create 2. GitHub Source Code: https://github.com/nibukdk/GPT_Google_Sheets_Integration/tree/main 3. Custom Functions In GSheets: https://developers.google.com/apps-script/guides/sheets/functions 4. Spreadsheet With Apps Script: https://developers.google.com/apps-script/reference/spreadsheet 5. URLFetchApp: https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app ## For inquiries: 1. Linkedin: https://linkedin.com/in/nibesh-khadka 2. My Website: https://nibeshkhadka.com/ 3. Email: me@nibeshkhadka.com ## Blogs Check out my blogs at https://kcl.hashnode.dev. ## Hire Me I can automate your Google Workspace apps like Gmail, Gsheets, GDocs, GDrive, etc. as you need. I can also create workspace addons, web apps, and RESTful API using Google Apps Script. I'll provide high-quality service. Whatever, your needs are, do not hesitate to get in touch.
In this video, - I will show you how to integrate ChatGPT with Google Sheets using Apps Script. - You'll create GPT_SUMMARY and GPT_SIMPLIFY formulas that can be used to summarize and simplify large chunks of passages in Google Sheets. - You'll also create a menu with the same formula features. - This video is perfect for anyone who wants to learn how to use ChatGPT to automate their work in Google Sheets. - The video includes step-by-step instructions, as well as code. You can find the blog version of this video, I've written at FreeCodeCamp here: https://www.freecodecamp.org/news/create-chat-gpt-formulas-in-google-sheets/. ## Chapters 00:00 - intro 01:20 - Get Chat Gpt API key 02:00 - Fetch Data From Chat GPT 06:45 - More Info On Custom Functions 07:05 - GPT SIMPLIFY Formula 10:21 - GPT SUMMARY Formula 11:25 - GPT API Rate Limit 12:08 - Formula & Auto Refresh Issue 12:40 - GPT Simplify In Menu 15:20 - Adding Function To The Spreadsheet UI 17:20 - GPT Summary In Menu 18:22 - Conclusion ## Links 1. ChatGPT API Docs: https://platform.openai.com/docs/api-reference/chat/create 2. GitHub Source Code: https://github.com/nibukdk/GPT_Google_Sheets_Integration/tree/main 3. Custom Functions In GSheets: https://developers.google.com/apps-script/guides/sheets/functions 4. Spreadsheet With Apps Script: https://developers.google.com/apps-script/reference/spreadsheet 5. URLFetchApp: https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app ## For inquiries: 1. Linkedin: https://linkedin.com/in/nibesh-khadka 2. My Website: https://nibeshkhadka.com/ 3. Email: me@nibeshkhadka.com ## Blogs Check out my blogs at https://kcl.hashnode.dev. ## Hire Me I can automate your Google Workspace apps like Gmail, Gsheets, GDocs, GDrive, etc. as you need. I can also create workspace addons, web apps, and RESTful API using Google Apps Script. I'll provide high-quality service. Whatever, your needs are, do not hesitate to get in touch.