Best answer

How do I convert Google Sheets number in cell to text

  • 29 September 2021
  • 3 replies

Userlevel 1

Hi, I have rows in a Google Worksheet being created and populated from a webform. One of the columns populates as a number, i.e. 3 or 6 for example. I need the numeric value for another Zapier friendly app to utilize. For my Zap workflow however I want to populate a custom field in a 3rd party Zapier friendly app. Not as a numeric value but a text field where say 3 = Bronze and 6 = Gold. 

I was looking for a router function where IF cell = 3 then Bronze and IF cell = 6 then Gold. I would then grab the output value and populate the field in the 3rd part app further down the workflow with a text field.


Any ideas?


Best answer by Troy Tessalone 29 September 2021, 01:27

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

Hi @troyc 

Try using a Formatter > Utilities > Lookup Table step in the Zap:

Userlevel 7
Badge +14


Similarly in GSheets you can use these formula functions:




Userlevel 1

Thank you for your response. Works a treat!