u/Mysterious_Waltz_118

I had a similar setup before. The easiest way is to treat “Email Open” as just another field update in Airtable.

When someone opens an email:

• get the lead’s email address
• find the same record in Airtable
• update fields like:
  • Last Opened
  • Open Count
  • Status = Opened

The important part is having a unique email field so records match correctly.

Also, I wouldn’t overcomplicate it early on. Just updating the latest engagement status in the Leads table is usually enough.