Increasing Return Visits by 35% Through Automated First-Timer Onboarding

Following up with first-time visitors required manual data entry, formatting, and scheduling across multiple platforms.

Manual phone number standardization and mailing list management caused delays in the critical post-visit follow-up window, leading to missed connection opportunities.

Personalized and timely communication across a 500+ member community could not be sustained manually.

Designed an end-to-end Make.com scenario to automatically capture visitor details, clean the data, schedule follow-up messages, and subscribe users to relevant mailing lists without manual intervention.

The system monitors a Google Sheet for new visitor entries.

It automatically splits full names into first and last names and standardizes phone numbers by stripping international dialing codes.

The data is then routed in parallel: one path schedules an automated SMS via KudiSMS for exactly six hours later, while the other makes HTTP POST requests to subscribe the user to specific Skrybe mailing lists (First Timers and General).

The workflow continuously updates the master database to log successful subscriptions and pending schedules.

Make.com, Google Sheets, Skrybe API, KudiSMS, HTTP/Webhooks.

Engineered the multi-route automation scenario, mapped the URL-encoded payloads for the HTTP requests to Skrybe, and structured the Google Sheets environment to serve as a clean, centralized operational database.

Improved follow-up efficiency, entirely eliminated manual data handling for new visitors, and contributed to a 35% increase in return visits.

Automated data sanitization (like formatting phone numbers and parsing names) at the very beginning of a workflow is the most critical step in building reliable integrations; it prevents API failures downstream and ensures automated communication feels perfectly personalized.