Cuiar
Sign inDownload

Prepare a CSV for import into another tool

Your data mapped to the import template of the target tool, checked against its rules, saved as a CSV.

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

What it does

The task

Open the sheet sheet url. Find the import template and the import rules of target tool in its help pages: the required columns, the formats, the allowed values and the size limits. Map each column of my sheet to a column of the template, and list the mapping. Convert the values to the required formats, and list each row that breaks a rule. Save the result as a CSV file named file name. Do not import anything.

  • It works in Google Sheets and any admin panel, 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
sheet urlThe Google Sheet with your datahttps://docs.google.com/spreadsheets/d/1Im5bRt2Qy/edit
target toolThe tool and the type of importShopify product import
file nameThe name of the CSV file to saveproducts-import-2026-10.csv

What you get back

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

Target: Shopify product import CSV

Mapping: 11 of 13 columns matched. 'Colour' to Option1 Value, 'Cost' to Cost per item

Not mapped: 'Supplier code' and 'Notes' (no matching Shopify column)

Converted: 412 prices to 2 decimals, 96 handles made from titles, weights to grams

Rows that break a rule: 7 (no title on 3 rows, an image link without https on 4)

File saved: products-import-2026-10.csv, 405 products, 1,138 variant rows

Nothing imported.

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 3 blanks

    Type sheet url, target tool and file name. 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 sheet https://docs.google.com/spreadsheets/d/1Im5bRt2Qy/edit. Find the import template and the import rules of Shopify product import in its help pages: the required columns, the formats, the allowed values and the size limits. Map each column of my sheet to a column of the template, and list the mapping. Convert the values to the required formats, and list each row that breaks a rule. Save the result as a CSV file named products-import-2026-10.csv. Do not import anything."

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 "Prepare a CSV for import into another tool" template with sheet url = https://docs.google.com/spreadsheets/d/1Im5bRt2Qy/edit; target tool = Shopify product import; file name = products-import-2026-10.csv.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Open the sheet https://docs.google.com/spreadsheets/d/1Im5bRt2Qy/edit. Find the import template and the import rules of Shopify product import in its help pages: the required columns, the formats, the allowed values and the size limits. Map each column of my sheet to a column of the template, and list the mapping. Convert the values to the required formats, and list each row that breaks a rule. Save the result as a CSV file named products-import-2026-10.csv. Do not import anything."
  }
}

Related templates

All data templates