How can I get Smartsheet to populate the profile image from someone's email address?

Options

What I would like to accomplish is this:

Column A: I have a list of valid email addresses.

Column B: I would like to have the contact's profile picture populate based on the valid email address.

Ultimately, I will have this converted to card view so that all of my prospect's information can be shown via the card view. If they don't have a profile pick for their outlook or Gmail account, I understand that it may be blank which is fine.

TIA

Answers