If it involves numbers, there’s a good chance I’ve already opened Excel and used one of these features for it.
Here's how to create a heat map in Google Sheets. This is the easiest method, which is the conditional formatting feature.