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.

Note: 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
Setup API key
  1. Paste your API key in the input field and click Save
Save API key

​
How to use the add-on

You can call all of JigsawStack’s AI tools just like a regular spreadsheet formula. Every function starts with: 
=JSS_FUNCTION_NAME(parameter1, parameter2, ...)
For example: 
=JSS_SEARCH("What is the capital of France?")
=JSS_TRANSLATE("Hello, how are you?", "fr")

​
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

Some functions have different return_type which the user can choose from.

​
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