Call New Leads from a Google Sheet Every Day, Automatically

In short: Connect the sheet with Import into a lead group. Then either switch on the group's automatic call, or create one campaign on the group with Keep calling new leads that join this group. Each new row becomes a lead within about five minutes and is called, every day, with nothing to relaunch.

A step-by-step guide for BookAICall, an AI voice agent platform that makes and answers phone calls for businesses in Hindi, English, Hinglish and other Indian languages. Updated .

Steps

  1. Open Unified CRM → Manage Groups and create a group for the calls, for example "Delayed orders".

    A lead group for the calls, for example Delayed orders
    A lead group for the calls, for example Delayed orders
  2. In the group, switch on Auto-trigger on new lead, choose the agent under Legacy: Immediate AI Call Agent, and set Call Delay (minutes), 0 to call at once.

    Auto-trigger on new lead: the agent that calls each new lead, and the delay
    Auto-trigger on new lead: the agent that calls each new lead, and the delay
  3. Open Google Sheets, connect the sheet with Sync Direction Import (or Two-way Sync), and choose the group under Auto-Assign to Group.

    Import the sheet into the group with Auto-Assign to Group
    Import the sheet into the group with Auto-Assign to Group
  4. To write each call's result back to the sheet, also click Connect Google Account with an account that can edit the sheet and set up Post-Call Writeback Configuration.

    To write results back, connect a Google account that can edit the sheet
    To write results back, connect a Google account that can edit the sheet
  5. Add rows to the sheet as orders come in. Every new phone number is called once when it joins the group, between 9 AM and 9 PM IST (rows synced at night are called from 9:15 AM); see each call in Call Logs and on the lead's page.

Or: one campaign that keeps calling

  • Do steps 1 and 3 (a group, and the sheet importing into it), but leave the group's automatic call off.
  • Campaigns → New Campaign, choose the group under Lead Group Filter and tick Keep calling new leads that join this group, then Create & Launch.
  • The campaign stays on: every new lead of the group is added within a minute and called in calling hours, with the campaign's retry rules and one results page for all of them.
  • The campaign page shows Keeps calling new group leads; click its cross to stop adding (the campaign then finishes its current leads), or Pause the campaign.

Which to choose

  • The group's automatic call: the simplest, one call per new lead, results on each lead's page and in Call Logs.
  • A keep-calling campaign: retries for people who did not answer, follow-up email or WhatsApp, and campaign results and exports for the whole flow. Use one or the other on a group, not both, or a new lead could be called twice.

How the timing works

  • The sheet is read every few minutes; each new row with a phone number becomes a lead and joins the group.
  • The group's automatic call waits the Call Delay you set; a keep-calling campaign picks the lead up within a minute.
  • Calls go out between 9 AM and 9 PM IST. Rows that arrive at night are called from 9:15 AM, so a morning batch does not all ring at 9:00.
  • The agent's channels limit how many calls happen at once; the rest wait their turn.

Example: Delayed-order calls for a D2C brand

A D2C skincare brand keeps a sheet "Delayed orders" that its warehouse fills every evening. It is imported into the group "Delayed orders", and a campaign on that group has Keep calling new leads that join this group, with 2 attempts 3 hours apart and a WhatsApp template for those not reached. Rows added at 8 PM are called from 9:15 AM next day; the agent apologises, gives the new delivery date and offers a callback. The team reads the day's outcomes on one campaign page.

Tips

  • A number already in the group is not called again by the group. To call it again for a new order, use Call AI, a new campaign or Redial.
  • Removing a row from the sheet does not remove the lead from the group.
  • Keep one phone number column in the sheet, with 10-digit Indian numbers.

Frequently asked questions

Can a campaign stay always on and call new rows?

Yes: tick Keep calling new leads that join this group when you create it on a group.

At what time are the new rows called?

Between 9 AM and 9 PM IST, soon after the row is synced (plus the Call Delay of a group's automatic call). Rows synced at night are called from 9:15 AM.

Sheet me roz naye order aate hai, kya har baar campaign banana padega?

No. Set it up once as above; every new row is called by itself each day.

A customer appears in the sheet again with a new order. Is he called again?

Not by the group or the keep-calling campaign: each number is called once when it first joins. Call him with Call AI on his row, or include him in a new campaign.

Can the call result go back into the sheet?

Yes, with Post-Call Writeback Configuration and a connected Google account that can edit the sheet. See the writeback guide if the results do not appear.

How do I stop the daily calls?

Switch off Auto-trigger on new lead in the group, or on the keep-calling campaign click the cross on Keeps calling new group leads, or Pause it.

Questions this guide answers

  • How do I auto-call new rows from a Google Sheet?
  • Can an AI calling campaign pick up new leads automatically?
  • How do I make an always-on AI calling campaign?

Related guides

Start the free trial · Book a demo · All guides

BookAICall provides enterprise AI voice agents with real-time conversational capabilities.

Contact: [email protected] | +91-8502044044 | Mansarovar Jaipur Rajasthan