Flowshot can be used in two ways: with the sidebar, or with AI formulas.

Using the sidebar

The Flowshot sidebar is the easiest way to use AI with Google Sheets.

Autocomplete

Provide examples of what you want
Set accuracy vs creativity slider
Select the range of cells
Click "Autocomplete"

Use AI anywhere

Select your target cell
Write an instruction or a question
Click "Generate"

Create formula

Select your target cell
Describe the formula you want
Click "Generate"

Generate image

Select your target cell
Describe what's in your imagination
Click "Generate"

Using AI formulas

If you're comfortable with formulas, you can use the following:

Autocomplete

=COMPLETE(range, creativity)

Use examples to "autocomplete" the value of the targeted cell.

range: Select the range of inputs and outputs that correspond with the targeted cell
creativity (optional): Defaults to 0. Choose a creativity level from 0 to 100 — 0 is more accurate, while 100 is more creative

Examples

=COMPLETE(A1:C5, 0)
=COMPLETE(D10:H20, 90)

Use AI anywhere

=AI(prompt)

Write an instruction using text and cell/range references for the AI.

prompt: A string consisting of text and cell/range references, in plain language.

Examples

=AI("Write a thank you email to Jenny about her gift")
=AI("Translate the following sentence into", A1, ":", B1)
=AI(A1:C8, "What were the expenses in January?")

Create formula

=FORMULA(description)

Generate a Google Sheets formula using plain language.

Note: Due to Google Sheets restrictions, this will insert the formula into the cell but will not trigger. We are working on a workaround — until then, use the sidebar.

Generate image

=IMAGINE(description)

Generate an image using AI from a description.

Note: Due to Google Sheets restrictions, this formula does not function properly and we have temporarily disabled it. We are working on a workaround — until then, use the sidebar.

Updated on: 09/03/2023