Mehran Jalali Profile picture
Dec 28, 2022 9 tweets 3 min read Read on X
I spent the last 2 weeks building the ultimate AI assistant for spreadsheets.

It can:
- Autofill entire sheets just based off context
- Generate formulas and filter rows using text commands
- Directly integrate GPT-3 into your sheets
And more…

Here are a few examples:

(1/8)
2/ SMART AUTOFILL

Automatically fill out tables with relevant formulas and text to perform complex tasks, just based off of context.

Examples:
- Calculating tax owed given marginal tax brackets
- Doing some bookkeeping
- Projecting revenue from a prompt

(In beta for now)
3/ FACTUAL AUTOFILL

Fill out tables with factual information based on the header rows and columns.

Examples:
- Getting information about target companies
- Detecting the components of an address
- Autofilling information about an address
4/ GENERATE FORMULAS

You can describe a formula and it will generate it for you. From simple stuff that’s easier to describe than type out, to harder things incorporating regex, formulas based on contextual info, and sometimes stuff using functions you didn’t even know existed.
5/ FILTERING

Selectively keep/remove rows using natural language prompts. Remove duplicates, only keep submissions with proper email addresses, remove blank rows, etc.

Here’s an example of cleaning up form submissions and then filtering the results:
6/ =AI() and =INFER()

Directly incorporate GPT-3 (and soon GPT-4!) prompts into your spreadsheets using =AI(), or teach it what to do using =infer().

Examples:
- Extracting information from text
- Summarizing text
- Formatting phone numbers
- Categorizing customer feedback
7/ POPULATE

Fill in a column just based on the header. Save time filling out the header column, pulling data, writing out lists, etc.

A few examples:
I’ll be launching the assistant soon for both Google Sheets and Excel. If you wanna try it out, sign up here:
forms.gle/ygvFJX39BHsqBy…
Check out Numerous.ai!

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Mehran Jalali

Mehran Jalali Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @mehran__jalali

Sep 26, 2023
Last Saturday, 65 of us made a five-star steak dinner for 100+ guests at New York's highest-rated steakhouse: Mehran's Steak House

The full story:



Image
Image
Image
It all started in a hacker house in New York's Upper East Side. I started living there in November 2021 and started cooking steaks for people every other week. @tydannysaurus put the house as "Mehran's Steak House" on Google Maps, and all of our friends started leaving reviews Image
@tydannysaurus After a week, a couple walked into our house and asked for the steakhouse. We pretended like we didn't know what was going on, but realized that we could turn it into a real thing.

@rtwlz made a website with a waitlist, and a message that we're booked for several months Image
Read 16 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(