Wednesday 8 November 2017

Steal This Workflow: How youthSpark Created an Automated System Without Developers

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


All images courtesy of youthSpark.



source https://zapier.com/blog/how-youthspark-created-an-automated-system-without-software-developers/

No comments:

Post a Comment