Google Sheets Integration

Trigger Calls and SMS from Google Sheets

Launch bulk voice campaigns, reminders, and customer notifications directly from spreadsheet rows without writing code.

API Ready Automated Calls Built for Pakistan

Setup Guide

Google Sheet Bulk Calling Setup Guide

Copy the master sheet, activate permissions, fill the Settings tab, and send bulk calls directly from spreadsheet rows.

Step 1

Make a Copy of the Master Sheet

Open the master sheet, click File > Make a copy, save it in My Drive, and rename it for your brand or campaign. Do not edit the master sheet directly.

Step 2

Enable Google Script Permissions

Open Extensions > Apps Script, click Run, choose your Google account, then use Advanced > Allow so Apps Script can send calls and fetch call statuses.

Step 3

Fill the SETTINGS Tab

Enter only the required fields: API Key, Voice ID, and Portal Type. Portal Type should be portal or corporate exactly as shared by Robo Call Pakistan.

Step 4

Fill the DATA Tab

Add Caller Number, Amount, Text1, Text2, Text3, Text4, and Text5. Call Status, DTMF, and Call ID are auto-filled after fetching statuses.

Step 5

Run Bulk Calls

From the top menu, click Bulk Robo Call Menu and select Send Bulk Call. The system will send calls for rows with phone numbers.

Step 6

Fetch Call Status

After 2-5 minutes, click Bulk Robo Call Menu and select Fetch Bulk Call Status to update Call Status, DTMF response, and Call ID.

Settings Tab Fields

FieldWhat to Enter
API KeyProvided by Robo Call Pakistan
Voice IDYour assigned voice profile ID
Portal Typeportal or corporate

Data Tab Columns

ColumnDescription
Caller NumberCustomer phone number, for example 03xxxxxxxxx
AmountOrder amount
Text1Store or company name
Text2Order number or reference
Text3 / Text4 / Text5Additional optional fields
Call Status / DTMF / Call IDAuto-filled after status fetch. DTMF: 1 confirm, 2 cancel, 3 callback.

Troubleshooting Checklist

  • API Key, Voice ID, and Portal Type are entered correctly
  • Script permissions are allowed
  • You are using your own copy, not the master sheet
  • Column names are unchanged
  • No empty rows are left in the middle of the table
  • Internet connection is stable

Solutions

Automation workflows for this business use case

Use Robo Call Pakistan to automate alerts, reminders, verification, campaigns, and customer communication.

Voice Alerts

Notify customers immediately when important events happen.

Smart Automation

Use retries, schedules, APIs, and reporting to reduce manual work.

Reports & Webhooks

Track outcomes and send data back to business systems.

Live Demo

Try a campaign demo call

Bulk marketing and campaign demo voices are controlled from Theme Options. You can change labels, voice IDs, fields, API settings, and notification recipients.

Get Free Bulk Marketing Robo Call Demo

Your demo request is secure and handled by our support team.

How It Works

Simple steps to automate customer communication and save time.

1

Event Triggered

Order placed or data received from your platform.

2

System Processes

Our system validates data and prepares the call.

3

Call Initiated

Voice call is placed to your customer automatically.

4

Customer Responds

Customer interacts via voice or keypad.

5

Real-time Update

Status appears on dashboard and API.

Everything You Need to Automate Calls

AI Voice Calls
SMS Notifications
Smart Retry
IVR & DTMF
Bulk Calling
Multi-language
Real-time Analytics
Call Scheduling
API Integration
Secure & Reliable

Trusted by Hundreds of Businesses Nationwide

Government of Pakistan
Lahore Bar Association
Mahir Company
OLX Pakistan
Codingal
GU Tech
KNS
Master
VLCC
Red n Bed
Furnir
Ajmal Perfumes
Philips
Beddy's Studio
Molana Muhammad Usman
MEEM
Hadiya
Medevox
Nutra Blend
Zarhas.pk
Ample

What Our Clients Say

H

Hassan Raza

CEO, NV Trackers

"Robo Call Pakistan has reduced our manual work by 80% and improved customer satisfaction significantly."

*****
A

Ayesha Tariq

Founder, Glamour PK

"AI address validation and order confirmation calls have reduced our return rate like never before."

*****
U

Usman Khalid

Operations Head, Trackers.pk

"Reliable, fast, and feature rich platform. Highly recommended for any business."

*****