Jev for Sheets™
Google Sheets™ + TypeSafe Jev

Jev for Sheets™ — Setup

A TypeSafe account and API key are required. Open TypeSafe and manage API keys. TypeSafe API charges may apply.

Marketplace installation

Install Jev for Sheets™ from Google Workspace Marketplace. In each spreadsheet, choose Extensions → Add-ons → Manage add-ons → Jev for Sheets™ → Options → Use in this document before entering formulas. This Google per-document activation step is required even after account-level installation. Reload if Sheets still displays Unknown function.

Connect your TypeSafe account

  1. Open Extensions → [your Jev script/add-on name] → API key & connection.
  2. Review and grant Google's requested permissions for the installed project.
  3. Enter your TypeSafe API key and, optionally, a label for your own reference. Click Save key. Saving another key replaces the saved key, but does not change existing spreadsheet connections.
  4. Click Test saved key. This makes one small API request using sample data.
  5. Read the data-sharing and shared-usage disclosure, then click Connect this spreadsheet (or Update spreadsheet connection if it is already connected). Every collaborator's Jev formulas in this spreadsheet use that connected account.
  6. From the Extensions → Jev for Sheets™ menu, select Add sample worksheets to create Examples, Rubrics, and Tests without overwriting existing tabs, then select Refresh Jev formulas. You can also enter a formula directly.

Example: =JEV_NOUL("dog", "Is it a mammal?")

Formula inputs are sent to TypeSafe for processing. Save secrets only through the settings menu, not in cells or source code.

Change or remove a connection

After connecting, disconnecting, or replacing a connection, use Refresh Jev formulas. Nested expressions such as IF(JEV_NOUL(...),...) need manual re-entry. Changing input cells and referenced choices normally causes recalculation.

Removing your personal saved key does not disconnect spreadsheets that already hold its connection. Disconnect each spreadsheet separately or revoke the key in TypeSafe to disable it everywhere. See privacy and deletion.

Local installation for developers

For development, follow the repository's Local Installation instructions to build and install the script in one spreadsheet. Repeat for each additional spreadsheet and connect your TypeSafe account through that script's menu.

Questions about costs or data handling? Read the FAQ. For installation and formula errors, visit Support.