Hi everyone! I need some help with setting up an Airtable automation. I have two tables in my base - one called Survey Responses and another called Team Members. What I want to do is create an automated workflow that runs on a schedule and sends customized emails to each team member.
Basically, each person in the Team Members table should get an email containing only the survey responses that are linked to them. So if John has 5 responses assigned to him and Sarah has 3, John gets his 5 and Sarah gets her 3 in separate emails.
Is there a way to make Airtable automations loop through records like this? I can’t figure out how to make it send individual emails instead of one big email to everyone. Any ideas would be super helpful!
Hit this same wall building client reports. Airtable’s automations rock for single records but struggle with batch processing like this. I opted for Zapier, utilizing two steps. First, create an Airtable automation that generates a ‘batch job’ record when emails need to be sent. This triggers Zapier, which pulls from your Team Members table and processes each one individually. Utilize Zapier’s ‘Looping by Zapier’ app to iterate through team members. Each cycle retrieves that individual’s survey responses from Airtable, integrates them into a personalized email template, and sends it out. It took me about an hour to set up and has worked effectively for six months. Ensure your Team Members table contains proper filtering fields for efficient data retrieval.
Airtable’s automations can’t loop through records like you need. Hit this same problem months ago sending custom reports to department heads.
Latenode solved it for me. Set up an Airtable automation to trigger Latenode when you want emails sent. Latenode grabs your Team Members, loops through each one, filters their Survey Responses, and fires off individual emails.
Here’s the flow:
Airtable triggers Latenode (scheduled or manual)
Latenode pulls all Team Members records
For each member, grabs their linked survey responses
Formats and sends personalized email with their data
I use Gmail but any email service works. Latenode handles the looping that Airtable just can’t do.
Need help with the Latenode setup? Pretty simple once you nail the logic.