Use AI to generate formulas, categorize items, format cells, and perform repetitive tasks in Google Sheets.
The Numerous.ai Google Sheets plugin lets you use AI to perform repetitive tasks and use spreadsheets like a power user. Here’s how:
PROMPT CHATGPT IN YOUR SHEETS
Use the =AI() function directly in your spreadsheet similar to formulas like =SUM() and =AVERAGE() to directly feed prompts to ChatGPT.
- Want to summarize a customer support message? =AI(“Here’s a message from a customer:”, A2, “summarize it in 1-2 bulletpoints”)
- Need to figure out what state a phone number is from? =AI(“What state is the phone number”, A2, “from?”)
And then you can just drag the function down and automatically do that for a hundred more cells.
HAVE THE AI DO YOUR TIME-CONSUMING TASKS BY SHOWING IT A FEW EXAMPLES
If you need to do mind-numbing busywork like:
- Format hundreds of cells by hand
- Categorize a thousand items
- Do sentiment analysis on lots of messages
You can teach the AI by providing it with 4 or 5 good examples, and using the “Infer” function to complete it for all the other cells.
WRITE TEXT USING AI
- =WRITE("a tagline for the brand",A3,"mentioning its top features such as",B3)
- =WRITE(“a message to”, A2, “thanking them for”, B2)
You can have AI write text for you, just by telling it what you want.
GENERATE FORMULAS USING PLAIN ENGLISH
Just write out what you want and Numerous.ai will generate the formula to do it. This works for even the most complex formulas: from SUM, COUNTIF, AVERAGE, to VLOOKUP, QUERY, REGEX, and more.
EXPLAIN COMPLEX FORMULAS
If you’ve received a spreadsheet from a colleague and have no idea what the formulas do, you can use the “Explain formula” function, and it will tell you what the formula does in plain English.
_________________________________________________
The Numerous.ai Chrome extension makes the experience of using the plugin faster and better.
Here is a list of the extension's features:
LAUNCH NUMEROUS FASTER
The Numerous.ai extension allows you to launch Numerous's Google Sheets plugin faster. Since Numerous is most useful when you are aware of its capabilities and its features are surfaced to the forefront, a faster launch experience means that you will be able to utilize Numerous sooner and more frequently, thus allowing you to accomplish more tasks that are only enabled by the use of Numerous.
Latest reviews
- (2023-03-30) Agah Ebrahimi: The outputs are similar to or better than ChatGPT, because there’s no filler text before and after them
- (2023-03-24) Suraj Srivats: It’s really cheap for what it does. I bought 5000 tokens three weeks ago and still haven’t run out even though I use it every other day
- (2023-03-22) Josh F: I've been using Numerous for a few weeks now and I am still amazed by its capabilities -- so many monotonous tasks I used to do in Sheets can now all be automated with the =AI() command. Really has saved me hours and hours each month.
- (2023-03-22) Jonathan Shobrook: I used it to sift through a ton of submissions I got for a customer survey instead of giving it to the intern. Saved me and the intern a day of work, maybe two.
- (2023-03-22) Luke: I was initially having issues, but I contacted support and Mehran was extremely helpful over email. Huge huge fan. 10x'd my work once it started working!
- (2023-03-17) Vanisha Kudumuri: Originally downloaded it for the formula generations, but now I can’t live without the =AI function. It’s like ChatGPT on steroids
- (2023-03-17) David Tesler: I had a huge waitlist and I needed to prioritize onboardings based on how excited people sounded, and I managed to do that with =AI() after a few tries
- (2023-02-22) PRODlGY Forums: Helped me clean up a form (reformat some phone numbers, extract names from paragraphs, summarize messages) in just a few minutes. Would've taken me hours to do by hand. Thank you!
- (2023-02-19) Bullmeza: Game changer