Hi everyone!
I’m trying to understand how to build a smart automated message flow in Make.com using Airtable and Green API, and my brain is exploding 
from trying to figure it all out. I’d really appreciate your help!
What I’m trying to build:
I created two tables in Airtable:
- Leads table – contains my contacts/leads.
- Messages table – contains different messages for different customer statuses (like “Follow-up”, “In Process”, etc.)
When a person (lead) enters a specific status, I want them to start receiving a sequence of WhatsApp messages, with delays between each message, based on when they entered that status.
For example:
- On the day they enter the status: send message 1
- After 4 days: send message 2
- After 8 days: send message 3
- …and so on
But each person should follow their own timeline– I don’t want everyone to get the same messages at the same time. Each lead should start the message sequence according totheir personal activation date.
- How do I connect these two tables in Make.com?
- How do I check when a lead entered the status and send the right message based on days passed?
- How do I make sure each lead only gets the next message in their sequence (no duplicates)?
- And most importantly – how do I make sure each person is “locked” to their own timeline?
If anyone has a working example or even a video tutorial, that would help me a lot
