Cuiar
Sign inDownload

Fill in each new row of a sheet

The missing fields from official sources, with a source link for each value.

  • On an event: When a row is added to the sheet
Use in CuiarRun from your AI agent

What it does

The task

Read the new row in the Google Sheet sheet url. Use the value in column A to find the data for the empty columns: columns. Use the official website first, then other public sources. Write each value in its column, and the source link in the Source column. Leave a cell empty when you are not sure.

  • It works in Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • A routine checks every 15 minutes and acts on what is new: when a row is added to the sheet.

What you give it

BlankWhat to giveExample
sheet urlThe Google Sheet to watchhttps://docs.google.com/spreadsheets/d/1En7cWr4Kx/edit
columnsThe columns to fill in, separated by commasWebsite, Employees, Headquarters, Founded

What you get back

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

New row 218: Kestrel Analytics

Website: kestrel.io (official site)

Employees: 120 to 150 (company LinkedIn page)

Headquarters: Manchester, UK (Companies House)

Founded: 2017 (Companies House)

Source column: 3 links added

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 sheet url and columns. Tab moves to the next blank.

  3. 03

    Run it, then repeat it

    Run sends it once. To run it when a row is added to the sheet, make a routine on cuiar.com/routines or with the CLI below.

As a routine, from the terminal

cuiar routines create "Fill in each new row of a sheet" --schedule "*/15 * * * *" --time-zone Europe/Berlin \
  "Read the new row in the Google Sheet https://docs.google.com/spreadsheets/d/1En7cWr4Kx/edit. Use the value in column A to find the data for the empty columns: Website, Employees, Headquarters, Founded. Use the official website first, then other public sources. Write each value in its column, and the source link in the Source column. Leave a cell empty when you are not sure."

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 create_routine 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 create_routine to run my "Fill in each new row of a sheet" template with sheet url = https://docs.google.com/spreadsheets/d/1En7cWr4Kx/edit; columns = Website, Employees, Headquarters, Founded.

Setup for other agents: AI agents.

The tool call

{
  "name": "create_routine",
  "arguments": {
    "name": "Fill in each new row of a sheet",
    "task": "Read the new row in the Google Sheet https://docs.google.com/spreadsheets/d/1En7cWr4Kx/edit. Use the value in column A to find the data for the empty columns: Website, Employees, Headquarters, Founded. Use the official website first, then other public sources. Write each value in its column, and the source link in the Source column. Leave a cell empty when you are not sure.",
    "schedule": "*/15 * * * *",
    "time_zone": "Europe/Berlin"
  }
}

Related templates

All data templates