# How to Create Conditional Format Automation Between Coda and Google Sheets

> To create conditional format automation between Coda and Google Sheets, open the table settings in your Coda doc, select Table Options, and click Conditional Format. Next, add a rule, choose the main element, and configure the associated settings to change the format of the Google Sheet table.

Canonical: https://livedemo.ai/tutorials/how-to-create-conditional-format-automation-between-coda-and-google-sheets/
Apps: Google, Coda
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3943ab56e05a00fdf986/preview?step=1

## Steps

1. Inside your Coda doc, head over to the Google Sheets table and click the drop-down arrow next to the 'Refresh' button.
2. Select 'Settings' from the available choices.
3. After that, navigate to the right-side panel and click 'Table Options'.
4. Find and select 'Conditional Format' to proceed.
5. Subsequently, click 'Add Rule'.
6. Choose the main element of the rule you want to implement.
7. Following that, configure the associated settings according to your liking.
8. After completing these steps, the format of the Google Sheet table in your Coda doc will be changed based on your conditional format automation.