google sheet lead import · Import and connections
Leads from the ad form sit in a sheet until someone remembers to copy them.
Google Sheet lead import by Telecalling Software: new rows reach callers by themselves.
Google Sheet lead import in Telecalling Software turns a sheet or a REST API into a lead source: it watches what you connect and brings in every new row as a lead, in the background, without anyone copying numbers. Map the columns once, choose which caller or round-robin group receives the leads, and Facebook, Google, IndiaMART, JustDial or website leads are ringing within minutes of arriving.
- Google Sheet lead import
- Lead API
- Auto import leads
- Facebook leads to phone
- IndiaMART leads to CRM
- Auto import leads from google sheets
- Telecalling CRM
- Telecaller app
- For real estate
- For insurance agents
3 days free, no cardIncluded in the one plan
How does Google Sheet lead import work?
Telecalling Software runs Google Sheet lead import by itself, and takes a REST API as a source too. Connect the source once, map the columns, choose a caller or a round-robin group, and every new row becomes an assigned lead on a phone within minutes, with its source tagged. Facebook, Google, IndiaMART, JustDial and website forms all feed a sheet or an API.
Google Sheet lead import features
| Fact | Telecalling Software |
|---|---|
| Sources | Google Sheet (watched), REST API, Excel, CSV, JSON, pasted numbers |
| Google Sheet | Connect once; each new row becomes a lead within minutes, columns become fields |
| API | Your form, website or ad platform posts a lead; it lands assigned |
| Assignment | Round-robin across a team or to a named caller per source |
| Duplicates | A number already in the account is updated, not added twice |
| Cost | Included in the one plan; no per-lead charge |
- Connect oncePaste the sheet link or the API address, map the columns, and forget it.
- Assigned as they landSend new leads to one caller or share them round-robin across the team.
- Any source that writes a rowAd forms, portals, website forms and other tools all end up in a sheet or an API. That is enough.
- Files tooExcel, CSV and JSON files import directly, and a file shared from WhatsApp or mail opens straight into the import screen.
Add the source
A sheet link or an API address, as a named source.
Map the columns
Number is required; every other column becomes a field.

Leads arrive
New rows become assigned leads with the source tagged.

Google Sheet lead import uses
- A Facebook lead ads userpoints the ad form's sheet at the app and stops copying rows by hand.
- A website with a contact formposts each enquiry to the API so the caller's phone buzzes while the visitor is still on the site.
- An agency running calls for clientsgives each client its own sheet and its own caller, with the source tagged on every lead.
Google Sheet lead import limits
- The sheet needs a mobile number column; rows without one are skipped and listed.
- It reads sheets and APIs, not email inboxes or PDFs.
- Portal integrations are done through the sheet or API the portal exports to, not by logging into the portal.
- Import Excel, CSV or JSONAny common file format. Only the mobile number column is required.
- Share a file into the appFrom WhatsApp, mail or the browser, share the file and the import screen opens.
- Export to CSVTake your leads out as a CSV whenever you need them elsewhere.
- Connect other systemsLink the tools you already use so records move between them and the dialer.
Google Sheet lead import FAQ
How soon does a new row show up as a lead?
- The source is checked at short intervals, so a new row is usually on a caller's phone within a few minutes of appearing in the sheet.
Which lead sources can I connect?
- Any Google Sheet and any REST API that returns rows. Facebook lead ads, Google forms, IndiaMART, JustDial and most website builders can write to one of those.
Can leads be split between callers automatically?
- Yes. Choose round-robin for a source and each new lead goes to the next caller in turn, with the phone notified.
Do I need to keep the sheet open?
- No. The app reads the sheet on its own schedule. You can keep adding rows from anywhere.
Why do leads sit in a sheet without being called?
- Because copying them is somebody's job and it is nobody's priority. The enquiry arrives, the sheet fills, and by the time a caller has it the customer has spoken to two competitors. Connecting the sheet removes the step rather than reminding somebody to do it faster.
How do I import leads from Google Sheets automatically?
- Connect the sheet once from the dashboard and map which column is the mobile number. From then on new rows become assigned leads on a caller's phone by themselves, usually within minutes, with no exporting and no re-uploading.
Is Google Sheet lead import free?
- No, imports are part of the paid plan rather than the free forever one. Free covers the calling half: dialer, filters, call analysis, analytics and automatic WhatsApp. Bringing leads in automatically is a team feature and sits with the records at ₹161 per user per month.
Can I connect a Facebook or Google ad form to the lead list?
- Through the sheet or the API, yes, and both are common. Most ad platforms will drop new leads into a Google Sheet, which this reads; anything that can post to a webhook can use the API directly and arrives faster.
How fast does a lead from the ad form reach the caller?
- Minutes rather than hours, which is usually the entire argument for connecting it. An enquiry called within the hour behaves completely differently from one called the next morning, and the gap is nearly always the copying rather than the calling.
Which columns does the Google Sheet need?
- Only a mobile number. Everything else is optional and useful: name, city, source, product, budget, whatever the form collected becomes a field the caller sees while the phone rings. Column order does not matter because you map them once.
What happens if the same lead comes in twice?
- A repeated number updates the existing lead instead of creating a second one, so a customer who fills the form twice does not get called by two people. This matters more than it sounds on ad campaigns, where duplicate submissions are routine.
Can I import leads with an API instead of a sheet?
- Yes, and for volume it is the better route. Any system that can post JSON can create leads directly, which suits a website form, a CRM you already run or a lead marketplace. The sheet exists because most small teams already have one.
Will importing overwrite the notes on an existing lead?
- No. An import updates fields and leaves the call history, the outcomes and the notes alone. Nothing a caller recorded is lost because somebody re-uploaded a list, which is the failure people most fear when importing.
Can I stop the Google Sheet import without deleting the leads?
- Yes. Disconnect the source and the leads you already pulled in are untouched, history and all. Reconnect later and it resumes from new rows rather than re-importing what came before.
Can I import a one-off Excel file?
- Yes. Excel, CSV and JSON files import directly, and you can share a file from WhatsApp or email straight into the app.
Goes well with
- Auto dialerPick a list, press start, and the phone rings the next number each time a call ends. You only talk.
- Attendance with a live selfieCallers mark in and out with a live selfie taken inside the branch radius. Punches made offline sync later; nothing tracks them between punches.
- Calling sessionsA guided run through a list with a progress count and a stop button that follows you around the phone.
Good things
start with hello.
Make room for better conversations. Take Telecalling Software with you. Free for 3 days, no card.
Keep reading
- Backup and restoreEverything back on a new phone in minutes.Open
- Caller ID and spamNames on unknown numbers; customers always ring through.Open
- Call analyticsCalls, connects, outcomes and lost leads per caller.Open
- Staff attendanceA live selfie inside the branch radius.Open
- How many calls should a telecaller make in a day?how many calls should a telecaller make in a day: the maths by hand and with an auto dialer, and the number to target instead.Open
- How many times should you follow up a lead?how many times should you follow up a lead: by call and WhatsApp, the spacing that works in India, and when to stop.Open
Updated on · Facts checked September 2026