7

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".

  • You have to be a little bit more detailed.. If I understand you correctly you have a list of members that have emails and some additional data like title, role etc and you want to display this info when you just writing their emails? – Lipis Jul 21 '10 at 17:54
  • Please make it clear if you want include an e-mail address, attach an e-mail as a file, or link to an email in, say, gmail. – Ben Gartner Jul 21 '10 at 19:07
4

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.

2

You could use a collaborative inbox, which is a feature of Google Groups for Business that gives multiple persons access to a mailbox.

When viewing a message in the collaborative inbox, you could copy the URL to that message, and paste it in your spreadsheet.

See Google's documentation: Use a group as a collaborative inbox

  • Using a group as a collaborative inbox could be a great solution, I think. (This is my favorite answer among the others available at this time). – Rubén Dec 15 '16 at 15:15
1

There is Google Labs feature in Gmail to convert email conversation to Google Docs; then you can copy the URL of the Docs that you just created and insert it as a link from another Docs.

0

Assuming you want the email there for more information, and you want others to be able to access this email, it might be best to import the email into Evernote or another note-taking application that you use and then give it a share url from there.

-1

You could use the VLOOKUP function.

Example on how to use it:

Let's say you have table with your members like this:

    |          A          |      B      |      C      |
--------------------------------------------------------
 1  |       E-mail        |    Name     |   Company   |
--------------------------------------------------------
 2  | bill@microsoft.com  | Bill Gates  |  Microsoft  | 
 3  | sergey@google.com   | Sergey Brin |  Google     | 
 4  | steve@apple.com     | Steve Jobs  |  Apple      | 
  1. Select the table
  2. Right click on it and Define named range...
  3. Give it a name: data
  4. Go to cell A20 and write there steve@apple.com
  5. Go to cell B20 and write =VLOOKUP(A20, data, 2, FALSE)
  6. Check what happened :)
  • I can give you more details if needed... :) – Lipis Jul 21 '10 at 19:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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