: Boost Your Google Sheets Productivity is an AI-powered spreadsheet plugin for Google Sheets. It offers several features that help users extract text, categorize data, generate formulas, and use ChatGPT directly within their spreadsheets.

To use with Google Sheets, you first need to install the add-on from the Google Workspace Marketplace. Once you have installed the add-on, you can use its various features. One of the standout features of is the ability to generate formulas using plain English. You can simply write out what you want, and will generate the formula to do it. This feature works for even the most complex formulas, from SUM, COUNTIF, AVERAGE, to VLOOKUP, QUERY, REGEX, and more. Additionally, you can explain complex formulas using If you’ve received a spreadsheet from someone and have no idea what the formulas do, you can use to explain them.

Apart from generating formulas, offers several other features that make it a useful tool for Google Sheets users. For instance, it allows users to extract text, categorize data, and summarize text into bullet points. Users can also use ChatGPT directly within their spreadsheet to prompt AI to make educated guesses and extract specific parts of the text. These features can save users time and effort while working with spreadsheets.


Let’s explore on Google Sheets. Just open on the browser and click on install. It will ask for Excel or google sheets. As we are exploring on google sheets go with google sheet

In the next step, it will ask for the email address for the google sheets and permissions for the google sheets.


 Allow the asked permissions and it’s done. is installed for Google Sheets. You can find this in Google Sheets’ extension.

We have the initial sheet as follows


1. Generate formulas is an artificial intelligence tool that can generate formulas for users. Users can describe the formula they want using plain English and the AI will write the formula for them.

formula generation
use of formula in the sheet

2. Explain the formula

when we see a sheet having complex formulas, the most tedious task is to understand the formulas, this could be done easily now with

Formula Explanation

3.AI formula generator

It has an AI formula generator in which we can easily customize our formula as a chatGPT prompt. Given below is an example of an AI formula generator.


4. Reformat

It has a feature of reformating the data stored in columns. Using this feature one can easily format the data of any column in any required format.

Input to change the format
Reformatted format

5. Sentiment Analysis

Sentiment analysis, also known as opinion mining or emotion AI, is the process of analyzing digital text to determine the emotional tone of the message, whether it is positive, negative, or neutral. Sentiment analysis makes use of natural language processing, text analysis, computational linguistics, and biometrics to systematically identify, extract, quantify, and study affective states and subjective information. It can also do sentimental analysis by parsing the data stored in cells.

Input for sentimental analysis
The output of the sentimental analysis

7. Rewrite the Text

It can easily re-write the text from cells in the format we want. Formats like brief description, professional, funny, etc.

Input to rewrite
Output after Rewrite

8. Translate

It can translate one text from one language to another. below is an example of one such use case.

Hindi translated text

9. Basic Educated Guesses

It can make basic guesses like guessing of name from the email. extracting names from email is a common use case that could be easily solved using

Name extracted

10. Can Generate result from custom query

We can use formula as chatGPT command to get the desired result. In the below example, we tried to get the length of names using formulas.



Some of the standout features of include generating formulas using plain English, explaining complex formulas, extracting text, categorizing data, and summarizing text into bullet points. These features can save users time and effort while working with spreadsheets, making a useful tool for Google Sheets users.

Follow for more content.

Leave a Reply

Your email address will not be published. Required fields are marked *