Best answer

Send notifications to multiple users via Find Record in Airtable


Userlevel 2
Badge +1

I have an automation set up to send SMS notices via Twilio on a scheduled basis. Prior to sending the SMS via twilio, I use a Find Record in Airtable Action to filter all the records that match certain conditions on any given day. This list of recipients will change anywhere from 0 to 20 per day.

The automation currently only runs once and sends a message to the first record found. How do I set this up to send the text message to all found records, not just one?

 

 

icon

Best answer by christina.d 24 June 2022, 02:03

View original

3 replies

Userlevel 7
Badge +14

Hi @mannyv86 

Good question.

FYI: Most Zap triggers/actions work on a per record basis. (1 record)

The Airtable Find Record Zap action step will only return 1 record (if found).

You’d need to use the Airtable API to search for and return 2+ records.

App APIs can be used in Zaps with the Webhooks app as an action step.

The Looping app can be used to handle line items (aka multiple records).

 

Userlevel 7
Badge +14

@mannyv86 

Alternatively, you may want to look into using Airtable Automations which has an integration with Twilio to send SMS.

 

Userlevel 7
Badge +9

Hi there, @mannyv86! I can see you were able to chat with our friends in support about this! I wanted to pop their recommendation here in case it’s helpful. 🤗

I reviewed the Zap and the issue here is that the Find Record in Airtable action will only ever return a single record. In this case, I would actually recommend a different Zap setup:
 

  1. New Record in Airtable (limit this to a specific view that has the desired records)
  2. Append Entry and Schedule Digest (you can then schedule this Digest to release Daily at the desired time). You can then add the phone numbers and the output will have a comma-separated list of those numbers that you can map directly to the Send SMS action. As a note, if you need to add the country identifier to the beginning of each phone number, you will want to configure that in this Digest action. 
  3. Send SMS in Twilio

 

Troy also had an alternative solution here! 

FYI: Most Zap triggers/actions work on a per record basis. (1 record)

The Airtable Find Record Zap action step will only return 1 record (if found).

You’d need to use the Airtable API to search for and return 2+ records.

App APIs can be used in Zaps with the Webhooks app as an action step.

The Looping app can be used to handle line items (aka multiple records).

 

 

Reply