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.

I'm creating a spreadsheet of my customers and I'd like to be able to view email conversations I've had with them more efficiently. 

Right now I copy their email address from the spreadsheet and then open Gmail and paste it into the search box.

What I'd like is a link in my spreadsheet that opens Gmail and searches for conversations with that customer automatically.

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.

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.