We are looking into using appsheet as a CRM. Our current CRM will import emails so that when you’re in the contact you can see all emails that are from or to the email address of the contact. Is there anyway to do something similar in appsheet? Even if it requires a different program or some manual effort.
You can provide the same with 2 different options:
1.) You can create a Google Apps Script which will run in regular intervals and check your email inbox, process the new threads (or what you want to check) and record it into your gSheet
2.) You can use an external service i.e. Zapier, IFTTT etc. to record email body data to your gSheet when a new email arrives to your inbox or an email arrives with to your inbox with a set of conditions i.e. from, subject line contains some words etc.