Overview
What the add-on does
Chokmi turns Google Sheets into a qualitative research workspace. Users can import survey data, code open-text responses, run spreadsheet AI functions, highlight PII, and generate research outputs such as evidence tests, narratives, and bias checks inside the current spreadsheet.
Permissions
Permissions requested
- spreadsheets.currentonly: read and update the active spreadsheet only.
- script.container.ui: render the sidebar, menu items, and home card UI inside Google Sheets.
- script.external_request: call the Chokmi API for import, coding, analysis, and authentication-backed operations.
Reviewer flow
Suggested review flow
- Install the add-on and open a Google Sheet.
- Open Extensions and launch Chokmi Research Studio for Google Sheets.
- Use the reviewer credentials supplied separately in the Google submission materials.
- Open the sidebar and confirm the survey dropdown loads.
- Select a survey and run the import flow to populate the Responses and Code Here tabs.
- Open the Chokmi menu and run the sidebar or menu actions, such as reactive coding setup or PII highlighting.
- Enter a formula such as =CHOKMI_SENTIMENT(A2) or =CHOKMI_PII_CHECK(A2, TRUE).
- Use a survey-backed function such as =CHOKMI_EVIDENCE("Young people are more dissatisfied") after a survey has been selected in the sidebar.
Function context
Functions that need survey context
Some functions only need the cell input. Others depend on imported survey structure or stored analysis state.
Cell- or range-based functions
These operate primarily on the provided cell inputs:
- SENTIMENT
- CODE
- CONFIDENCE
- SUMMARIZE
- PII_CHECK
- PROFANITY_CHECK
- SIMILAR
- ANCHOR
- CLUSTER
- BETWEEN
- FINGERPRINT
Survey-backed functions
These depend on imported survey structure, metadata, or previously stored analysis state:
- CROSSTAB
- EVIDENCE
- BIAS_CHECK
- SATURATION
- TIMELINE
- NARRATIVE
- SILENCE
- VOICES
- HYPOTHESIZE
- OUTLIER
- CONTRADICT
- RIPPLE
- PERSONA
References