Phone Calls & Texts Automation Legacy Systems | Robotalker

Send calls and texts from files on your FTP server. No changes needed to how you're doing things now.

Here's the basic flow:

1. We grab your files: Our system checks your FTP/SFTP on whatever schedule works (every hour, daily, whatever)
2. Parse the data: Pull out phone numbers, names, message text from CSV, XML, fixed-width files, or your custom format
3. Send it out: Make the calls or send SMS with personalized info from your data
4. Report back: Drop delivery reports back on your FTP or hit a webhook

File formats we handle:

• ✓ CSV files
• ✓ Fixed-width text
• ✓ XML
• ✓ JSON
• ✓ Excel (.xlsx, .xls)
• ✓ Pipe-delimited
• ✓ Tab-delimited
• ✓ Your weird proprietary format (seriously, we've seen it all)

What you get:

Cost: $500 setup + $0/month | Time to launch: 2-3 weeks

Hook EDI transactions to phone calls and texts - great for supply chain and logistics.

EDI formats we work with:

How it works:

1. Get the EDI doc: Via AS2, FTP, SFTP, or your VAN
2. Parse it: Pull out the data from EDI segments
3. Apply your rules: Figure out who needs to be called/texted
4. Make contact: Send notifications about shipments, deliveries, changes
5. Confirm: Send 997 functional acks back to partners

Who uses this:

• • Retail
• • Manufacturing
• • Healthcare
• • Logistics
• • Automotive
• • Pharma

Cost: $500 setup | Time: 2-3 weeks

Turn emails from your legacy system into instant phone calls or texts. Perfect when your old system only knows how to send email.

The setup:

1. Get a custom address: Like alerts@yourcompany.robotalker.com
2. We parse it: Pull phone numbers and message content from the email
3. Map the data: Use custom rules to format the call/SMS
4. Send immediately: Calls or texts go out within seconds
5. Confirm if you want: Optional delivery report emailed back

What we can parse:

• ✓ Structured templates with variables
• ✓ Data in attachments (CSV, Excel, PDF)
• ✓ HTML or plain text emails
• ✓ Regex patterns for custom formats
• ✓ Multiple recipients from To/CC/BCC
• ✓ Priority routing by subject line

Common uses:

Extra features:

• Filters: Only trigger for specific senders or keywords
• Rate limits: Prevent spam (max calls per hour/day)
• Escalation: Call backup if first person doesn't respond in X minutes
• Two-way: Get SMS replies forwarded as emails

Cost: $500 setup + $79/month | Time: 1-2 weeks

Connect straight to your database for real-time calls and texts triggered by data changes or scheduled queries.

Databases we connect to:

Connection methods:

1. Scheduled queries:

Run SQL on a schedule to find records that need attention:

SELECT CustomerID, PhoneNumber, FirstName, AppointmentDate, AppointmentTime
FROM Appointments 
WHERE AppointmentDate = DATEADD(day, 1, GETDATE())
  AND ReminderSent = 0
  AND PhoneNumber IS NOT NULL

Results trigger personalized reminder calls automatically.

2. Database triggers:

Fire a webhook when data changes:

CREATE TRIGGER SendShipmentNotification
ON Orders
AFTER UPDATE
AS
BEGIN
  IF UPDATE(ShipmentStatus) AND ShipmentStatus = 'Shipped'
  BEGIN
    EXEC sp_invoke_webhook 'https://api.robotalker.com/trigger/shipment'
  END
END

3. Stored procedures:

Call our API right from your stored procs.

4. Change data capture:

Monitor DB change logs without slowing down your production database.

CRM integrations:

• Salesforce: Call hot leads instantly when status changes
• HubSpot: SMS when contact becomes MQL
• Dynamics: Reminder calls for service appointments
• Zoho: Alert sales reps for high-value deals
• Custom CRM: Direct SQL to your homegrown system

Security stuff:

• ✓ Read-only: We don't modify your data (unless you want us to)
• ✓ VPN/SSH tunnels: Encrypted connections to on-prem DBs
• ✓ IP whitelisting: Lock it down to our servers only
• ✓ Service accounts: Minimal permissions, separate user
• ✓ HIPAA: BAA available for healthcare
• ✓ Audit logs: Full tracking of queries and data access

Cost: $500 setup + $0/month | Time: 2-4 weeks

For systems with APIs, we build custom middleware to bridge your API to our calling/SMS platform.

Integration approaches:

1. REST API bridge:

Custom middleware that:

• Takes REST calls from your system
• Translates formats and field mappings
• Handles auth (OAuth, keys, SAML)
• Routes to Robotalker for dispatch
• Returns responses in your format

2. SOAP web services:

For older enterprise systems using SOAP/XML:

• WSDL endpoints for your system
• WS-Security auth
• SOAP 1.1 and 1.2
• Complex data types

3. Message queues:

Connect via enterprise queuing:

• IBM MQ: Mainframe queue messages
• RabbitMQ: Subscribe to topics
• Kafka: Consume event streams
• MSMQ: Windows message queues
• Azure Service Bus: Cloud queues

4. Legacy protocols:

We handle the really old stuff too:

• XML-RPC
• JSON-RPC
• CORBA
• COM/DCOM
• Custom TCP/IP sockets

Middleware features:

Cost: $500 setup + $0/month hosting | Time: 3-5 weeks