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 for emails automatically.

It's only a couple of steps saved but it's something I do quite frequently.

2 Answers 2


Yes, there is, actually there are several ways:

For asking about software recommendations please checkout Software Recommendations

  • could you point me in the direction of any of these that would do what I'm looking for? I've been searching for awhile and haven't had much luck. Thanks for your help.
    – illg
    Apr 5, 2018 at 0:31
  • @illg If you want an addon or third party app recommendation please checkout Software Recommendations. Perhaps you will have luck and found a question posted by someone else already responded and if not you have the opportunity to post a question there.
    – Rubén
    Apr 5, 2018 at 0:34
  • I am aware that I can simply open the gmail conversation in gmail and copy the hyperlink to the spreadsheet but with hundreds of customers I'd like to find an easier way if possible.
    – illg
    Apr 5, 2018 at 0:35
  • ok thanks, i'll head over there
    – illg
    Apr 5, 2018 at 0:36

If the email address is in cell B2:

=HYPERLINK(CONCATENATE("https://mail.google.com/mail/u/0/#search/from%3A", B2), "Read Emails")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.