Tag: Google Sheets

  • Free Student Lead Tracker for Study Abroad Agencies (Template)

    Free Student Lead Tracker for Study Abroad Agencies (Template)

    Last updated: 5 November 2026 · By Leads Nimble Team (a product of Luminous Labs, Dhaka)

    A study abroad CRM can start as a free student lead tracker: one spreadsheet row per student, with country, intake, IELTS score, budget, stage and next follow-up date. This guide gives you the exact columns, stages and follow-up schedule Bangladeshi agencies can copy today, and shows when to move to a real CRM.

    Key takeaways

    • One row per student, one owner per student, one “next follow-up date” per row. Without these three, any tracker fails.
    • Use 9 fixed stages from “New inquiry” to “Visa granted / Enrolled”. Dropdowns only, no free typing.
    • Track the facts that decide eligibility early: target country, intake, IELTS/PTE score, last degree, CGPA and budget.
    • Reply to new inquiries within the hour. Published research shows interest fades fast after that.
    • Outgrow the sheet when leads come from several Facebook pages, WhatsApp numbers and counsellors at once.

    What is a student lead tracker?

    A student lead tracker is a shared list of every prospective student who contacts your agency, with their profile, stage and next action. It turns scattered Messenger chats, WhatsApp threads and walk-in notes into one view.

    A study abroad CRM is software that does the same job automatically. It captures inquiries from ads and chats, stores the full conversation history, assigns counsellors and reminds them to follow up.

    Most agencies in Dhaka, Chattogram and Sylhet start with the first and move to the second. That’s a sensible path, if the tracker is built well.

    Which columns should a study abroad lead tracker have?

    Create these columns in Google Sheets or Excel. Keep the order. Columns A–H are filled at first contact; the rest are filled during counselling.

    ColColumn nameTypeExample
    ALead IDAuto numberSTU-0142
    BDate of inquiryDate03-Nov-2026
    CStudent nameTextRafiul Islam
    DPhone / WhatsAppText+8801XXXXXXXXX
    ESourceDropdownFacebook ad, Messenger, WhatsApp, Walk-in, Referral, Seminar, Website
    FAd / campaign nameTextUK Jan Intake – Nov Ad 2
    GTarget countryDropdownUK, Canada, Australia, USA, Malaysia, Germany, Other
    HTarget intakeDropdownJan 2027, May 2027, Sep 2027
    IStudy levelDropdownFoundation, Bachelor’s, Master’s, PhD, Diploma
    JSubject of interestTextMSc Data Science
    KLast degree + resultTextBSc CSE, CGPA 3.45
    LEnglish test + scoreTextIELTS 6.5 (no band below 6.0)
    MBudget (BDT, per year)Number2,500,000
    NStageDropdownSee stages below
    OCounsellorDropdownNusrat, Tanvir, Mitu
    PLast contact dateDate04-Nov-2026
    QNext follow-up dateDate06-Nov-2026
    RLead scoreDropdownHot, Warm, Cold
    SLost reasonDropdownBudget, Low score, Chose other agency, Family decision, No response
    TNotesTextWants scholarship; sister in Manchester

    Two tips save hours later. Write the English test score with the lowest band, because many universities and visa rules check each band, not only the overall score. And keep budget in Taka per year, since that’s how families in Bangladesh talk about it.

    Useful formulas for the sheet

    • Overdue follow-ups: in a helper column, =IF(AND(Q2<>"",Q2<TODAY(),N2<>"Lost",N2<>"Enrolled"),"OVERDUE",""). Then filter or colour these rows red.
    • Leads per stage: =COUNTIF(N:N,"Application submitted").
    • Leads per source: =COUNTIF(E:E,"Facebook ad"). This tells you which channel actually brings students.
    • Days since inquiry: =TODAY()-B2.

    For a full walkthrough of dropdowns and conditional formatting, see our free Google Sheets CRM template guide.

    What stages should a study abroad pipeline have?

    A pipeline stage is a fixed step that every student passes through on the way to enrolment. Fixed stages let you see where students get stuck.

    #StageExit rule (move on when…)
    1New inquiryFirst reply sent and basic profile collected
    2Profile assessedCounsellor confirms eligibility for at least one country
    3Counselling bookedOffice or video session date is set
    4Counselling doneShortlist of universities shared
    5Documents collectingTranscripts, passport, test score, SOP, references received
    6Application submittedUniversity application confirmation received
    7Offer receivedConditional or unconditional offer in hand
    8Visa filedDeposit paid and visa application lodged
    9Visa granted / EnrolledVisa approved and student travels

    Add “Lost” and “On hold (next intake)” as separate statuses. Students who miss January often come back for September. Don’t delete them.

    How fast should you follow up with a student lead?

    As fast as you can, ideally within the hour. A study published in Harvard Business Review found that firms contacting online leads within an hour were nearly seven times more likely to qualify them than firms that waited an hour longer.

    For study abroad, speed matters even more. A student who messages at 11 pm after seeing your ad has usually messaged two other agencies too. The first agency that answers the real questions (cost, scholarship, IELTS needed) often wins the counselling session.

    We looked at what slow replies cost education businesses in how slow replies cost course enrolments.

    A simple follow-up cadence

    Use this schedule for students who have not booked counselling yet. Stop once they book or say no.

    1. Day 0 (within 1 hour): Answer their question. Ask for country, intake, last result and English score.
    2. Day 1: Send a short eligibility summary and two university options in their budget.
    3. Day 3: Offer a free counselling slot (office or video). Share the date options.
    4. Day 7: Share something useful: scholarship deadline, intake deadline or a seminar invite.
    5. Day 14: Ask one direct question: “Are you still planning for the January intake?”
    6. Day 30: Move to “On hold” and add them to your next-intake broadcast list.

    After counselling, follow up on documents every 3–4 days. Students rarely say no. They just go quiet while waiting for a transcript or a bank statement.

    How to qualify a student lead in five questions

    Ask these early, in Bangla or English, whichever the student uses. They decide whether a lead is hot, warm or cold.

    1. Which country and intake are you planning for?
    2. What is your last degree and result (GPA/CGPA)?
    3. Have you taken IELTS, PTE or Duolingo? What score, and lowest band?
    4. What is your family’s yearly budget for tuition and living costs?
    5. Do you have any gap years or a previous visa refusal?

    English requirements vary by course and country, so always check the university page and the visa rules. The UK, for example, publishes its Student visa English language rules on GOV.UK. For test formats and scoring, refer students to the official IELTS website.

    Spreadsheet tracker vs study abroad CRM: which do you need?

    NeedFree tracker (Sheets/Excel)Study abroad CRM
    CostFreeFree plan or monthly fee
    Capturing leads from ads and chatsManual copy-pasteAutomatic
    Conversation historyNot storedFull chat history per student
    Follow-up remindersFormula + disciplineAutomatic tasks and alerts
    Counsellor assignmentDropdown, easy to clashRouting rules and permissions
    Which ad produced the studentOnly if typed inTracked per lead
    Night and weekend repliesNoneAI assistant can answer 24/7

    A sheet works well for a small agency with one or two counsellors and a few dozen inquiries a month. Signs you’ve outgrown it are in our free vs paid CRM checklist.

    How Leads Nimble handles student leads

    Leads Nimble is an AI sales CRM and unified inbox built in Dhaka. It pulls inquiries from Facebook Lead Ads, Messenger, Instagram, WhatsApp, website chat and Telegram into one pipeline. You can set the same stages and fields shown above.

    The AI assistant is trained on your own knowledge base: countries, tuition ranges, intake dates, IELTS needs and your office address. It answers common questions in Bangla and English at any hour, collects the five qualifying answers, and hands the student to a counsellor.

    Counsellors get follow-up reminders, the full chat history, and meeting booking synced with Google Calendar, Zoom or Calendly. You can also see which ad produced each student. See how agencies use it on our industries page and the full guide to study abroad CRM in Bangladesh.

    Start with the free forever plan (one user, one Messenger page, 500 AI credits a month) on the pricing page, or book a demo to see a study abroad pipeline set up live.

    Frequently asked questions

    What is the best free study abroad CRM?

    For very small agencies, a well-built Google Sheets tracker is the best free starting point. It costs nothing and everyone knows how to use it. When leads come from several channels, free CRM plans such as HubSpot, Zoho or the Leads Nimble free plan are the next step. Pick one that captures Messenger and WhatsApp chats, since most Bangladeshi students contact agencies there.

    Which fields matter most in a student lead tracker?

    The fields that decide eligibility and next action: target country, intake, study level, last degree and result, English test score with lowest band, budget in BDT, stage, counsellor and next follow-up date. Source and ad name are also important, because they show which marketing actually brings enrolled students rather than just inquiries.

    How often should a counsellor follow up with a student?

    Reply to a new inquiry within an hour. Then follow up on day 1, day 3, day 7 and day 14 until the student books counselling or declines. After counselling, check on documents every three to four days. At day 30 with no response, mark the lead “On hold” and add it to your next-intake list instead of deleting it.

    How many stages should a study abroad pipeline have?

    Around eight to ten. A practical set is: new inquiry, profile assessed, counselling booked, counselling done, documents collecting, application submitted, offer received, visa filed and visa granted or enrolled. Add “Lost” and “On hold” as statuses. Each stage needs a clear exit rule so counsellors move students consistently.

    Can AI answer student inquiries in Bangla?

    Yes. Leads Nimble’s AI assistant replies in Bangla and English using the knowledge base you provide, such as countries, tuition ranges, intakes and test requirements. It is best used for first answers and qualifying questions. Visa advice, scholarship decisions and anything outside your knowledge base should be handed to a human counsellor.

    When should an agency move from a spreadsheet to a CRM?

    Move when follow-ups slip, two counsellors contact the same student, or you can’t tell which ad produced which enrolment. Another clear sign is leads arriving through several Facebook pages and WhatsApp numbers that someone has to copy into the sheet by hand. At that point manual entry costs more than a CRM.

  • How to Send Facebook Lead Ads to Your CRM Automatically

    How to Send Facebook Lead Ads to Your CRM Automatically

    By Leads Nimble Team (a product of Luminous Labs, Dhaka) · Last updated: 5 November 2026

    To send Facebook Lead Ads to your CRM automatically, connect your Facebook Page’s lead forms to the CRM through a native integration, a connector like Zapier, or Meta’s webhooks. Each new form submission then appears in your CRM within seconds, with name, phone, answers and the ad it came from — no CSV downloads.

    Key takeaways

    • Manual CSV download is Meta’s least recommended option. It delays follow-up and loses the ad context.
    • There are four real routes: native CRM integration, a connector (Zapier, Make), Google Sheets as a middle step, or custom webhooks.
    • Always test with Meta’s Lead Ads Testing Tool before running budget.
    • Keep the Meta Lead ID with every lead so you can match results later.
    • The point of automation is speed: call or message the lead within minutes, not tomorrow.

    What are Facebook Lead Ads?

    Facebook Lead Ads (now called Meta lead ads or instant forms) are ads that open a form inside Facebook or Instagram. The user submits name, phone and your custom questions without leaving the app.

    A lead form is the set of questions attached to the ad. A Lead ID is the unique number Meta assigns to each submission. Meta’s CRM integration guide describes it as a 15–17 digit ID and asks that you keep it with each lead.

    Lead Ads are popular in Bangladesh for study abroad, real estate, courses, clinics, insurance and B2B services, where a phone call usually closes the sale.

    Why should Facebook leads go to a CRM automatically?

    Because leads go cold fast. In a Harvard Business Review study, firms that contacted leads within an hour were nearly seven times as likely to qualify them as firms that waited longer.

    Downloading a CSV once a day means many leads wait hours. By then, the person may have filled three competitors’ forms too. They may not even remember yours.

    Automatic sync also fixes other problems:

    • No copy-paste errors in phone numbers.
    • Each lead is assigned to a salesperson right away.
    • You keep the campaign, ad set and form name, so you can judge ads by sales, not only by cost per lead.
    • Nobody needs admin access to the ad account just to fetch leads.

    We wrote about the wider issue in stop losing sales in Facebook and Instagram DMs.

    What are the ways to send Facebook Lead Ads to a CRM?

    MethodSpeedCostSkill neededBest for
    Manual CSV downloadSlow (whenever someone downloads)FreeNoneTesting a single campaign
    Native CRM integrationNear real timeIncluded in the CRM planLowMost small teams
    Zapier / Make connectorNear real time (Zapier marks “New Lead” as an instant trigger)Paid connector plan; Zapier lists Lead Ads as a premium appLow to mediumCRMs without a native link
    Google Sheets (via connector)Near real timeConnector planLowTeams still working from a sheet
    Custom webhooks / Graph APIReal time with webhooksDeveloper time and hostingHighIn-house systems

    Meta’s own documentation lists partner integrations, webhooks, Graph API bulk reads and manual download. It marks manual download as not recommended.

    How to connect Facebook Lead Ads to a CRM natively (step by step)

    Menu names differ slightly between CRMs, but the steps are similar.

    1. Check your access. You need admin or full control of the Facebook Page in Meta Business Suite, and permission to access leads.
    2. Open the CRM’s integrations page. Find “Facebook Lead Ads” or “Meta lead forms” and click connect.
    3. Log in with Facebook. Approve the permissions the CRM asks for, including Page and leads access.
    4. Choose the Page and forms. Select one or more lead forms, or “all forms” on that Page.
    5. Map the fields. Match form questions to CRM fields: full name, phone, email, city, budget and custom questions.
    6. Set routing and the first action. Pick a pipeline stage, an owner or round-robin, and, if your CRM supports it, an instant welcome message on WhatsApp or Messenger.
    7. Test. Use Meta’s Lead Ads Testing Tool to submit a test lead and confirm it arrives correctly.
    8. Check Leads Access settings. If leads stop arriving, look at Page leads-access settings in Meta Business Suite. A removed CRM permission is a common cause.

    How to send Facebook Lead Ads to Google Sheets or a CRM with Zapier

    If your CRM has no native connection, use a connector.

    1. Create a Zapier account on a plan that includes premium apps. Zapier’s Facebook Lead Ads page lists it as premium.
    2. Choose the trigger “Facebook Lead Ads → New Lead” and connect your Facebook account.
    3. Select the Page and form.
    4. Add an action: “Google Sheets → Create Spreadsheet Row” or your CRM’s “Create Contact/Lead” action.
    5. Map each field, and include the lead ID, ad name and form name.
    6. Test with Meta’s testing tool, then turn the Zap on.

    Google Sheets is a fine middle step for a small team. Our free Google Sheets CRM template has columns ready for Lead Ads data. Remember that a sheet will not remind anyone to call.

    What about custom webhooks?

    A webhook is a URL on your server that Meta calls the moment a new lead arrives. It is the fastest and most flexible route, but it needs a developer.

    Your developer creates a Meta app, subscribes it to the Page’s leadgen events, fetches each lead by ID, and writes it into your database. They must handle access tokens, permissions and errors, and keep the app compliant with Meta’s review rules. For most small and mid-size businesses in Bangladesh, a CRM with a ready connection is cheaper over time.

    Which fields should a Facebook lead form collect?

    Shorter forms get more leads; better questions get better leads. Balance the two.

    • Always: full name and phone number (Meta can prefill these).
    • Useful: city or area (Dhaka, Chattogram, Sylhet…), preferred contact time, WhatsApp yes/no.
    • Qualifying (1–2 only): budget range, course or country of interest, flat size, service needed.
    • Consent: a clear line on how you will contact them and use their data.

    Use multiple-choice answers where you can. They map cleanly to CRM fields and are easier to segment later.

    What should happen in the first five minutes after a lead arrives?

    1. The lead appears in the CRM with source ad, form and Lead ID.
    2. It is assigned to a salesperson by rule.
    3. An automatic welcome message goes out on WhatsApp or Messenger in Bangla or English, if the person opted in.
    4. The salesperson gets a mobile notification and a task: “Call within 15 minutes.”
    5. If no one acts, the lead escalates to a manager.

    Phone numbers in Bangladesh should be stored in the +8801XXXXXXXXX format. That makes WhatsApp click-to-chat and dialling work reliably.

    Should you send lead quality back to Meta?

    Meta offers a Conversions API for CRM setup, where you report which leads became qualified or converted. The idea is to help delivery favour people likely to buy, not just people likely to fill forms. It needs stage data from your CRM and some technical setup, so start once your lead flow is stable.

    How Leads Nimble handles Facebook Lead Ads

    Leads Nimble, the AI sales CRM and unified inbox from Luminous Labs in Dhaka, captures Facebook Lead Ads and lead-capture forms into the same pipeline as your chats. That means:

    • Lead Ads, Messenger, Instagram, WhatsApp, website chat and Telegram leads sit in one pipeline.
    • Campaign and ad attribution shows which ad produced each lead.
    • The AI assistant can start the conversation 24/7 in Bangla or English and qualify the lead, with human handoff.
    • Team routing, tasks and follow-up reminders make sure someone calls.
    • Integrations with Google Sheets, Zapier, webhooks and a REST API connect to the rest of your tools.

    See the features page or compare options in our omnichannel lead management guide.

    Common problems and fixes

    ProblemLikely causeFix
    No leads arrivingCRM lost leads access on the PageReconnect and check leads-access settings in Business Suite
    Some leads missingNew form not selected in the integrationChoose “all forms” or add the new form
    Phone numbers brokenMixed formats (01…, 8801…, +8801…)Normalise to +8801 format in field mapping
    DuplicatesSame person submits twice or two connectors runUse one connection; dedupe on phone number
    Leads arrive but nobody callsNo routing or remindersAssign owners automatically and add a 15-minute task

    Get your Lead Ads into a pipeline today

    Start with one form. Connect it, run Meta’s test, then watch how fast your team responds over a week.

    Start on the Leads Nimble free plan or book a demo to connect your Lead Ads live with our team.

    Frequently asked questions

    How do I send Facebook Lead Ads to my CRM automatically?

    Open your CRM’s integrations page and connect Facebook Lead Ads, then log in, choose your Page and forms, and map fields. If your CRM has no native connection, use Zapier or Make with the “New Lead” trigger. Developers can also use Meta webhooks. Test every setup with Meta’s Lead Ads Testing Tool.

    Can I send Facebook leads to Google Sheets for free?

    Manual CSV export and import is free but slow. Automatic sync usually needs a connector such as Zapier, which lists Facebook Lead Ads as a premium app on paid plans, or a CRM that includes a Google Sheets integration. A sheet stores leads but does not remind anyone to follow up.

    Why are my Facebook leads not showing in my CRM?

    The most common cause is lost leads access: the CRM’s permission on the Page was removed or expired. Other causes are a new form not selected in the integration, or a page role change. Reconnect the integration, select all forms, and submit a test lead with Meta’s testing tool.

    How fast should I contact a Facebook lead?

    Within minutes if possible. Harvard Business Review research found firms that contacted leads within an hour were nearly seven times as likely to qualify them as firms that waited longer. Automatic sync, instant assignment and a mobile alert make a five-to-fifteen-minute response realistic.

    Is Zapier required to connect Lead Ads to a CRM?

    No. Many CRMs connect to Facebook Lead Ads natively, which is simpler and avoids a second subscription. Zapier or Make is useful when your CRM lacks a native link or you need to send leads to several tools at once. Custom webhooks are another option if you have a developer.

    Does Leads Nimble support Facebook Lead Ads?

    Yes. Leads Nimble captures Facebook Lead Ads and lead-capture forms into the same pipeline as Messenger, Instagram, WhatsApp, website chat and Telegram conversations. It records which ad produced each lead, lets the AI assistant start a conversation in Bangla or English, and routes the lead to the right salesperson.

  • Free Google Sheets CRM Template for Facebook Page Sellers

    Free Google Sheets CRM Template for Facebook Page Sellers

    Last updated: 5 November 2026 · By Leads Nimble Team (a product of Luminous Labs, Dhaka)

    A free CRM template in Google Sheets is a shared spreadsheet with fixed columns, dropdowns and formulas that track every Facebook page customer from first message to delivery. Below is the exact layout we recommend for Bangladeshi page sellers: 21 columns, a Settings tab, a Dashboard with COUNTIF formulas, and follow-up alerts. It takes about 20 minutes to build.

    Key takeaways

    • Use three tabs: Leads, Settings and Dashboard.
    • Dropdowns for Channel, Status, Payment, Area and Courier keep data clean and countable.
    • A “Follow-up due” formula plus red highlighting tells you who to message today.
    • COUNTIF and SUMIFS turn the sheet into a simple sales report: orders, COD pending, leads by channel.
    • Move to a real CRM when chats come from several channels, or more than two people edit the sheet daily.

    What is a Google Sheets CRM template?

    A Google Sheets CRM is a spreadsheet used as a customer relationship management system. Each row is one lead or order, each column is one fact about it, and dropdowns control the values.

    For a small Facebook page, this is often the best first step. It is free, works on phone and laptop, and the whole team can edit it at once.

    It is not automatic, though. Someone still has to copy each customer from Messenger or WhatsApp into the sheet. Keep that in mind; we will come back to it.

    Free CRM template layout: the exact columns

    Create a new Google Sheet and rename the first tab to Leads. Type these headers in row 1, from column A to U.

    ColumnHeaderType / ruleExample
    ALead IDFormula (auto)LN-0042
    BDateDate of first message05/11/2026
    CCustomer nameTextNusrat Jahan
    DPhonePlain text, 11 digits01712xxxxxx
    EChannelDropdownMessenger
    FSource post / adTextEid kurti boost
    GProduct / codeTextKT-118
    HSize / variantTextM, Maroon
    IQtyNumber2
    JUnit price (BDT)Number1,250
    KDelivery areaDropdownOutside Dhaka
    LDelivery chargeFormula (auto)From Settings tab
    MTotal (BDT)Formula (auto)Qty × price + delivery
    NPaymentDropdownCOD
    OStatusDropdownOrder confirmed
    PCourierDropdownSteadfast
    QConsignment IDTextFrom courier panel
    RNext follow-upDate07/11/2026
    SOwnerDropdown (team names)Rafi
    TNotesTextWants gift wrap
    UFollow-up due?Formula (auto)DUE

    Select row 1 and choose View → Freeze → 1 row so headers stay visible while you scroll.

    Why format the Phone column as plain text?

    Bangladeshi mobile numbers start with 0, such as 017, 018 or 019. Sheets drops the leading zero if the column is a number.

    Select column D, then Format → Number → Plain text. Now 01712345678 stays exactly as typed.

    How to add dropdowns to your CRM template

    Dropdowns make every status countable. “Confirmed”, “confirm” and “CONFIRMED” become one value.

    First, add a second tab called Settings. Put each list in its own column:

    Settings columnList nameValues (edit to fit your business)
    AChannelMessenger, WhatsApp, Instagram, Page comment, Phone call, Website
    BStatusNew, Price asked, Interested, Order confirmed, Shipped, Delivered, Returned, Lost
    CPaymentCOD, bKash, Nagad, Bank, Card
    DDelivery areaInside Dhaka, Dhaka suburbs, Outside Dhaka
    EDelivery chargeYour charge for each area, in the same order as column D
    FCourierPathao, Steadfast, RedX, Own rider, Other
    GOwnerNames of the people who reply to customers

    Put the header in row 1 and values from row 2 down. Then follow these steps for each dropdown column on the Leads tab:

    1. Select the column range, for example E2:E1000 for Channel.
    2. Click Data → Data validation → Add rule.
    3. Under Criteria, choose Dropdown (from a range).
    4. Enter the range, for example Settings!A2:A20.
    5. Under Advanced options, choose Reject the input so nobody types a free-text status.
    6. Click Done. Repeat for K (Settings!D2:D20), N (C2:C20), O (B2:B20), P (F2:F20) and S (G2:G20).

    Google explains each option in its help article on creating an in-cell dropdown list.

    Formulas for the CRM template (copy-paste)

    Enter each formula in row 2, then drag it down to row 1000. Blank-row checks keep empty rows clean.

    Auto Lead ID (column A)

    =IF(C2="","","LN-"&TEXT(ROW()-1,"0000"))

    This creates LN-0001, LN-0002 and so on as soon as you type a name. Do not sort rows if you need IDs to stay fixed; use filters instead.

    Delivery charge from area (column L)

    =IF(K2="","",IFERROR(INDEX(Settings!$E$2:$E$20,MATCH(K2,Settings!$D$2:$D$20,0)),""))

    Change a charge once in Settings, and every new row uses the new amount.

    Order total (column M)

    =IF(OR(I2="",J2=""),"",I2*J2+N(L2))

    Follow-up due flag (column U)

    =IF(AND(R2<>"",R2<=TODAY(),O2<>"Delivered",O2<>"Lost",O2<>"Returned"),"DUE","")

    Any open lead whose follow-up date is today or earlier shows “DUE”.

    Highlight due follow-ups and duplicate phones

    Select A2:U1000 and open Format → Conditional formatting. Choose Custom formula is and enter:

    • =$U2="DUE" with a light red fill, for overdue follow-ups.
    • =AND($D2<>"",COUNTIF($D$2:$D,$D2)>1) with a yellow fill, for repeat customers or double entries.

    Google’s guide to conditional formatting rules shows where each setting sits.

    Phone number check

    Add a data validation rule on D2:D1000 with Custom formula is:

    =AND(LEN(D2)=11,LEFT(D2,2)="01")

    This catches numbers with a missing digit before the courier calls a wrong number.

    How to build the Dashboard tab with COUNTIF

    Add a third tab called Dashboard. Type the labels in column A and the formulas in column B.

    MetricFormula
    Total leads=COUNTA(Leads!C2:C)
    New leads today=COUNTIF(Leads!B2:B,TODAY())
    Orders confirmed=COUNTIF(Leads!O2:O,"Order confirmed")
    Delivered=COUNTIF(Leads!O2:O,"Delivered")
    Lead-to-delivery rate=IFERROR(B5/B2,0) (format as %)
    Follow-ups due now=COUNTIF(Leads!U2:U,"DUE")
    Delivered revenue (BDT)=SUMIF(Leads!O2:O,"Delivered",Leads!M2:M)
    COD still with courier (BDT)=SUMIFS(Leads!M2:M,Leads!O2:O,"Shipped",Leads!N2:N,"COD")
    Leads from Messenger=COUNTIF(Leads!E2:E,"Messenger")
    Leads from WhatsApp=COUNTIF(Leads!E2:E,"WhatsApp")
    Returns=COUNTIF(Leads!O2:O,"Returned")

    The formulas assume the labels start in A2 and follow the table order, so “Total leads” is B2 and “Delivered” is B5. Adjust references if you change the order. The COUNTIF help page explains the syntax.

    How to copy and share the template with your team

    1. Build it once using the steps above, then add two or three test rows to check the formulas.
    2. Delete the test rows but keep the formulas in columns A, L, M and U.
    3. Make a master copy. Use File → Make a copy and name it “CRM Template – Master”. Never type real leads into the master.
    4. Share the working copy with your team using Share → Editor. Give view-only access to anyone who just needs reports.
    5. Protect formula columns. Right-click column A → View more column actions → Protect range, so nobody overwrites a formula by mistake.
    6. Start a fresh copy for each new page or each year, so the sheet stays fast.

    Daily routine: how to use the sheet

    • Morning: filter column U for “DUE” and message those customers first.
    • Every new chat: add a row with name, phone, channel and product. Set status to “New” or “Price asked”.
    • After confirming: change status, add courier and consignment ID.
    • Evening: check the Dashboard for COD still with the courier and returns.

    Google Sheets CRM vs a real CRM: when do you outgrow it?

    Sheets is a great start. But the copy-paste step does not scale.

    TaskGoogle Sheets templateChat-based CRM (e.g. Leads Nimble)
    Capture new Messenger leadManual copyAutomatic from the inbox
    Reply to the customerSwitch to Messenger appReply from the same screen; AI can answer 24/7
    Know which ad brought the leadTyped by hand, often skippedCampaign/ad attribution
    Follow-up reminderFormula + someone checkingReminders and tasks
    Several channelsOne “Channel” dropdownMessenger, WhatsApp, Instagram, web chat, Telegram in one inbox
    Team rolesEveryone edits everythingRoles and permissions
    CostFreeFree plan; paid plans in Taka

    Signs you have outgrown the sheet:

    • You spend more than an hour a day copying chats into rows.
    • Two people answer the same customer, or nobody does.
    • Leads from WhatsApp never reach the sheet.
    • The sheet takes seconds to load on a phone.

    Read the full checklist in free vs paid CRM: 7 signs you’ve outgrown Excel, or compare options in our guide to the best free CRM software in Bangladesh.

    Next step: automate the copy-paste

    Leads Nimble turns every Messenger chat into a lead in a visual pipeline, so the sheet fills itself. Its AI assistant replies in Bangla and English, and it can still sync with Google Sheets if your team likes the spreadsheet view.

    The Free plan includes 1 user, one Messenger page and 500 AI credits a month, with no credit card. See all features or book a demo.

    Frequently asked questions

    Is there a free CRM template for Google Sheets?

    Yes. You can build one in about 20 minutes with the layout in this guide: a Leads tab with 21 columns, a Settings tab for dropdown lists and a Dashboard tab with COUNTIF formulas. It costs nothing beyond a Google account. Make a master copy first so you can reuse the clean template for other pages.

    Which columns should a CRM sheet have for a Facebook page?

    At minimum: date, customer name, phone, channel, product, price, delivery area, delivery charge, total, payment method, status, courier, consignment ID, next follow-up date and owner. Add the source post or ad if you run boosts, so you can see which posts actually bring orders.

    How do I stop Google Sheets removing the 0 from phone numbers?

    Select the phone column and choose Format → Number → Plain text before typing. Bangladeshi numbers then keep their leading 0. You can add a data validation rule with the formula =AND(LEN(D2)=11,LEFT(D2,2)=”01″) to catch numbers with missing digits.

    How do I count orders by status in Google Sheets?

    Use COUNTIF on the status column. For example, =COUNTIF(Leads!O2:O,”Order confirmed”) counts confirmed orders. For two conditions, such as shipped COD orders, use SUMIFS or COUNTIFS. Dropdowns keep spelling identical, which is what makes these formulas accurate.

    Can several people use the same Google Sheets CRM?

    Yes. Share the sheet with Editor access and everyone sees changes live. Protect formula columns so nobody deletes them, and add an Owner column so each lead has one person responsible. With more than two or three active editors, conflicts and double replies become common.

    When should I move from a spreadsheet to a CRM?

    Move when copying chats takes too much time, when leads come from several channels, or when follow-ups are missed. A chat-based CRM such as Leads Nimble captures Messenger leads automatically, reminds you to follow up and shows which ad brought each customer. Its Free plan is a low-risk way to test.

  • Free CRM vs Paid CRM: 7 Signs Your Business Has Outgrown Excel

    Free CRM vs Paid CRM: 7 Signs Your Business Has Outgrown Excel

    Last updated: 5 November 2026 · By Leads Nimble Team (a product of Luminous Labs, Dhaka)

    Free vs paid CRM comes down to one question: is your spreadsheet still saving time, or now costing you sales? A free CRM or Excel sheet is enough while one person handles a few leads a day. Move to a paid CRM when leads arrive on many channels, follow-ups slip, or several staff share customers.

    Key takeaways

    • Excel and Google Sheets are real CRMs for very small teams. Don’t pay before you need to.
    • The cost of staying free is hidden: missed follow-ups, double replies and no idea which ad works.
    • Seven signs you’ve outgrown Excel are listed below. Two or more means it’s time to upgrade.
    • Try a free CRM plan first. Upgrade to paid only for seats, channels or automation you will actually use.
    • In Bangladesh, check for Bangla replies, Messenger/WhatsApp support and Taka billing before you buy.

    What is the difference between a free and a paid CRM?

    A CRM (customer relationship management) system is a single place to store every customer, conversation and deal, so nothing depends on one person’s memory.

    A free CRM is either a spreadsheet you build yourself or a vendor’s free plan with limits on users, contacts, channels or automation. A paid CRM removes those limits and adds features such as automation, AI, team permissions and reports.

    FeatureExcel / Google SheetsFree CRM planPaid CRM plan
    PriceFreeFreeMonthly per seat or per plan
    UsersAnyone with the linkUsually 1–2 seatsMany seats with roles
    Lead capture from Messenger/WhatsAppManual copy-pasteLimited channelsSeveral channels in one inbox
    Follow-up remindersFormula + disciplineBasic tasksAutomatic tasks and sequences
    Automation and AI repliesNoneLimited or noneChatbots, AI, workflows
    Ad attributionOnly if typed inSometimesTracked per lead
    Data safetyEasy to delete or overwriteVersion historyPermissions, audit trail

    Want to see which free plans are worth trying? We compared them in best free CRM software in Bangladesh (Bangla version: ফ্রি CRM সফটওয়্যার).

    Is Excel good enough as a CRM?

    Yes, for a while. A well-built sheet with dropdowns, a status column and a “next follow-up” date beats a messy notebook. Our free Google Sheets CRM template shows exactly how to build one.

    Sheets also scale further than people think. Google raised the Sheets limit to 10 million cells per spreadsheet. Size is rarely the problem.

    The problem is the work around the sheet. Someone must copy every inquiry in, remember every follow-up, and stop two staff from calling the same customer. In Banglish terms: sheet ache, kintu update kore ke? The sheet exists, but who keeps it updated?

    7 signs your business has outgrown Excel

    Go through this checklist honestly. Each one is a cost you are already paying.

    1. Leads come from three or more places

    Your Facebook page inbox, a WhatsApp number, Instagram DMs, Lead Ads forms, phone calls. Every channel needs someone to copy leads into the sheet. If that copying happens “later”, it often doesn’t happen.

    2. Follow-ups depend on someone’s memory

    If your sales staff say “ami mone rakhbo” (I’ll remember), you have a memory system, not a CRM. Research in Harvard Business Review showed leads contacted within an hour were far likelier to be qualified than leads contacted later. Late follow-up is lost revenue.

    3. Two people reply to the same customer

    One staff member quotes a delivery charge of ৳60, another says ৳120. The customer screenshots both. Shared phones and shared logins cause this. A CRM assigns each lead to one owner.

    4. You can’t answer “which ad brought this order?”

    You spend on Facebook ads every month but can’t link a sale to a campaign. Without attribution, you can’t cut the ads that bring chats but no orders.

    5. Messages go unanswered at night and on Fridays

    Customers in Bangladesh often message late at night and on weekends. A spreadsheet can’t reply. If your morning starts with 40 unread messages, some of those buyers already ordered elsewhere. Our missed message calculator puts a Taka figure on this.

    6. Customer history lives in staff phones

    When a salesperson leaves, their WhatsApp chats leave with them. Returning customers have to explain everything again. A CRM stores the full conversation and order history against the customer, not the employee.

    7. Reporting takes hours every week

    If preparing a weekly sales report means filtering, copying and fixing broken formulas, the sheet is costing more time than it saves. A CRM shows pipeline value, conversion by source and pending follow-ups in real time.

    Score yourself

    • 0–1 signs: Stay on Excel or Google Sheets. Tidy it up.
    • 2–3 signs: Try a free CRM plan alongside the sheet for one month.
    • 4 or more signs: You are paying for “free” in lost sales. Move to a CRM with automation.

    How much does a CRM cost in Bangladesh?

    It ranges from free to many thousands of Taka a month. Global CRMs usually charge in US dollars per user, which means a dual-currency card and a bill that moves with the exchange rate. Some local and regional tools bill in Taka.

    When comparing prices, count these, not just the headline number:

    • Seats: how many staff need access?
    • Channels: is WhatsApp or Instagram an add-on?
    • AI or automation credits: what happens when they run out?
    • Payment method: card only, or bank transfer, bKash or Nagad?
    • Setup and training: is Bangla support available?

    How to move from Excel to a CRM without losing data

    1. Clean the sheet. Remove duplicates, fix phone number formats (+8801…), and merge repeated customers.
    2. Standardise your stages. Agree on 5–8 fixed stages, such as New, Contacted, Interested, Order placed, Delivered, Lost.
    3. Start on a free plan. Test with real leads before you pay. Check that it connects to your main channel.
    4. Import your contacts. Export the sheet as CSV and import it. Map each column to a CRM field.
    5. Connect your channels. Link your Facebook page, Lead Ads form and WhatsApp number so new leads arrive automatically.
    6. Set follow-up rules. For example, a reminder if a lead has no reply in 24 hours.
    7. Run both for two weeks. Keep the sheet read-only as a backup, then retire it.

    When does a free CRM plan make more sense than paid?

    A free plan is right when you are a solo seller, have one main channel, and want to build the habit of logging every lead. Many paid features (complex workflows, many seats) are wasted on a one-person business.

    Upgrade when you add staff, add a second channel like WhatsApp, or need AI to answer while you sleep. Pay for what removes a real bottleneck, nothing more.

    Where Leads Nimble fits

    Leads Nimble is an AI sales CRM and unified inbox made in Dhaka by Luminous Labs. It brings Messenger, Instagram, WhatsApp, website chat, Telegram and Facebook Lead Ads into one pipeline, with follow-up reminders, ad attribution and team routing.

    Its AI assistant replies 24/7 in Bangla and English from your own prices and FAQs, and hands over to a human when needed. It also integrates with Google Sheets, so your old tracker can keep receiving data during the switch.

    The free forever plan costs $0 with no credit card: one user, one Messenger page, 500 AI credits a month and unlimited message sessions. Paid plans add seats, channels and AI credits, billed in Taka for Bangladeshi customers. Compare them on the pricing page, browse all features, or book a demo.

    Frequently asked questions

    Is a free CRM good enough for a small business?

    Often, yes. A solo seller or a two-person team with one main channel can run well on a free CRM plan or a tidy Google Sheet. Free options become a problem when leads come from several channels, more staff need access, or you need automation and AI replies. Then the hidden cost of missed follow-ups usually exceeds the price of a paid plan.

    What are the disadvantages of using Excel as a CRM?

    Excel needs manual data entry, so leads get missed. It has no reminders unless you build them, no conversation history, and no way to reply to customers. Two people can overwrite each other’s edits. It also cannot show which Facebook ad produced which sale unless someone types it in for every lead.

    When should I switch from a free CRM to a paid one?

    Switch when you hit a limit that blocks sales: you need more user seats, a second channel such as WhatsApp, more AI credits, or automation like follow-up reminders and chatbots. If you see two or more of the seven signs in this article, a paid plan is likely to pay for itself.

    How much does a paid CRM cost in Bangladesh?

    Prices vary widely. Global CRMs usually charge in US dollars per user per month, so the Taka cost depends on the exchange rate and needs an international card. Some tools, including Leads Nimble, bill Bangladeshi customers in Taka. Always compare total cost: seats, channels, AI credits and add-ons, not just the starting price.

    Can I import my Excel customer list into a CRM?

    Yes. Most CRMs accept a CSV file. Clean the sheet first: remove duplicates, use one phone format such as +8801XXXXXXXXX, and keep one stage per row. Then map each column to a CRM field during import. Keep the old sheet as a read-only backup for a couple of weeks.

    What should a Bangladeshi business look for in a CRM?

    Look for Messenger and WhatsApp in the same inbox, replies in Bangla, Facebook Lead Ads capture, ad attribution, follow-up reminders and a mobile app. Check payment options too: Taka billing, bank transfer, bKash or Nagad make life easier than a dollar card. Finally, start on a free plan to test with real leads.