Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I’m trying to create a simple zap that uses the Create Spreadsheet Row function with Google Sheets.

The Google Sheet has a header:

 

The Status column has the following options:

 

 

When the sheet has no entries, and the zap triggers, two things will often happen:

  • The Status value will be set but will wipe out the dropdown option and just make it plain text
  • The formatting of the first row, and subsequent rows will be bold, like the header

  •  

 

If the sheet has data in the first row (at least) already, the zap appears to write the with the proper format and the dropdown isn’t wiped out

  •  

 

Any insight to what’s happening here? Why would the second row in the sheet, after the header have these formatting issues?

Hi @Gkontos89 

The Zap action GSheets Create Row adds a new row to the GSheet, it does not fill in an existing empty row.

e.g. If the GSheet has 10 rows, and the Zap Runs to create a row, the GSheet will then have 11 rows.

The GSheet Create Row will not keep the existing formatting when creating a new row.

 

You would have to find an empty row via a lookup column, then update an existing row.

 

An alternative would be to use Airtable instead of GSheets.

Airtable has distinct field types: https://support.airtable.com/docs/supported-field-types-in-airtable-overview

“The GSheet Create Row will not keep the existing formatting when creating a new row.”
 

This statement doesn’t make sense to me. Because If there’s existing rows below the header, the Create Row function does keep the formatting. You can see this in my second set of pictures. The drop-down value is properly set and the color is kept.

 

its only when the only row filled out is the header, and Create Row is used, that the second row is bold type and the drop-down value in the Status column doesn’t keep its formatting.

@Gkontos89 

Then try to set a row 2 in the GSheet worksheet with dummy data so the desired column cell formatting is inherited when GSheets creates a new row.

Reply


Terms & Conditions