Use powerful AI models like GPT-3 in Google Sheets. One formula to transform, extract, or summarize any text that works just like SUM or VLOOKUP and generates answers. Learn more: Website and Google Workspace Marketplace.You can use it for all sorts of tasks on text: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining, etc It is built on top OpenAI ChatGPT, GPT-3 and GPT-4 models.

It enables you to use ChatGPT directly in Google Sheets™ and Docs™. GPT for Sheets™ and Docs™ is an AI writer for Google Sheets™ and Google Docs™. GPT for Sheets and Docs is currently the ChatGPT extension with the highest number of installs and reviews. It was created by Talarian, maker of the super-popular “Yet Another Mail Merge” extension for Google Sheets. Here’s another more detailed post about how to connect ChatGPT To Google Sheets using Google Apps Script.Īnd here’s a video on this topic from yet another source: This concise blog post provides example code and a written tutorial for deploying it. Want to access ChatGPT from Google Sheets, but don’t want to use a third-party extension? Google Apps Script to the rescue!

Even though you can roll back changes in Google Sheets, we don’t recommend experimenting with these workflows in your Tiller-powered sheets until you’re sure they’re safe, private, and effective. To protect your privacy, always exercise caution when connecting third-party extensions, code, and templates to Google Sheets. So here are a few extensions and workflows for connecting ChatGPT and your Google Sheets. And if you want to start experimenting with natural language AI in your Google Sheets right now, ChatGPT is your best bet.

It may take the form of Bard, an AI chatbot based on LaMDA, which Google started working on back in 2015.īut even when Google has its own native AI tools available in Google Sheets, some people may prefer OpenAI’s ChatGPT. When Google brings generative AI to Google Sheets, it won’t be via OpenAI’s familiar ChatGPT. Later this spring, Microsoft Copilot will bring OpenAI’s ChatGPT to Microsoft 365, including Excel.Īnd Google is rapidly bringing generative AI to its entire Workspace suite, starting with Docs and Gmail.

Open csv in google sheets