# Overwrite / update a row or cell in google sheets
**URL:** https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275
**Category:** Ask for Help
**Created:** [March 5, 2022, 11:14am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275 "2022-03-05T11:14:41Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@Rich\_Taylor](https://community.glideapps.com/u/Rich_Taylor)
#### Post date: [March 5, 2022, 11:14am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/1 "2022-03-05T11:14:41Z")
Hi all! I’m brand new to glide (and building no-code!).
I want to have a a box for a user to enter a search term and have this sent to google sheets.
I need sheets to overwrite each subsequent term sent by that user (or another) to be overwritten / updated in the same cell.
Is this possible and if so, how?
Thanks!!
Rich 🤓
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 5, 2022, 11:48am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/2 "2022-03-05T11:48:46Z")
> [@Rich\_Taylor](#):
>
> Is this possible and if so, how?
It’s possible by using the [Set Column Values](https://docs.glideapps.com/all/topics/actions/single-actions/data/set-columns) action.
But, I suspect that you might be approaching this the wrong way. Can you describe your use case in a little more detail? eg. once that value is written to the sheet, what is it used for?
---
### Author:  [@Rich\_Taylor](https://community.glideapps.com/u/Rich_Taylor)
#### Post date: [March 6, 2022, 2:57am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/3 "2022-03-06T02:57:11Z")
Thanks Darren! I want to use it with Parsehub to scrape data based on a users search term. I can have values in google sheets that can be changed and parsehub scrape but I don’t want a fixed set of values, I want whatever the user puts in. Hence only needing one line.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 6, 2022, 3:06am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/4 "2022-03-06T03:06:01Z")
Okay, so in the simplest form all you really need is a text input component that is targeted at the column in question. You just need to make sure you’re always writing to the same row. The easiest way to do this is probably to use a sheet/table that contains just a single row.
---
### Author:  [@Rich\_Taylor](https://community.glideapps.com/u/Rich_Taylor)
#### Post date: [March 6, 2022, 3:09am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/5 "2022-03-06T03:09:07Z")
This might help:
---
### Author:  [@Rich\_Taylor](https://community.glideapps.com/u/Rich_Taylor)
#### Post date: [March 6, 2022, 3:10am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/6 "2022-03-06T03:10:26Z")
OK, I’m brand new to this so will have a look now and see if I can do it 👍🏻
---
### Author:  [@Rich\_Taylor](https://community.glideapps.com/u/Rich_Taylor)
#### Post date: [March 6, 2022, 3:17am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/7 "2022-03-06T03:17:35Z")
I’m probably being super simple but I just deleted all the other rows in sheets but it keeps adding one for the new term.
I’ll hunt around in the glide settings
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 6, 2022, 3:19am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/8 "2022-03-06T03:19:22Z")
You are using a form. You don’t need to do that. Just set your tab to a details style layout, add a text entry component pointing to the correct column, and that should be it. As soon as you start typing, it will update the sheet.
---
### Author:  [@Rich\_Taylor](https://community.glideapps.com/u/Rich_Taylor)
#### Post date: [March 6, 2022, 3:26am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/9 "2022-03-06T03:26:27Z")
Jeff ya legend!! Thanks for that!! Such a simple fix. Where do I mail the beer?! 😂🍻
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 6, 2022, 3:50am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/10 "2022-03-06T03:50:15Z")
Mail it to @Darren_Murphy. He earned it. 😉
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 6, 2022, 4:06am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/11 "2022-03-06T04:06:29Z")
Did someone say _BEER_?? 🤪
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 6, 2022, 4:54am UTC](https://community.glideapps.com/t/overwrite-update-a-row-or-cell-in-google-sheets/39275/12 "2022-03-06T04:54:00Z")
