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: [email protected]


## 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.