AI automation

IndiaMART Lead Automation: Pull Enquiries Into a Sheet and Call the Serious Buyers First

By Sauravjit Singh · Updated 2026-11-10 · 6 min read

Short answer: IndiaMART lead automation means using the CRM API key from your IndiaMART seller account to pull enquiries into Google Sheets or a CRM through a tool like Pabbly Connect, Make or Zapier. Add an AI step to score each enquiry by product match, quantity and city, then alert sales and send a short acknowledgement.

For a manufacturer in Bawana or a trader in Kirti Nagar, IndiaMART can bring dozens of enquiries a day. Some are serious buyers with a quantity and a deadline. Many are price checks, students, other sellers or people who picked the wrong category. A two-person sales team can't call all of them first.

Global automation blogs don't cover this, because it's an India-specific B2B channel. This guide does: how access works, the sheet layout, an AI scoring step you can copy, and the limits.

How do IndiaMART leads reach you today?

Enquiries arrive in IndiaMART's Lead Manager (on the web seller panel and the app), along with email and SMS alerts. Direct enquiries come from buyers who contacted you; purchased BuyLeads are a separate stream and may be handled differently.

The problem isn't receiving leads. It's that the Lead Manager is a separate inbox your team has to keep checking, it doesn't know your priorities, and it's hard to report from. Pulling enquiries into a sheet you control fixes all three.

Does IndiaMART have an API for leads?

Yes. IndiaMART offers a CRM integration key that lets approved tools pull your enquiries automatically. Access and exact menu names change, so confirm the details in your own account.

From what we've seen while setting this up, three things are worth knowing in advance:

  • Where to find it: look in Lead Manager settings for an option named along the lines of CRM integration, Import/Export or API. If you can't see it, ask your IndiaMART account manager; access is commonly tied to your seller package.
  • It's usually a pull, not a push: your automation tool asks IndiaMART for new enquiries on a schedule. That means a delay of several minutes is normal, not a bug.
  • There are request limits: if your tool asks too often, IndiaMART can refuse the request for a while. Check the current limits in IndiaMART's integration documentation and set your schedule a little slower than the limit.
  • Treat the key like a password. Anyone with it can read your buyer list. If a staff member who had it leaves, generate a new key.

How to send IndiaMART leads to Google Sheets, step by step

Pabbly Connect has a ready IndiaMART connection and is a common choice for this job. In Make or Zapier, check the app directory first; if there's no ready app, an HTTP or webhook module with the API key does the same work without code, though it needs more care when mapping fields.

  1. Create a sheet with these headers: Enquiry ID, Received (IST), Buyer name, Mobile, Email, Company, City, State, Product, Message, Score, Reason, Assigned to, Status, Called at.
  2. Generate your CRM key in IndiaMART and store it only inside the automation tool.
  3. Set the trigger to fetch new enquiries on a schedule, every 10–15 minutes during business hours is a sensible start.
  4. Add a 'find row' step on Enquiry ID and continue only when no match is found. Pull-based APIs can return the same enquiry twice when time windows overlap.
  5. Map the fields into a new row. Convert the received time to IST if it isn't already, and keep the mobile number as text so leading digits and the +91 aren't mangled.
  6. Add the AI scoring step (next section) before the row is written, or as an update right after it.
  7. Add an alert to the sales person for 'hot' enquiries only, so the phone doesn't buzz for every student project.
  8. Test with a few real enquiries from the last day and compare against Lead Manager.

If you also run Meta lead ads, the same pattern applies with an instant trigger instead of polling; compare with our Facebook lead ads to Google Sheets build.

Adding an AI step that scores enquiry quality

An AI step reads the product, message, quantity and city and returns a score your team can sort by. It doesn't replace judgement; it decides who gets called first.

Start with a scoring rubric you'd use yourself. Here is one for an illustrative Delhi packaging machine maker:

SignalPushes towards hotPushes towards cold
Product matchNames a model or machine type you makeAsks for something you don't sell
Quantity or capacityStates units, output per hour or a project sizeNo quantity, 'just checking rates'
TimelineMentions a date, a plant setup or 'urgent'No timeline
LocationWithin your delivery and service areaFar outside your service area (still worth a reply)
Who's askingCompany name, purchase or plant roleStudent project, job seeker, another seller

