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

Add rows to TOP of Google Sheet

  • 29 September 2022
  • 6 replies
  • 1004 views
C
Userlevel 2

Checking if this capability was recently added. as the last post on this topic was a year ago

Add a new row to top of Google Sheets instead of the bottom | Zapier Community

icon

Best answer by Danvers 29 September 2022, 15:43

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

6 replies

Danvers
Userlevel 7
Badge +12

Hi @cb2022, thanks for your question!

It’s not possible to add a row to the top of a sheet in Google Sheets using Zapier. 

We do have a feature request for this and I've added your vote for this addition. I don't have an ETA of when or if this will happen, but we will definitely email you if it does become a reality. In the meantime, did either of the suggestions in the post that you linked to help? Thanks!

C
Userlevel 2

Thanks. No,the suggestions in the other post wont work for me

MohSwellam
Userlevel 7
Badge +8

Hi @cb2022 

 

Although its not possible to add the row to the top but you can actually do that if you add a Created Date / Time field which you send from Zapier and set the view to be sorted in Google Sheets using this field 

Founder of GeekyAir.com
jesse
Userlevel 7
Badge +9

Great suggestion/workaround, @MohSwellam!

C
Userlevel 2

Thank you! I actually have an entry date already from Gravity Forms and it works! Now Im trying to get it to auto sort so that team members will find the new entries automatically at the top when they open the sheet.

 I used this script from https://gist.github.com/mikebranski/285b60aa5ec3da8638e5?permalink_comment_id=4053245#gistcomment-4053245.

The script worked like a charm on a sample sheet but I’m getting an error on my live sheet

 

Error:Merges must be entirely within the sort range.

I don't have any merged cells so no idea what this is about. Will have to work on it some more.

MohSwellam
Userlevel 7
Badge +8

Hi @cb2022 

 

Glad it worked as expected :) ! 
 

Using google search I can see there are multiple ways to do such auto sorting (including the SORT function) https://sheetsformarketers.com/how-to-auto-sort-in-google-sheets/

 

Would appreciate if you mark the reply as answer so others can use it in the future 

Founder of GeekyAir.com
Terms & Conditions