You can integrate ChatGPT with Google Sheets using SheetGPT, and a lifetime plan for a single user is on sale for $48.99 right now. SheetGPT connects Google Sheets to your OpenAI account, so you can write a prompt in a spreadsheet and generate responses in bulk.
SheetGPT includes a prompt library so you can see all the new ways to use ChatGPT in Google Sheets. The software specifications note that an OpenAI API key is required to use SheetGPT. To get that, you’ll just have to go into the settings of your OpenAI account and generate a new API key, and there may be a fee that’s paid directly to OpenAI when you enter your API key.
You can get a SheetGPT for a single user for $48.99 right now, though prices can change at any time.