Sync Gmail to Interactions table

[Ryan_Morris1]

1. I want to show the previous email exchange I had with my contacts. “I want to create an Interaction table” with the following fields: (Number of emails, Total interactions, Last interaction, Last email received, last email sent)

a. How can I connect my Gmail/Outlook to Airtable for that?

2. For calendar events (google/microsoft): I want to have the following fields.
   -last time I had a calendar invite with someone
   -last time I invited them to an event
   -last time they came to my event

How would I automate/formulate this so it appears on my CRM?

Thanks in advance for your help!

[ScottWorld · Accepted solution]

Airtable offers a few basic tools that might be of use to you:

• Airtable Sync for Google Calendar
• Automation triggers for Google calendar events
• Automation triggers for Outlook emails & Outlook events
• Automation action for sending emails via Gmail

For anything more advanced than what Airtable offers, you would need to turn to an external automation tool like Make.com.

[Ryan_Morris1]

@ScottWorld I appreciate your help! I will check the links you shared, and I hope with these links I can show the fields I need on my CRM.