This is a source code for tutorial on how to integrate ChatGPT with Google Spreadsheets using the GPT API and Google Apps Script. You can read the blog at freecodecamp from here.
There's also a youtube tutorial.
You'll be able to create two custom formulas, GPT_SUMMARY and GPT_SIMPLIFY. You can use GPT_SUMMARY to summarize a large passage or text into a few bullet points for easy reading. And you can use GPT_SIMPLIFY to simplify English into easy-to-read English.
You'll also create menus with access to functions that perform the same tasks as formulas.
By the end of this tutorial, you will understand how to use ChatGPT in Google Sheets with Google Apps Script. You will also be able to modify the formulas and menus to meet your own needs, such as creating CVs, social media posts, or cover letters.