Get started with SheetAI App
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
Get started with SheetAI AppGet StartedInstall the add-on (1 min)Create OpenAI Account and get API key (4 min)Setup API key to SheetAI App (2 min)SheetAI ExamplesSHEETAI functionSHEETAI_LIST functionSHEETAI_TABLE functionSHEETAI_EDIT functionSHEETAI_TAG functionSHEETAI_EXTRACT functionSHEETAI_TRANSLATE functionSHEETAI functionSHEETAI_FILL functionGeneral Functions Settings
Install the add-on (1 min)
- Go to the installation page
- Click on the Install button
- Click on Continue
- Pick your Google account
- Allow the requested permissions
- And you’re done!
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.
- Create an account at https://platform.openai.com/signup
- Click Create new secret key
- Copy it to your clipboard
Setup API key to SheetAI App (2 min)
Just visit sheet.new (to create new google sheet) and then Extensions > SheetAI App > Launch
SheetAI Examples
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:
Add some temperature for more creativity:
SHEETAI_LIST function
If you want the AI response to be listed, take up multiple cells in a Google Sheet.
SHEETAI_TABLE function
Like GPT, but outputs the results in a table. Very practical when the output is a table.
SHEETAI_EDIT function
Edit your text:
SHEETAI_TAG function
Apply all relevant tags:
SHEETAI_EXTRACT function
Extract email addresses or country:
SHEETAI_TRANSLATE function
Translate from English to Hindi:
SHEETAI function
Summarise a text:
SHEETAI_FILL function
Populate descriptions in a product catalog:
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.
