How to use Google fonts?
- 1.
- 2.Copy the name from the font as highlighted below.

3. Now add the name in any of the font cells in the Google sheet as below. Just copy from Step 2 and paste the name in Google sheet.

Google fonts can be used in all the places where the Font option is available in Google sheets.