display external data as a dashboard

display external data as a dashboard

Currently, I have sales target for all of my sales team in their own google sheets page (1 page per person). I would like to either have this data show up on the crm (visible only to them) or be able to pull it up via web tab(?) or ideally, show up as a dashboard.

Is there a way to accomplish this?