My team uses Airtable to track interactions, meaning every time we interact with an outside organization we create a new entry in Airtable. Right now, you add a new interaction using a form. Does anyone have ways of streamlining this process? For example, I would love to link my email and have a new interaction created each time I email someone with no extra work on my part. Is that possible? Has anyone found other ways to streamline this kind of tracking? I have not done much with Automations or AI Agents yet, wondering if this is the kind of thing they do?
Question
Help Needed: Tracking Interactions in Airtable
Not exactly an answer to your question, but you could do this a few different ways. I love to use the comment section to track interactions. I add fields to for last and next contact. You can upload word docs of the interaction notes to the comment section as well.
An AI solution might be to connect Claude to your Airtable and email, have it run on a schedule to pull the interaction into your table, along with the link to your email message thread. If you interact in other ways (phone, Instagram, etc.) that would require layering in some added agents.
+35
Airtable’s automations can only monitor emails in your inbox (not your sent mailbox), so if you CC yourself (or a special email address), you can have Airtable monitor that inbox and create new interaction records.
Otherwise, for monitoring your sent mailbox, you would need to create your own custom “email monitoring” automation by using Make’s automations & integrations, which would monitor your sent emails.
Then, whenever you send an email, it would automatically create the new interaction record in Airtable.
It could also search your Airtable base for the email address that you sent the message to, and it could automatically link that interaction to the person or organization with that email.
If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread, including an introductory Loom video.
I also give live demonstrations of Make in several of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make. And in this video, I show how to use custom webhooks.
Hope this helps!
If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+32If you’re on the Business plan and above, you can set up an automation trigger of ‘When email received’ and have the action be to create a new record for you, and so the idea would be to BCC the email address when you’re sending stuff out:
https://support.airtable.com/docs/airtable-automation-trigger-when-email-received
If you’re not on Business, you can use the ‘When Outlook email received’ trigger instead with the same logic as above, would just have to create a free Outlook account if you don’t have one!
https://support.airtable.com/docs/outlook-automation-triggers
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.