# User input into Google Sheets? **URL:** \ **Category:** Ask for Help\ **Created:** [February 6, 2023, 9:41am UTC](https://community.glideapps.com/t/user-input-into-google-sheets/57558 "2023-02-06T09:41:25Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 6, 2023, 9:41am UTC](https://community.glideapps.com/t/user-input-into-google-sheets/57558/1 "2023-02-06T09:41:25Z")
I have synced Glide and Google sheets and when I input data onto Glide input which is connected to a Google Sheet, the data show in Glide but not in actual Google Sheets But when I input on my Google sheet, the data correctly show up in Glide. Is it possible to input data onto Google sheets when they submit a form in Glide? ---
**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:** [February 6, 2023, 9:43am UTC](https://community.glideapps.com/t/user-input-into-google-sheets/57558/3 "2023-02-06T09:43:54Z")
Do you have any empty rows at the bottom of your Google Sheet? If you do, scroll all the way to the bottom and check if there is anything there. ---
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 6, 2023, 9:54am UTC](https://community.glideapps.com/t/user-input-into-google-sheets/57558/5 "2023-02-06T09:54:53Z")
Oh… I have set formulas in the empty cells all the way down to 1000th row, how can I make the user input into the next row instead of 1001th row? User inputs will be only in Column A-E and the rest is filled with formulas. ---
**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:** [February 6, 2023, 10:06am UTC](https://community.glideapps.com/t/user-input-into-google-sheets/57558/6 "2023-02-06T10:06:57Z")
Yes, if you have formulas in your spreadsheet, Glide will see those rows as not empty and will add new rows at the bottom. There are a few ways to deal with this. - Option 1: Convert your formulas to arrayformulas and delete all empty rows. - Option 2: Get rid of your spreadsheet formulas altogether and replace them with Glide computed columns. Option 2 is generally the better option, but it depends on the nature of the formulas and whether you actually need the calculated results in the Google Sheet. ---
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 6, 2023, 10:07am UTC](https://community.glideapps.com/t/user-input-into-google-sheets/57558/7 "2023-02-06T10:07:46Z")
Thank you for the answer. I think I will first try to copy the same functions in Glide as well to see if I can ---
**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:** [February 6, 2023, 10:09am UTC](https://community.glideapps.com/t/user-input-into-google-sheets/57558/8 "2023-02-06T10:09:54Z")
> [@rezmeplx](#): > > I think I will first try to copy the same functions in Glide as well to see if I can If you have trouble with that, feel free to ask for help. Many of us are quite experienced with this topic. ---
**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:** [February 7, 2023, 10:10am UTC](https://community.glideapps.com/t/user-input-into-google-sheets/57558/9 "2023-02-07T10:10:00Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.