Skip to main content
Question

How do I conditionally format text field being populated using Google Sheet plugin?

  • July 15, 2025
  • 1 reply
  • 8 views

LOkwu

Hi all. I’m new to Figma and currently working on a project where I’m generating cards using text pulled from a Google Sheet via a plugin like Google Sheets Sync.

The sync is working fine. Each card is receiving the correct text from the sheet. However, I’d like to go a step further and apply specific font colors to certain words or patterns within the text.



Here is the data in sheets:

 

Here’s a screenshot of the cards in Figma:
 

The 2 cards in the frame are populating with the text correctly. However I would like the font to have certain colors based on certain keywords. For example,

  • In Line 1: “Some” and “line” should be red, everything else in line 1 should be white. 
  • In Line 2: “Some” should be red, anything text in bracket should be orange, etc.
     

My Questions:

  • Is this type of partial, inline text formatting (color changes) possible when using data from Google Sheets?
  • Are there any beginner-friendly tips or best practices to achieve this?

I’m hoping to avoid having to manually change the colors of individual words in each card.

Thanks in advance!



Thanks.  

Ellwood
  • Active Member
  • July 15, 2025

Hi ​@LOkwu ,

 

I’ve been using the google sheets plugin for a while and to the best of my knowledge, there’s no way to conditionally format portions of text within a single imported data field.

You could cut up the string into different data cells to target a specific ordering (ie first word) depending how you cut up the string (could be a lot of manual work to manipulate the data especially if using a large data set), and create an autolayout to bring the sentence together. This way you could style words given a specific order in the sentence, but still, this doesn’t allow you to essentially ‘search’ for specific words or patterns of words to style differently.

Hope that helps.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings