Free agents + LAUNCH30: 30% off paid agents until 31 Dec 2026 (one-time purchases only) See free agents
Oarsman AI Sign in

IndiaMART Leads to Google Sheets / Docs

IndiaMART Leads to Google Sheets: setup guide

Each pull becomes an updated leads.csv for Google Sheets with your notes kept, plus buyers.csv with repeat buyers merged and a short report.

Who it is for: Indian manufacturer, trader or distributor on an IndiaMART paid plan who gets 10-200 leads a week and tracks them in Excel, Google Sheets or a notebook.

Format: Claude skill pack · Version: 1.0.1 · Tested on: Python 3.13.5 (standard library only)

What it does

Leads are read from Pull API answers (or Push API bodies) and cleaned: escaped line breaks, query types (W, B, P, BIZ, WA) as plain labels, and quantity, unit and probable order value pulled out of the message. The same lead from overlapping pulls is kept once (UNIQUE_QUERY_ID), and buyers are merged by mobile, or by email. Your earlier sheet is kept as it is, with your status, notes and extra columns; only new leads are added. With --pull it calls the Pull API with your own key (up to 7 days). The key is never printed or saved.

What you need

  • An IndiaMART paid seller account with the Leads API (Pull API) add-on
  • Claude.ai with code execution switched on (or Claude Code, or just Python 3.10+)

5-minute setup

  1. Claude.ai: open Settings → Capabilities → Skills, click Upload skill and pick claude-ai-upload/indiamart-leads-to-sheet.zip.
  2. Claude Code: copy the folder skills/indiamart-leads-to-sheet into ~/.claude/skills/.
  3. Start a new chat. Attach your file and say: "Use indiamart-leads-to-sheet. Add this IndiaMART pull to my leads sheet and keep my notes".
  4. Claude runs the script and gives you the files listed under Outputs. Check them before you act on them.

Try it with the sample

Run the sample (two overlapping pulls for a fictional packaging maker):

python3 skills/indiamart-leads-to-sheet/scripts/core.py --leads samples/pull-2026-10-27-to-31.json samples/pull-2026-10-31-to-11-01.json --out out

You should see 12 new leads (1 repeated lead dropped) from 10 buyers, 2 of them repeat buyers. Then import out/leads.csv into Google Sheets. The sample buyers and numbers are fictional.

Settings you can change

Option Default What it is
--leads (one or more) Pull API responses saved as .json, Push API bodies, or a leads.csv from an earlier run
--master (optional) Your sheet downloaded as CSV; status, owner, notes, next_action, quoted_amount and your own columns are kept
--pull (off) Call the IndiaMART Pull API with your own key from IM_PULL_KEY or --key-file; raw answers are saved in out/raw/
--since-days 0 With --pull: fetch up to 7 past days in one call (Pro: up to 365)
--out out Output folder

What goes in and what comes out

Inputs: IndiaMART Pull API answers saved as .json (or Push API bodies), or a live pull with your own key; Your sheet downloaded as CSV (optional)

Outputs: leads.csv and new-leads.csv: all IndiaMART fields, quantity and order value from the message, your columns; buyers.csv: repeat buyers merged by mobile or email; report.md: counts by type, product and state

What Pro adds

  • Hot/Warm/Cold score with reasons from your catalogue, MOQ, order value, delivery states and rules
  • Quotation drafts with CGST+SGST or IGST, never below your MOQ
  • Reply drafts and a dated follow-up list that skips closed leads
  • Backfill up to 365 days in 7-day calls (free: 7 days)

Pro: https://oarsmanai.com/agents/indiamart-lead-catcher-pro/

AI disclosure and limits

This product does not call an AI model at run time. It was built by Oarsman AI's AI agents and checked by the automated tests shipped with it.

Limits: - Needs IndiaMART's paid Leads API add-on; free IndiaMART accounts cannot get a Pull API key. - Writes CSV for Google Sheets or Excel; it does not write into Google Sheets for you or run on a schedule. - No scoring, quotes or follow-ups (those are in Pro). - Ratings, GST details and replies shown in Lead Manager are not in the API, so they are not here.

Not tested by us: - a live call to IndiaMART with a real key (the --pull code is tested against saved responses and a mocked server) - every message layout IndiaMART uses for buy-leads - Google Sheets import of files over 50,000 rows

Files

  • oarsman-indiamart-leads-to-sheet-v1.0.1.zip
  • CHANGELOG.md
  • QA-REPORT.json
  • README.md
  • SPEC.md
  • SUPPORT.md
  • TROUBLESHOOTING.md
  • VERSION
  • VIDEO-SCRIPT.md
  • claude-ai-upload
  • diagram.mmd
  • diagram.png
  • preview.png
  • samples
  • skills
  • tests

Help

Self-serve: see TROUBLESHOOTING.md (fixes and FAQ). There is no call, chat or email support. Fixes ship as new versions at your download link. Refund: 14 days, works as described, through the checkout platform.