About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

How do I add a new row below the header?

  • 2 January 2022
  • 2 replies
  • 314 views
E

Im could add order info into Google spread sheet from Shopify.

But when I get new order, it will be added on the top of the work sheet which is supposed to be added at below of the header.

I've tried fixing the rows and protecting the header section, but it still gets added on top of the worksheet.

Does anyone know of a solution to this problem?

 

Thanks in advance.

icon

Best answer by SamB 2 March 2022, 11:30

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

2 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Eddie 

Please review the help article for How to set up your Google spreadsheet to work with Zapier: https://zapier.com/help/doc/how-to-set-up-your-google-spreadsheet-to-work-with-zapier

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
SamB
Rank
Userlevel 7
Badge +11

Hey everyone! I just wanted to follow up here as spotted that @Eddie also reached out to our Support Team about this. I’ll share part of their response here in case it’s helpful to anyone that’s also running into similar issues:

“When you created your headers, did you have any values present in Cell A1? If that cell is empty, that could be why the rows are being added to the top of the sheet rather than the bottom. 
 
Could you confirm if that's the case? If so, you'll want to turn off your Zap and reconfigure your header to begin on cell A1. Then, you can turn your Zap back on and submit a test order in Shopify to confirm that new rows are being added to the bottom of the sheet. ”

For more details on how to set up a your Google Sheets spreadsheet to work with Zapier you’ll want to check out the following guide: Work with Google Sheets in Zaps :relaxed:

Terms & Conditions