Skip to main content
You can easily bring JigsawStack directly in your Google Sheets. Analyze your data with real-time, AI-powered tools without writing a single line of code.

Check out our Google Sheets Demo to see how you can use JigsawStack in your Google Sheets.

​
Setting up

  1. Install the add on from the Google Sheets add-on page
  2. Get your API key from the JigsawStack dashboard
  3. In your Google Sheets, go to Extensions > JigsawStack > Set up API key
Image showcasing the setup API key on Google Sheets extension tab
  1. Paste your API key in the input field and click Save
Image of saving the API key on Google Sheets

​
How to use the add-on

You can call all of JigsawStack’s AI tools just like a regular spreadsheet formula. Here are a few examples which are shown with autocompletion: Examples of JigsawStack functions on Google Sheets

​
Parameters and Return Types

Each JigsawStack function has a set of parameters and a return type. You can find more information on each parameter by clicking on the dropdown menu in the custom function. Detailed parameters for custom functions

Warning: in the case where no description is shown, please click on the question mark icon next to the custom function.

Question mark icon next to the custom function

​
Error Handling

Errors are shown by hovering over the cell with the error. We try out best to provide a clear error message but there are some limitations from Google Sheets. Here is an example of an error message with incorrect parameters passed: Error message with incorrect parameters

Note: Loading will also show a similar error message. This is unavoidable and is due to the way Google Sheets handles custom functions.

Loading error

​
Cache

​
Refreshing a specific cell

By default JigsawStack’s results are automatically cached in your sheets. To refresh the value of a specific cell,
  • Click on the Cell you want to refresh
  • On the keyboard type cmd + r (or ctrl + r for Windows)
This will trigger a new call to our API, refreshing the value of that cell.

​
Refreshing an entire sheet

You can also refresh ALL cell in a sheet by navigating to Extensions > JigsawStack > Refresh All Formulas

Note: Refresh All Formulas, will clear all your existing cache.

⌘I