Cuiar
Sign inDownload

Extract study results into a table

Design, sample size, outcome and effect size with confidence interval from each paper, in one sheet.

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

What it does

The task

Open each paper in paper list. Read the methods, the results and the tables. For each study, record the authors, the year, the country, the design, the number of people, the groups compared, the result for outcome, the effect size with its 95% confidence interval, and the table or page where you found it. Put one row for each study in a new Google Sheet. Do not calculate values that the paper does not report: write Not reported.

  • It works in PubMed, Google Scholar 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
paper listLinks, DOIs, or a Google Doc with the list of papershttps://docs.google.com/document/d/1Lt8yQw2Hc/edit
outcomeThe result to extract from each studyHbA1c change after 12 months, in %

What you get back

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

Studies read: 18 of 18

AuthorsYearDesignPeopleEffect (95% CI)Where
Okafor et al.2021Randomized trial240-0.42 (-0.61 to -0.23)Table 2
Lindqvist and Berg2022Randomized trial118-0.30 (-0.58 to -0.02)Table 3
Marsh et al.2023Cohort1,904Not reported (p < 0.05 only)Results, p. 6

Not reported: 3 studies give no confidence interval

Sheet: Study table, 18 rows, 12 columns

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 paper list and outcome. 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 each paper in https://docs.google.com/document/d/1Lt8yQw2Hc/edit. Read the methods, the results and the tables. For each study, record the authors, the year, the country, the design, the number of people, the groups compared, the result for HbA1c change after 12 months, in %, the effect size with its 95% confidence interval, and the table or page where you found it. Put one row for each study in a new Google Sheet. Do not calculate values that the paper does not report: write Not reported."

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 "Extract study results into a table" template with paper list = https://docs.google.com/document/d/1Lt8yQw2Hc/edit; outcome = HbA1c change after 12 months, in %.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Open each paper in https://docs.google.com/document/d/1Lt8yQw2Hc/edit. Read the methods, the results and the tables. For each study, record the authors, the year, the country, the design, the number of people, the groups compared, the result for HbA1c change after 12 months, in %, the effect size with its 95% confidence interval, and the table or page where you found it. Put one row for each study in a new Google Sheet. Do not calculate values that the paper does not report: write Not reported."
  }
}

Related templates

All data templates

  • ResearchOdyssey

    Estimate the size of a market

    A top-down and a bottom-up estimate, with the source for each number and each step of the math.

    You start it: When you start it
    • Any government site
    • Google Scholar
    • Google Sheets

  • ResearchOdyssey

    Write a literature review on a research question

    Recent studies grouped by theme, what they agree on, where the evidence is weak, and a full reference list.

    You start it: When you start it
    • Google Scholar
    • Semantic Scholar
    • PubMed
    • +1 more: Google Docs

  • ResearchOdyssey

    Find what studies say about a treatment

    The best evidence for and against, the size of the effect, the side effects and questions for your doctor.

    You start it: When you start it
    • PubMed
    • Google Scholar

  • Data

    Turn a list on a website into a sheet

    Each item from each page, one row for each, with no duplicates.

    You start it: When you start it
    • Any website
    • Google Sheets

  • Data

    List local businesses with their contacts

    Name, address, phone, website, rating and e-mail for each business.

    You start it: When you start it
    • Google Maps
    • Google Sheets

  • Data

    Export your order history

    For stores with no export: each order in a sheet, with totals for each year.

    You start it: When you start it
    • Any online store
    • Google Sheets