If you have a lot of zones in your layout that require e.g. styling, but you (or your collaborators) typically only need to see and edit the actual zone contents (and not their styling), then you may want to create two separate worksheets in g Sheets:
A worksheet that you (or e.g. collaborators) edit and that has zones' contents;
A worksheet that pulls in the data from the first worksheet and additionally contains style columns (see The Style Column ), potentially using automation via formulas. This is the one you link to from Dextrous (see Google Sheets ).
In worksheet 2, you can pull in data from an entire cell range in worksheet 1 like this:
=INDIRECT("MyWorksheet1!A1:F100")
(This formula goes in a single cell in worksheet 2, e.g. the top left cell, and expands the data to the full cell range.)
Then, you can simply add additional columns in worksheet 2 that take care of styling, e.g. based on the contents of the other columns you're pulling in.
Filtering Rows
You can even filter which rows (cards) you pull in from the first worksheet, using any criterion. For example, you could have a "Finalized" column in worksheet 1 (say, column G) and only pull in rows that contain "Yes" in that column: