Cuiar
Sign inDownload

Group open survey answers into themes

Each open answer tagged with themes, with counts, shares, example answers and a short summary.

  • You start it: When you start it
Use in CuiarRun from your AI agent

What it does

The task

Open the responses sheet of the form form url, and read the answers to the question question. Read all the answers first, then make a list of 6 to 12 themes. Tag each answer with one or two themes in a new column, and mark empty or unclear answers as No theme. Add a tab with each theme, its count, its share and 3 short example answers. Write a summary of 8 lines or fewer about the largest themes. Do not change the answers.

  • It works in Google Forms and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • It runs once, when you start it.

What you give it

BlankWhat to giveExample
form urlThe link to the Google Form or its responses sheethttps://docs.google.com/forms/d/1Sv8mQr2Kd/edit
questionThe open question to analyzeWhat is the one thing we should improve?

What you get back

An example run with the example values above. Your run uses your own data.

Answers read: 1,037 to 'What is the one thing we should improve?'

Themes: 9

ThemeAnswersShare
Faster delivery28828%
More vegan options19719%
Less packaging14314%
App crashes at checkout969%

No theme: 61 (empty or unclear)

Summary: delivery speed is the top issue in all regions. App crashes appear only after the September update.

Sheet: new column Theme, new tab Themes

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 2 blanks

    Type form url and question. Tab moves to the next blank.

  3. 03

    Run it

    Run sends it to the agent. Follow each step in the panel, and stop it at any time.

From the terminal

cuiar exec "Open the responses sheet of the form https://docs.google.com/forms/d/1Sv8mQr2Kd/edit, and read the answers to the question What is the one thing we should improve?. Read all the answers first, then make a list of 6 to 12 themes. Tag each answer with one or two themes in a new column, and mark empty or unclear answers as No theme. Add a tab with each theme, its count, its share and 3 short example answers. Write a summary of 8 lines or fewer about the largest themes. Do not change the answers."

Run it from your AI agent

Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.

1. Add Cuiar to Claude Code

claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp

2. Ask your agent

Use the Cuiar tool run_task to run my "Group open survey answers into themes" template with form url = https://docs.google.com/forms/d/1Sv8mQr2Kd/edit; question = What is the one thing we should improve?.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Open the responses sheet of the form https://docs.google.com/forms/d/1Sv8mQr2Kd/edit, and read the answers to the question What is the one thing we should improve?. Read all the answers first, then make a list of 6 to 12 themes. Tag each answer with one or two themes in a new column, and mark empty or unclear answers as No theme. Add a tab with each theme, its count, its share and 3 short example answers. Write a summary of 8 lines or fewer about the largest themes. Do not change the answers."
  }
}

Related templates

All data templates