Googlsheet & Twilio ERROR Concerns

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!

Hello @kmensior ,

It seems that the mapping in the ‘To’ field is incorrect in the response. You only need to provide the value from column ‘A’ in this field, as it contains the actual phone number. Could you try it after making this change?

1 Like