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.

My sheet has headers in row 1 and data filled through row 5. I’m using Zapier’s Create Spreadsheet Row to add new replies, but each new entry keeps landing in row 2. I want each new reply to go into row 6, then row 7, and so on. How can I force Zapier to append below row 5 instead of overwriting row 2?

Hi ​@Nikinzap 

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/integrations#help 

  • Make sure cell A1 has a value.
  • Make sure there are no hidden rows/columns.
  • Make sure there are no grouped rows/columns.

Hello ​@Troy Tessalone, Thanks for replying!

My first row (A) has column names and A1 cell has Serial number as value. 
And the table has:
no hidden rows/columns and
no grouped rows/columns 

Hi ​@Nikinzap,

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please share a screenshot of the Google Sheet action step in the CONFIGURE section that shows all of its fields.

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!

​@Nikinzap 

Also, include screenshots showing the top 3 rows of your GSheet.

​@ken.a, ​@Troy Tessalone 

sure, 
Screenshot of the workflow:


Screenshot of google sheet configure section:
 

 


Screenshot of the first 3 rows of my google sheet:

 

 

​@Nikinzap 

Try adding a value to the first column in the Zap step config.

 

Hi ​@Nikinzap,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Terms & Conditions