Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello,

 

            I am working on a Zap to send text reminders to participants in an online group.  I want to send it to the participants 24 hours before the online meeting.  I have an excel spreadsheet with the meeting date/time in one column and participant phone numbers in another column.  I have connected it with Delay by Zapier and SMS by Zapier, and while the test works it does not work in real life.  I have tried using Copilot to build the basic steps, but I feel that the issue may be with something niche like the excel formatting.  Any help would be greatly appreciated.

Care to share any screenshots?

 

What is your trigger? How do you get the phone number? How are you testing vs. how do you expect it to run live?

Hi ​@SOF 

You may want to try using Airtable instead of Excel.

In Airtable, you can configure logic such that records enter Views when Filter conditions are met.

e.g. Formula field calculates the time difference between NOW and the DateTime in “hours”.

Then you can configure a View Filter condition for hours < 24.

When a record enters a View that can trigger a Zap to run.

 

Airtable Views help: https://support.airtable.com/docs/getting-started-with-airtable-views

Airtable Zap app: https://zapier.com/apps/airtable/integrations#triggers-and-actions

 

Care to share any screenshots?

 

What is your trigger? How do you get the phone number? How are you testing vs. how do you expect it to run live?

Hi David,

 

          My trigger is an updated row in my excel spreadsheet.  The participants provide us their phone numbers and we put them in an excel spreadsheet.  When I run a test of the Zap, I get a text message.  However, when I put in a meeting date/time and my personal phone number in the excel spreadsheet, I do not get a text message.  I do know that SMS by Zapier does not work with T Mobile, but I have AT&T so I know that is not the issue.   Below are a few screenshots, hopefully these help.  I am considering using Twilio instead of SMS by Zapier, if you have any recommendations I am open to them.

f27c8b10acdfbc2fc174fbcb94ea0b57.png
 

5114f22a67b4b6f86c36604eaae99c93.png

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing sensitive details.

Hi ​@SOF 

You may want to try using Airtable instead of Excel.

In Airtable, you can configure logic such that records enter Views when Filter conditions are met.

e.g. Formula field calculates the time difference between NOW and the DateTime in “hours”.

Then you can configure a View Filter condition for hours < 24.

When a record enters a View that can trigger a Zap to run.

 

Airtable Views help: https://support.airtable.com/docs/getting-started-with-airtable-views

Airtable Zap app: https://zapier.com/apps/airtable/integrations#triggers-and-actions

 

Thanks for the advice, Troy!  I will check that out!  I am still new to Zapier, so this helps a lot!

Terms & ConditionsAccessibility statement