A prompt that works: 'You score B2B enquiries for a packaging machine maker in Delhi that sells pouch packing and sealing machines across North India. Using the product, message, quantity and city below, reply in exactly this format: score|reason. Score must be hot, warm or cold. Reason must be under 12 words. Hot needs a matching product plus a quantity or timeline. Cold is no matching product, a student, a job seeker or a seller. Otherwise warm.' Then map the enquiry fields after it.

Sample enquiry: 'Need automatic pouch packing machine for 500 g namkeen, 30 pouches/min, Jaipur, within 1 month.' A good output is 'hot|matching machine, capacity and one-month timeline'. A weak first prompt typically returns a paragraph praising the buyer, which you can't sort. Split the output on the pipe character into Score and Reason columns with your tool's text formatter.

Check it against 20–30 past enquiries you already know the outcome of. If it marks real buyers as cold, tighten the rubric. Our guide to using ChatGPT as a step in Zapier and Make covers API keys and keeping the output format stable.

How should you auto-reply to IndiaMART enquiries?

Send a short, human acknowledgement quickly, and let a person send prices. Buyers on IndiaMART often contact several sellers at once, so the first useful reply has an edge, but an automatic quote with the wrong spec loses the deal.

A sample acknowledgement: 'Thanks for your enquiry about pouch packing machines. This is Neha from the sales team. I'll call you within an hour to confirm the pouch size and output you need. Our catalogue is attached.'

On WhatsApp, automated messages to buyers need the official WhatsApp Business Platform and approved templates; our guide to WhatsApp follow-ups for new leads explains the setup and costs. Email is simpler if the buyer shared an address, but many IndiaMART enquiries come with a mobile number only.

Honest limits and what goes wrong

  • Delay: polling means minutes, not seconds. If you need instant response, keep the IndiaMART app notifications on as well.
  • Gaps after errors: if the workflow fails for a day, check whether your tool fetches the missed window when it resumes. Reconcile weekly against Lead Manager counts.
  • Changed field names or key: when IndiaMART updates its integration or a key is regenerated, mapping can break. See why Zapier and Make automations fail for a weekly check routine.
  • AI over-trust: the score is a sorting aid. Call warm leads too, just after the hot ones.
  • TradeIndia and similar portals: the same pattern works where the portal offers an API or email alerts you can parse. Check each portal's current integration options.

For where this fits among other workflows, our overview of no-code AI automation for small businesses covers costs and what to keep manual. The Spettro School Applied AI Professional course includes lead-scoring builds like this one as practice projects.

Frequently asked questions

Can I connect IndiaMART to Google Sheets for free?

Often you can start on an automation tool's free plan, but frequent polling uses up free limits quickly. API access itself depends on your IndiaMART seller package, so confirm it in your account first.

Why do IndiaMART leads arrive late in my sheet?

The integration usually works by fetching new enquiries on a schedule, and IndiaMART limits how often you can ask. A delay of several minutes is normal; keep app notifications on for anything urgent.

Should AI reply to IndiaMART buyers automatically?

Use automation for a quick acknowledgement and use AI to score and summarise, but keep prices and technical answers with a person. A wrong spec or price sent automatically does more harm than a slightly slower reply.

Can I automate TradeIndia leads the same way?

The same sheet, scoring and alert pattern works if the portal provides an API, a ready connector in your tool, or structured email alerts. Check the portal's current integration options before you build.

Is it safe to put my IndiaMART API key in Zapier or Make?

It's normal practice, but treat the key like a password. Keep it only inside the tool, limit who can edit the workflow, and regenerate it when someone with access leaves.

Want to learn this with a trainer?

Leave your details and our counsellor will call you within one working day with batch dates, fees and the right course for you.

  • Free counselling call, no obligation to join
  • Weekday and weekend batches, online or offline
  • Small batches of 15 to 20 students

Or chat on WhatsApp

Enter a 10-digit mobile number.

We use your details only to contact you about Spettro School courses.

Chat on WhatsApp