@Amanda-A Yes this is possible. You have to use expressions though when it comes to altering the color values in a shape layer. Take a read through this article to learn more about using data in expressions with Templater, and then also take a look at this pre-rigged template on our GitHub repository demonstrating the use of data in expression — also in the context of color manipulation. Hope this helps!

—Arie

@rivalpro

The way to avoid the issue is to use a # before all hex values in spreadsheet data. This shouldn’t happen with JSON data, as it is a quirk of how spreadsheet software (including Google Sheets) attempts to detect the data type in a cell and set the formatting. Using # will override the Sheet from setting incorrect formatting while the Bot is processing its data. While the Bot is running, the Sheet will think that you are changing data, and will try to automatically format all-numerical hex values as numbers unless they use the #.