Starshift WA Sender Dashboard

Sheet Scheduler

Each row is sent at its own date & time — its own message and its own attachment. Fill a Google Sheet (or Excel/CSV) with these columns:

name · mobile (with or without country code) · message · date (DD-MM-YYYY) · time (hh:mm AM/PM) · attachment (optional public link) — times are India time (IST). Any extra column works as {{column_name}} in the message. Download sample.

For the attachment link: a Google Drive share link (Anyone with the link → Viewer) or any direct file URL. Leave blank for a text-only row.

In Google Sheets: Share → Anyone with the link → Viewer, then paste the link. New rows you add later are picked up on their own (every few minutes).

Name (optional) Keep syncing — pick up new rows added to this sheet Add Book button with each scheduled message

Scheduled sheets

Auto Broadcast

Keep one file in a folder and it is sent to a saved list automatically, several times a day on a repeating schedule. Drop a new file into the folder any time — the old one is removed, and the schedule keeps sending whatever is in the folder now.

Name Send to (saved list) — pick a saved list —

Make lists in New Campaign → Recipients → Saved Lists.

Send times (India time, comma separated)

24-hour or AM/PM both work: 10:00, 14:30, 6:30 PM. A bare number means o'clock: 10 = 10:00.

Repeat Daily Weekly (same weekday) Monthly (same date) Yearly (same date) Caption (optional) Add Book button 📁 Folder (holds one file)

Select a folder and the newest file inside it is used. The folder keeps just that one file on the server; when you put a new file in your folder, select it again and it replaces the old. The schedule always sends whatever is current.

Create broadcast Cancel edit

Your broadcasts

👁️ Watch a PC folder (auto): on each broadcast, click this and choose a folder on your computer. While this dashboard tab stays open (Chrome/Edge), any new image/file you drop into that folder is sent on schedule automatically, and the older files in the folder are removed — no re-uploading. Scheduled sending itself keeps running on the server even if you close the tab.

Overview

Campaigns

Chatbot auto-replies

Select bot Bot 1 — Existing chatbotBot 2 — My shopBot 3 — Interested leadsBot 4Bot 5Bot 6Bot 7Bot 8Bot 9Bot 10

With the server WhatsApp linked, a reply goes out the moment a message arrives — nothing typed, browser closed is fine. Groups are ignored; each chat is answered at most a few times a minute.

Save selected bot settings

Chatbot link

Generate this link and paste it into a campaign message or image caption. When a customer opens it, WhatsApp shows a prefilled “hi”; they tap Send to receive the chatbot menu.

Welcome menu

Sent when a customer greets you. Clear the keywords to turn it off.

Bot 1 name (shown as "Welcome to …") Welcome keywords (comma separated) Welcome message Ask language first — 1️⃣ मराठी / 2️⃣ English Wrong option? Send the menu again Line sent above the menu Re-send the welcome menu after this many minutes of silence (0 = off)

Bot 2: Salon booking

Enable any combination of bots. Each enabled bot can reply on the same WhatsApp number. Bot 2 checks the date, opening days, time range, and duplicate bookings before confirming.

Bot / shop name

Edit this name to update the Bot 2 heading, bot replies, booking QR and linked WhatsApp profile.

Google Maps location link (save once)

Saved Campaign and Auto Broadcast messages use this link for their Location button.

Services and prices (one per line or comma-separated, e.g. Haircut-300, Facial-500) Opening days First available booking date Salon opening time Salon closing time Break time from (optional) Break time to (optional)

Appointments will not be offered during this interval, for example 1:00 PM to 2:00 PM.

Default workers available for each time slot (1–10) Set a different worker count for a date

Each worker has their own slot. For example, 2 workers show 1:00 PM · Worker 1 and 1:00 PM · Worker 2. A confirmed booking reserves that worker and time.

Booking alert WhatsApp number (country code included, optional)

The daily date-wise Excel report (booked and cancelled appointments) is sent to this WhatsApp number at 11:59 PM India time.

Repeat booking summary (minutes, 0 to turn off)

New bookings still send one immediate alert. Set this to 0 to stop repeated booking updates.

Start / welcome message (shown with Book Appointment buttons) Thank-you message after confirmation Welcome message after confirmation

Placeholders: {{name}}, {{salon}}, {{service}}, {{date}}, {{time}}.

Customer booking link Generate date-wise report

Set the first booking date and salon hours with the date and time pickers. WhatsApp customers can choose an available date and 30-minute time slot from numbered options, or type their own. Send “cancel” during booking to stop. Confirmed bookings are saved on the server and sent to the alert number when configured.

Bot 3: Interested leads

Add the Interested button to a campaign. When someone taps it, Bot 3 saves their WhatsApp name and number, asks their city, and stores the answer with India date and time.

Bot name / company name Trigger keywords (comma separated, optional) Auto-reply for trigger keywords (optional) Question to ask for city Reply after city is received Reply if customer taps Interested again (within 24 hours) Thank-you message after confirmation Welcome message after confirmation

Placeholders: {{name}}, {{number}}, {{city}}, {{shop}}. Thank-you and Welcome are added at the top of the reply after city.

Send enquiry details to WhatsApp number (optional) Send consolidated Excel every (minutes) Daily final Excel send time (India time) Also send daily Excel report to email (optional)

Updated Excel files go to the WhatsApp number above and configured email. At the daily final time, one compulsory full-day report is sent (even if there were no enquiries). Periodic reports stop at that time and do not send again until the next day. Email needs the server mail service to be configured.

Download interested leads Excel

Bot 4: Table booking

Customers scan the branch QR to open WhatsApp. Their WhatsApp name and number are picked up automatically; the bot asks for party size and current location, then sends the queue number and branch welcome after a location check within 50 metres.

Hotel / shop name Hotel / shop name in Marathi (shown when the customer picks मराठी) Welcome message

Message placeholders: {{shop}}, {{branch}}, {{queue}}, {{name}}, and {{members}}.

Thank-you message after confirmation Welcome message after confirmation

Placeholders: {{name}}, {{shop}}, {{branch}}, {{members}}, {{queue}}, {{wait}}, {{time}}.

Add one entry per branch. Customers must be within 50 metres of that branch to book. Use the exact map pin coordinates and include the country code in the WhatsApp number.

＋ Add branch

Bot 5

Customer details from Excel. Upload a sheet with a Mobile column. Share the link / QR - when the customer's WhatsApp number is in the sheet, the bot shows Continue, Location and Contact. Continue sends that customer's details (all their rows).

Bot 5 name

Columns to send (keys, comma separated - leave empty to send all)

Link / QR text (trigger keyword) Welcome message (shown with Continue / Location / Contact) Message above the details Reply if number is not in the sheet Location link (Google Maps) Contact number

Shown as Location and Contact buttons under the details.

Placeholders: {{name}} (WhatsApp name), {{number}}, {{shop}} (Bot 5 name). Location uses the Google Maps link saved in Bot 2; Contact uses the linked WhatsApp number.

Customer link

Bot 6

Website bot. Share the link / QR: the customer gets your welcome message with a button that opens your website.

Shop name Welcome message

Placeholders: {{name}} (customer's WhatsApp name), {{shop}} (shop name).

Website link Button text Link / QR text (what the customer sends; leave empty to use the shop name) Customer link

Bot 7

This bot is blank for now. Ask Starshift to set it up for your business.

Bot 8

This bot is blank for now. Ask Starshift to set it up for your business.

Bot 9

This bot is blank for now. Ask Starshift to set it up for your business.

Bot 10

This bot is blank for now. Ask Starshift to set it up for your business.

Customer lookup (loan details etc.)

Attach a sheet keyed by mobile number (columns like Name, Loan Amount, Interest, Total Outstanding). When a customer whose number is in the sheet sends the keyword below, the bot replies with their own row. Numbers not in the sheet get the “not registered” message.

Enable customer lookup Trigger keyword(s) (comma separated) — e.g. a menu option “Not registered” reply (for numbers not in the sheet)

One column must be Mobile (or Number/Phone), with or without country code. Other columns are sent back as “Header: value”. Re-upload any time to refresh.

Keyword rules

Checked top to bottom; the first match replies. A number keyword (menu option) must be the whole message.

Reply Reply — English (for bilingual, optional) Add rule

Unsubscribe (STOP / START)

Move anyone who sends STOP to the Unsubscribers list STOP keywords START keywords STOP reply STOP reply — English (for bilingual)

Test reply

Type what a customer might send to see the reply the bot would pick. Nothing is sent. (Tick “Enable chatbot” above for rules to apply.)

Customer talked to the bot in the last 24 hours Test as an unsubscribed contact

Quick replies

Saved answers for common questions, prices or support steps. Click one to copy it.

Title Reply text Save quick reply

Unsubscribers (0)

People on this list are never messaged by a campaign. One per line: a mobile number with country code, or a chat / group name. STOP replies from the chatbot are added here automatically.

Save unsubscribers

Call Settings

Works on the WhatsApp number linked to this server. The call button still shows on the customer's phone; the call is cut as soon as it rings.

Block WhatsApp calls — incoming calls are cut automatically, customers can only chat Message sent to the caller after a blocked call (leave empty to send nothing)

Chat Extract to Excel

Pick a chat — one number or a group — and download its messages as an Excel file. Choose All chats to export everything together.

Chat — pick a group or a contact All chats Or type a mobile number (with country code) Date range Today Last 7 days Last 15 days Last 1 month Last 2 months All

Load older from WhatsApp asks WhatsApp to send older messages of the selected chat (needs at least one message already in it). Wait a few seconds, then download again — it may bring a limited window, so click it again to go further back.

Note: messages are saved from the time this feature went live (plus whatever WhatsApp back-syncs when the account links), so very old chats may be partial.

Mobile Numbers to Excel

Download every contact the server's WhatsApp knows — name and mobile number — as an Excel file.

---

Group members to Excel

Pick a group and download all its members — name and mobile number.

Group

Your API key

Use this key to send messages and run campaigns from your own website, software or tools — without logging in. It drives your own linked WhatsApp. Keep it secret; anyone with it can send from your account.

Resetting makes a new key and the old one stops working immediately.

How to use it

Base URL: https://api.starshift.in. Send your key in the x-api-key header.

Send one message

Start a bulk campaign

Other endpoints

GET /api/v1/status — is WhatsApp linked
GET /api/v1/campaign/<id> — campaign sent/failed + failed list
GET /api/v1/chats, /api/v1/chat-export?jid=&range=7days, /api/v1/group-members?jid= — needs the Chat Extract add-on