Loading video...

Video Failed to Load

Go Home

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)

1,143,209 views • 3 years ago •via X (Twitter)

11 Comments

Mehran Jalali's profile picture
Mehran Jalali3 years ago

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)

Mehran Jalali's profile picture
Mehran Jalali3 years ago

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

Mehran Jalali's profile picture
Mehran Jalali3 years ago

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.

Mehran Jalali's profile picture
Mehran Jalali3 years ago

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:

Mehran Jalali's profile picture
Mehran Jalali3 years ago

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

Mehran Jalali's profile picture
Mehran Jalali3 years ago

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:

Mehran Jalali's profile picture
Mehran Jalali3 years ago

I’ll be launching the assistant soon for both Google Sheets and Excel. If you wanna try it out, sign up here:

Mehran Jalali's profile picture
Mehran Jalali3 years ago

Check out

Zack's profile picture
Zack3 years ago

GPT 3 data fills are very bad past superficial, popular data. It loves to invent new seemingly realistic data, even with prompts that explicitly say otherwise (dangerous!) Eg: It made up a list of hotels in attached image

Ishan Goswami's profile picture
Ishan Goswami3 years ago

Man this feels pretty dope! Do you have a landing page where I can get to know more about it?

Mehran Jalali's profile picture
Mehran Jalali3 years ago

Just this thread for now. Sign up to check it out soon!

Related Videos