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
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.