Dear Activepieces Support,
my concern is why it doesn’t recognize the bulk numbers from my google sheet and when I test it using the connected Twilio app, It always says “Testing Failed”
I have followed the format where the numbers should be in a row and I tried the numbers to be formatted “+1” and “(690)” but it doesn’t still recognize or it always fails when I test on twilio.
This is my workflow:
PART 1: Daily SMS + Optional Slack Message (8AM every day)
Step 1: Create a New Workflow
- Go to Activepiece Dashboard
- Click “New Piece” or “Create Workflow”
- Name it:
Daily Leadership SMS
Step 2: Add Trigger: “Schedule”
Choose Schedule as the trigger
Set it to daily at 8:00 AM Pacific Time
Step 3: Add Action: “Twilio” – “Send SMS”
Add an Action Step → Select “Twilio”
Choose Send SMS
Connect your Twilio account (API credentials required)
Set up:
“To”: Add initial 5 numbers (you can later expand via list/loop)
“From”: Your Twilio number
“Message”: e.g., “Today’s Leadership Challenge: Lead with empathy in every interaction.”
You can also connect a Google Sheet and loop through phone numbers for scale later.
Step 4: Add Optional Slack Message
- Add another Action Step → Select Slack
- Choose “Send Channel Message”
- Connect your Slack workspace
- Choose channel and enter same daily message
PART 2: Weekly Email + Slack Challenge (Mondays)
Step 5: New Workflow: Weekly Challenge
- Create another workflow called
Weekly Leadership Challenge - Trigger: Schedule
- Set to: Every Monday at 8:00 AM
Step 6: Add Kajabi Email Trigger (Optional)
- If you prefer to trigger this via Kajabi email:
- Use a Webhook in Activepiece
- In Kajabi, set an email automation that triggers the webhook
- Or use Zapier to forward Kajabi email → Gmail → Google Sheet → Trigger Activepiece
Step 7: Send Email (Optional via Mail or Kajabi)
- If needed, connect an email app (like Gmail or SMTP) to send out the email challenge.
Step 8: Send Slack Message
- Add Slack Action again
- Message: e.g., “Weekly Challenge: Practice active listening during difficult conversations. Reflect by Friday.”
Optional Workarounds
If Kajabi doesn’t integrate natively:
- Option A: Set up a Gmail address to receive Kajabi emails
- Use a Zap or Activepiece webhook to:
- Read the Gmail subject/body
- Auto-log into Google Sheet
- Use Google Sheet row update as a trigger
- Then proceed to send Slack/SMS
Note:
when I test it on Twilio action, this will always appear:
Error: {“response”:{“status”:400,“body”:{“code”:21211,“message”:“Invalid ‘To’ Phone Number”,“more_info”:“https://www.twilio.com/docs/errors/21211",“status”:400}},“request”:{“body”:{“From”:“+16194324332”,“Body”:"Today’s Leadership Challenge: Lead with empathy. Take a moment to truly listen before you respond. Understanding builds trust.”,“To”:“{"row":1,"values":{"A":"+16199800429"}}”}}}
Is there something wrong with what I did? Let me know what I could do to fix this thanks!