# Add row in googlesheet with the app **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [December 10, 2022, 12:51pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625 "2022-12-10T12:51:34Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Rodney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rodney/32/51452_2.png) [@Rodney](https://community.glideapps.com/u/Rodney)\ **Post date:** [December 10, 2022, 12:51pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625/1 "2022-12-10T12:51:34Z")
Hi, I work with a googlesheet. i have a page called ‘Tracke’ which is a list in the app In the ‘header’ of this list, I have a ‘+’ buttom. When i click on it, I can fill in a form, click on OK and a new row is add on my app… on the glide sheet but not in googlesheet (my reel database). If i modify an existing element in the list, it modify my googlsheet, but when I add row, no… Is it possible to add row in googlesheet directly when I had row in app ? Thank you Rod ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 10, 2022, 12:54pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625/2 "2022-12-10T12:54:01Z")
Do you have any empty rows at the bottom of your Google Spreadsheet? If you do, check all the way at the bottom. ---
**Author:** ![Rodney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rodney/32/51452_2.png) [@Rodney](https://community.glideapps.com/u/Rodney)\ **Post date:** [December 10, 2022, 12:55pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625/3 "2022-12-10T12:55:31Z")
Yes i have some row without information… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 10, 2022, 1:03pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625/4 "2022-12-10T13:03:31Z")
Did you find any extra rows (added by Glide) at the bottom of your sheet? It’s always best to delete empty rows at the bottom of your Google Sheets. Especially if you use arrayformulas. Glide will always add new rows in the first empty row that it finds. If there are “empty” rows that contain formulas, Glide will skip over them and add a new row at the bottom. ---
**Author:** ![Rodney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rodney/32/51452_2.png) [@Rodney](https://community.glideapps.com/u/Rodney)\ **Post date:** [December 10, 2022, 1:12pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625/5 "2022-12-10T13:12:17Z")
Ok, you’re right, a new row is at the bottom, I didn’t see. So, is there a way to add row in empty rows with formulas ? Thank you ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 10, 2022, 1:18pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625/6 "2022-12-10T13:18:39Z")
> [@Rodney](#): > > So, is there a way to add row in empty rows with formulas ? No, Glide will see those as non-empty and will add new rows below. Are these formulas that you copy/paste down as new rows are added? If they are, you would be better off replacing them with arrayformulas. See below for more on that: > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/): > > Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. > > > **1/ Definition** > > > > Arrayformula is defined as “a range, mathematical expression using one cell range … Even better would be to get rid of formulas in your Google Spreadsheet altogether, and do all calculations in Glide using computed columns. Whether or not that is the best idea depends on the purpose and use of your App. ---
**Author:** ![Rodney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rodney/32/51452_2.png) [@Rodney](https://community.glideapps.com/u/Rodney)\ **Post date:** [December 10, 2022, 1:20pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625/7 "2022-12-10T13:20:38Z")
All right, I will see that! Thank you very much for your help ! ---
**Author:** ![Rodney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rodney/32/51452_2.png) [@Rodney](https://community.glideapps.com/u/Rodney)\ **Post date:** [December 10, 2022, 7:13pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625/8 "2022-12-10T19:13:25Z")
It woooooooorks !!! Very happy to earn something usefull !!! Thank you so much All the best ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 11, 2022, 7:14pm UTC](https://community.glideapps.com/t/add-row-in-googlesheet-with-the-app/55625/9 "2022-12-11T19:14:19Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.