Google Fonts integration in Figma - Cell-by-Cell Formula Trace

Sample Data

This table lists font names and their Google Fonts URLs used for integration in Figma design projects.

Cell	Value
A1	Font Name
B1	Font URL
A2	Roboto
B2	https://fonts.googleapis.com/css2?family=Roboto&display=swap
A3	Open Sans
B3	https://fonts.googleapis.com/css2?family=Open+Sans&display=swap
A4	Lato
B4	https://fonts.googleapis.com/css2?family=Lato&display=swap

Formula Trace

IMPORTFONT(B2)

Step 1: IMPORTFONT("https://fonts.googleapis.com/css2?family=Roboto&display=swap")

Cell Reference Map

    A           B
1 | Font Name | Font URL                             |
2 | Roboto    | https://fonts.googleapis.com/css2?family=Roboto&display=swap |
3 | Open Sans | https://fonts.googleapis.com/css2?family=Open+Sans&display=swap |
4 | Lato      | https://fonts.googleapis.com/css2?family=Lato&display=swap |

The formula references cell B2 which contains the Google Fonts URL for Roboto font.

Result

    A           B                          C
1 | Font Name | Font URL                   | Imported Font
2 | Roboto    | https://fonts.googleapis.com/css2?family=Roboto&display=swap | Roboto
3 | Open Sans | https://fonts.googleapis.com/css2?family=Open+Sans&display=swap | 
4 | Lato      | https://fonts.googleapis.com/css2?family=Lato&display=swap | 

The imported font 'Roboto' appears in column C after applying the IMPORTFONT function to the URL in B2.

Sheet Trace Quiz - 3 Questions

What does the IMPORTFONT function do with the URL in cell B2?

A Changes the font name to Roboto

B Loads the Roboto font into the project

C Deletes the font URL

D Exports the font to a file

Key Result

IMPORTFONT loads a Google Fonts URL to import the specified font into the design project.