Skip to main content
Question

Issue with Auto-Filled Cell Formatting in Google Sheets

  • March 11, 2025
  • 1 reply
  • 11 views

I am collecting registrations from a Webflow form and "zapping" them to a Google Spreadsheet. I have a column called "Paid", where I manually change the fill color to green if the customer has paid.

However, when a new registration is submitted, the newly added row is automatically inheriting the green fill color from the previous row instead of having no styling. Is there a way to prevent new rows from inheriting the formatting while still allowing me to manually highlight paid entries?

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

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34081 replies
  • March 11, 2025

Hi ​@emjcreative 

New rows added to a GSheet inherit the above row styling.

 

I recommend using Airtable instead of GSheets.

Airtable has specific field types to use. (e.g. dropdown list with colored options)

https://zapier.com/apps/airtable/integrations#triggers-and-actions