Get started with SheetAI App

Video preview
In this step by step docs, you will see how to use AI Inside Google Sheets, to run multiple variations of your prompts. In total it will take 8-10 min to get started then it will be as simple as opening any google sheet and running the function

Get Started

Install the add-on (1 min)

  • Click on the Install button
notion image
  • Click on Continue
notion image
  • Pick your Google account
notion image
  • Allow the requested permissions
notion image
  • And you’re done!
notion image

Create OpenAI Account and get API key (4 min)

To create OpenAI key we need to SignUp for OpenAI account and then verify with mobile number and then generate a key.
Creating OpenAI Account does not cost money, Initially you get $18 in credits which is enough to write 1000’s of 3000 letter blogs.
Video preview
 
notion image
notion image
  • Click Create new secret key
notion image
  • Copy it to your clipboard
notion image

Setup API key to SheetAI App (2 min)

Just visit sheet.new (to create new google sheet) and then Extensions > SheetAI App > Launch
notion image
 

SheetAI Examples

Video preview
SheetAI makes automating mundane tasks like text editing, generating multiple answers, and extracting information easily. With SheetAI, you can quickly and easily create taglines, apply tags, translate text, summarise, and populate data with dummy information.
Here is a List of SheetAI Functions with usage Examples.

SHEETAI function

Write a tagline:
notion image
Add some temperature for more creativity:
notion image

SHEETAI_LIST function

If you want the AI response to be listed, take up multiple cells in a Google Sheet.
Video preview
 
notion image

SHEETAI_TABLE function

Like GPT, but outputs the results in a table. Very practical when the output is a table.
Video preview

SHEETAI_EDIT function

Edit your text:
notion image

SHEETAI_TAG function

Apply all relevant tags:
notion image

SHEETAI_EXTRACT function

Extract email addresses or country:
notion image
notion image

SHEETAI_TRANSLATE function

Translate from English to Hindi:
notion image

SHEETAI function

Summarise a text:
notion image

SHEETAI_FILL function

Populate descriptions in a product catalog:
notion image
Clean up an email list, Clean up names, Generate dummy data and more.
 

General Functions Settings

you can set
  • response_token (which helps set the token limit for response initially it is 200 if need a larger output increase it. For English language, 1000 tokens are 750 words (source),
  • temperature: Controls Randomness, Lowering results in less Random Completion. As the temperature approaches zero model become deterministic and repetitive
  • mode: you can use all models “gpt-3.5-turbo”, “text-curie-001”, “text-babbage-001”, “text-ada-001”
  • cache: helps save openai credits in case of rerun of SheetAI function, it is saved in your secure google cache for 6 hours.
 
notion image