Shata Solutions
← Back to marketplace
Marketing Automation

SMS Campaign

Send Twilio SMS bursts to opted-in segments with link tracking and opt-out handling.

Automation overview

What this automation does

This automation starts when hubSpot campaign date trigger on `sms_opt_in` segment. It twilio send and google sheets send, then hubSpot segment `sms_opt_in=true` on campaign date triggers Twilio Messaging Service send with shortened Bitly links carrying UTM, rate-limited 100/min to compl. AI handles generation and decision logic in the middle of the flow.

Trigger
HubSpot campaign date trigger on `sms_opt_in` segment
Main actions
Twilio send → Google Sheets send
Final outcome
HubSpot segment `sms_opt_in=true` on campaign date triggers Twilio Messaging Ser…
Execution time
30–90 seconds
Apps used
3 integrations
AI-powered
Yes
Difficulty
Intermediate
AIIntermediate
Workflow diagram

End-to-end scenario flow

Read-only visualization of how data moves from trigger to final result.

Trigger
HubSpot
Event detected
Step 1
Twilio
Send
Step 2
Google Sheets
Send
Result
Google Sheets
Workflow complete
Step-by-step

How each step runs

  1. 1
    HubSpotTrigger
    Event detected

    HubSpot campaign date trigger on `sms_opt_in` segment

  2. 2
    Twilio
    Send

    HubSpot segment `sms_opt_in=true` on campaign date triggers Twilio Messaging Service send with shortened Bitly links carrying UTM, rate-limited 100/min to compl

  3. 3
    Google Sheets
    Send

    HubSpot segment `sms_opt_in=true` on campaign date triggers Twilio Messaging Service send with shortened Bitly links carrying UTM, rate-limited 100/min to compl

  4. 4
    Google Sheets
    Workflow complete

    HubSpot segment `sms_opt_in=true` on campaign date triggers Twilio Messaging Service send with shortened Bitly links carrying UTM, rate-limited 100/min to compl

Apps used

Connected applications

HubSpot

Send

Twilio

Send

Google Sheets

Send

Summary

Automation summary

Trigger
HubSpot campaign date trigger on `sms_opt_in` segment
Inputs
HubSpot campaign date trigger on `sms_opt_in` segment, Business Name, Notification Email, Timezone
Outputs
HubSpot segment `sms_opt_in=true` on campaign date triggers Twilio Messaging Service send with shortened Bitly links carrying UTM, rate-limited 100/min to compl, Twilio send, Google Sheets send
Business goal
Automate sms campaign end-to-end with accurate app routing.
Execution frequency
Real-time on event
Estimated runtime
30–90 seconds
Error handling
Failed steps retry up to 3 times with exponential backoff; persistent failures notify your configured channel and log to the run history.
Dependencies
HubSpot, Twilio, Google Sheets, AI provider API
Benefits

Why use this automation?

Save ~11 hours/week

Remove repetitive steps from SMS Campaign so your team focuses on high-value work.

Reduce manual work

Connected apps sync data automatically instead of copy-paste between dashboards.

Prevent human errors

Standardized logic runs the same way every time, with retries on failure.

Faster response times

Events trigger immediate actions instead of waiting for someone to check a queue.

Requirements

What you need to get started

Required apps

  • HubSpot
  • Twilio
  • Google Sheets

Required accounts

  • Active HubSpot workspace with API access
  • Active Twilio workspace with API access
  • Active Google Sheets workspace with API access
  • Shata Automation workspace (free tier supported)

Required API keys

  • OpenAI or compatible AI provider API key
  • OAuth tokens for each connected integration

Permissions

  • Read access on trigger sources (forms, sheets, webhooks, or CRM objects)
  • Write access on destination apps (email, chat, CRM, or storage)
  • Permission to send prompts to your AI provider

Estimated setup time

  • 30 min including app authorization and test run
  • Difficulty: Intermediate

Automation runtime

Activate this template

PreviewSome steps run in preview until their integrations go live.

Connect required apps via OAuth or API keys. Credentials are encrypted server-side. Dev test runs mock external actions when connections are missing.

Draft
0%
Activation readiness

Est. setup time: ~7 min

Required connections

  • HubSpot(required)
    PreviewHubSpot: workflow actions run in preview
    Missing
  • Twilio(required)
    PreviewTwilio: workflow actions run in preview
    Missing
  • Missing connection: HubSpot
  • Missing connection: Twilio
Manage all connections →View all installations →

Workflow summary

Trigger
HubSpot campaign date trigger on `sms_opt_in` segment
Steps
4 nodes
Required apps
2
Optional apps
1

Trigger

Manual trigger

Run workflows on demand via Test run or Live test. Activate to enable scheduled/webhook triggers on other templates.

Run history

No runs yet. Install the template and run a test, or activate to receive webhook/schedule runs.

AIPremiumIntermediatePreview30 min setup4.85.0k installs · 116 reviews
Customize for My Business
Analytics

Template performance

17.6k
Views
5.0k
Installs
317
Favorites
4.8
Avg rating
28.4%
Conversion
30 min
Setup time
93%
Success rate
73
Trending score
Most used integrations
HubSpotTwilioGoogle Sheets

HubSpot segment `sms_opt_in=true` on campaign date triggers Twilio Messaging Service send with shortened Bitly links carrying UTM, rate-limited 100/min to comply with carrier rules, STOP replies auto-update HubSpot opt-out, and delivery failures log to Google Sheets for number hygiene.

Some steps run in preview until their integrations go live.

Required apps
HubSpotPreviewTwilioPreview
Optional apps
Google SheetsLive
All integrations
HubSpotTwilioGoogle Sheets
Workflow preview

How SMS Campaign runs

1
Trigger
Verify opt-in compliance
2
Process
AI decision layer
3
Action
hubspot
4
Notify
Alert & log
HubspotTwilioGoogle Sheets
Setup steps

Get started in 5 steps

  1. 1
    Connect SMS stack

    HubSpot segments, Twilio Messaging Service, Bitly, Google Sheets log.

  2. 2
    Verify opt-in compliance

    Double-check opt-in property and exclude suppressed numbers.

  3. 3
    Configure rate limits

    Throttle sends per carrier guidance; shard large lists over hours.

  4. 4
    Track link clicks

    Bitly click webhook updates HubSpot `last_sms_click` property.

  5. 5
    Test send cohort

    5 internal numbers through full link and STOP flow.

Variables

Configurable settings

VariableTypeDefaultRequired
Business NametextYour BusinessYes
Notification EmailemailYes
TimezoneselectYes
Brand VoiceselectProfessionalNo
Google Sheet IDtextNo
Sheet RangetextSheet1!A:ZNo
FAQ

Frequently asked questions

Character limits?

Workflow warns if body exceeds 160 GSM chars; suggests trim in Slack.

International SMS?

Country field selects Twilio sender ID or long code per region.

MMS images?

Optional media URL field for Twilio MMS on supported carriers.

Quiet hours?

No sends between 9 PM–8 AM recipient local time from timezone field.

Get started

Customize SMS Campaign for your business

Our team can adapt this template to your exact workflow, apps, and brand requirements.