# 'Synced' Google Sheet Not Overwriting Data

**URL:** https://community.glideapps.com/t/synced-google-sheet-not-overwriting-data/73980
**Category:** Ask for Help
**Created:** [June 8, 2024, 12:18pm UTC](https://community.glideapps.com/t/synced-google-sheet-not-overwriting-data/73980 "2024-06-08T12:18:17Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Shayan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shayan/32/60726_2.png) [@Shayan](https://community.glideapps.com/u/Shayan)
#### Post date: [June 8, 2024, 12:18pm UTC](https://community.glideapps.com/t/synced-google-sheet-not-overwriting-data/73980/1 "2024-06-08T12:18:17Z")

</div>

I’ve just done this:  
=IMPORTRANGE(“[https://docs.google.com/spreadsheets/d/1K6ep9KgCgaXR3lMckIxB\_sl8MSr1\_dEzd3PWyEJqQ\_8/edit?gid=0#gid=0](https://docs.google.com/spreadsheets/d/1K6ep9KgCgaXR3lMckIxB_sl8MSr1_dEzd3PWyEJqQ_8/edit?gid=0#gid=0)”, “Outreach!A1:L657”)

And the L657 is the point I’ve written up to, but the data doesn’t sync. This is the error that comes up:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/583e50a80c8040491da7e91ff73680c405dfb5fc.png)

How can I be able to add data on the new sheet, and it syncs with the original?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 8, 2024, 1:40pm UTC](https://community.glideapps.com/t/synced-google-sheet-not-overwriting-data/73980/2 "2024-06-08T13:40:28Z")

</div>

You are having a value in cell A3 (321312 in the screenshot), just clear that and the data should sync.

Though, you should have your first row as static header, and import only from row 2 onwards for best syncing performance.

---

<div class="post-metadata">

### Author: ![Shayan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shayan/32/60726_2.png) [@Shayan](https://community.glideapps.com/u/Shayan)
#### Post date: [June 8, 2024, 1:53pm UTC](https://community.glideapps.com/t/synced-google-sheet-not-overwriting-data/73980/3 "2024-06-08T13:53:53Z")

</div>

Ah ok, but isn’t there a way for me to write data in that sheet, AND it changes it in the original?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 8, 2024, 2:00pm UTC](https://community.glideapps.com/t/synced-google-sheet-not-overwriting-data/73980/4 "2024-06-08T14:00:31Z")

</div>

No, there isn’t. You can think of that as a read-only mirror of your original sheet.