If you want to automate some drudgery in Google Sheets, Flowshot is a good choice. This AI plugin for Google Sheets can automate tasks, create formulas and images, and even train your own AI models. With features like AI prompts, autocomplete, and integration with Zapier, it's a good way to get some help without having to understand how AI models work.
For a broader integration, GPT Workspace brings ChatGPT and Gemini to your Google Workspace, automating tasks in Google Sheets, Docs, Slides, Gmail and Google Drive. It can categorize data, summarize and extract data in Sheets, create content and slides, and improve grammar in Docs. It offers free and premium tiers, so it's useful and adaptable.