I'm creating a spreadsheet for customers and I'd like to be able to view email conversations I've had with them a little more efficiently. Right now I find the email address in the spreadsheet and then open Google sheets and search. What I'd like is a link on my spreadsheet that opens Gmail and searches automatically. It's only a couple of steps saved but something I do quite frequently.
Yes, there is, actually there are several ways:
- Option 1: You could use Google Apps Script and the Gmail Service or the Gmail API. See Extending Google Sheets.
- Option 2: Use a Google Sheets add-on. See Use add-ons and Apps Script.
- Option 3: Use third party app. See Account permissions.
For asking about software recommendations please checkout Software Recommendations