How do I apply conditional formatting to distinguish orders by color in Google Sheets when importing from Shopify?

Question

Hey,I’m pulling all of my orders from Shopify to a google sheet, and as the orders comes in it breaks down to line items so every order have several lines, how can i colorize the cells to distinguish between orders? Like have another background color for the rows - for example -->{ID}			#10-1234			 			 			1x White Shirt		{ID}						#10-1234						 			 						1x Blue Pants					{ID}			#10-1235			 			 			1x White Shirt		{ID}			#10-1236			 			 						1x Gray Pants

SamB · Accepted Answer

Hey all, just circling back in to share that the feature request has been implemented! 🎉

A Format Spreadsheet Row action has been added to allow you to update the background color as well as other formatting settings for a spreadsheet row:

Thanks for your patience, we’re excited for you to give this a try! And if you run into any issues with it, feel free to start a new topic or contact our Support team directly and we’ll be glad to assist.

In the meantime, happy Zapping! ⚡

SamB · Answer

Hi @Elad_Tan, welcome to the Community!Ah, I did some checking and it looks like the Google Sheets app isn’t currently able to set the background color of cells in a row. There’s an existing feature request open for this though so I’ve added your vote to that. I don’t have any ETA on when that might become possible but we’ll be sure to email you as soon as it is.In the meantime, I wonder if you could use conditional formatting within Google Sheets to set the alternating colors?

{ID}	#10-1234	1x White Shirt
{ID}	#10-1234	1x Blue Pants
{ID}	#10-1235	1x White Shirt
{ID}	#10-1236	1x Gray Pants

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded