Loading
Loading
  • Home

  • Automation with Zapier

  • Customer stories

Customer stories

2 min read

How youthSpark Created an Automated System Without Developers

By Cass Hill · November 8, 2017
build-database-without-enginee primary img

A leading innovator in the battle against human trafficking, Georgia's youthSpark transforms the lives of youths at risk for exploitation and abuse. They have become a thought leader in reducing child exploitation and sex trafficking rates in Georgia and across the country, too.

Part of youthSpark's mission to reduce the rate of exploitation stemmed from an idea for an automated deterrent initiative, which later became know as Demand Tracker.

Demand Tracker starts with a youthSpark employee posting a decoy ad to lure in prospective traffickers and buyers. When someone calls or texts the number in the ad, their phone number is recorded in Demand Tracker, where anyone can search the publicly available phone numbers. Callers also receive a deterrence text message warning them that their number has been flagged and made available to law enforcement.

Demand Tracker

Alex Trouteaud, Executive Director at youthSpark, faced a serious challenge in order to bring Demand Tracker to life: How do you build an automated system without software developers?

"We've had a great idea for an automated deterrence system to help reduce perpetration rates in Atlanta," Alex explains. "But finding a developer to work with who could do what we needed, with a budget we could afford and who had the spare time to do the work was proving impossible."

At the heart of Demand Tracker are two applications: Communications APIs provider Twilio and database builder Airtable. Alex and the youthSpark team connected Twilio and Airtable through app automation tool Zapier and a couple of Zaps (a bridge between two or more apps).

Zapier logs any calls made to a Twilio phone number in Airtable, building Demand Tracker's database one call at a time. Once a new row is added to that Airtable, Zapier automatically sends a text to that number, alerting them they've been added to Demand Tracker.

Alex was able to create a system with the potential to deter thousands of prospective predators within a few weeks. All without the need for software development expertise. "We have an incredible system that is working like a charm," Alex says.

youthSpark's Automation Workflow

Log your Twilio calls to an Airtable base

Log your Twilio calls to an Airtable base
  • Twilio logo
  • Airtable logo
Twilio + Airtable

All images courtesy of youthSpark.

What's your story? Tell us how you use Zapier to do more. You can also read even more customer stories and find new ways to improve your workflow and productivity.

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'