I'm trying to find a way to link to an email from my Google Sheets. We use our spreadsheet as a way to track bugs, issues, to-dos, and milestone timelines (we've tried other apps, this works best). It would be great if we could reference/link to an email so that we can provide additional information.
Otherwise, I'm assuming converting the email to a Docs and then linking, is that possible?
Update: I would like to attach the body of the email, or at least link to it. For instance, say I got an email from Bob regarding the status of 'Feature A', I would like to link to that email. I was thinking of converting relevant emails to Docs and then putting it in the right folder, but I want to link to it, rather than say "Look at Document – Bob Email Re: Feature A".
Best Answer
My interpretation is that you want to add a link to your spreadsheet that leads to a Google Mail message?
Open the email message in Google Mail. The URL in the address bar is the link you want to use. I do this all the time with my own personal task tracking.
However, if multiple people are using your spreadsheet system and they all have their own non-shared accounts, I'm not so sure how useful that link to an email message will be. I believe only the person who's mailbox contains the message will be able to use the link.