# Synchronization issues between google sheet and glideapps
**URL:** https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546
**Category:** Ask for Help
**Created:** [September 22, 2025, 9:33pm UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546 "2025-09-22T21:33:16Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Paolo\_Cesareo](https://community.glideapps.com/u/Paolo_Cesareo)
#### Post date: [September 22, 2025, 9:33pm UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/1 "2025-09-22T21:33:16Z")
I’m having several sync issues between google sheete and glideapps.
Introduction: I have a google sheet that is populated via a google form.
When I try to insert the data into the glide table both manually and using the appropriate form in the add row component it doesn’t synchronize, maybe I’m doing something wrong?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 22, 2025, 9:39pm UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/2 "2025-09-22T21:39:18Z")
Which plan do you have? Do you have a plan that supports google sheets sync? Is your table icon black or green.
---
### Author:  [@Paolo\_Cesareo](https://community.glideapps.com/u/Paolo_Cesareo)
#### Post date: [September 22, 2025, 10:27pm UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/3 "2025-09-22T22:27:52Z")
I have had the legacy starter plan for several years.
---
### Author:  [@Paolo\_Cesareo](https://community.glideapps.com/u/Paolo_Cesareo)
#### Post date: [September 22, 2025, 10:47pm UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/4 "2025-09-22T22:47:33Z")
I just discovered something by chance.
Synchronization from glide to googlesheet occurs but the data can be found on line 50115… 😱
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 22, 2025, 11:27pm UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/5 "2025-09-22T23:27:48Z")
Do you have any arrayformulas in your Google Sheet?
---
### Author:  [@Paolo\_Cesareo](https://community.glideapps.com/u/Paolo_Cesareo)
#### Post date: [September 23, 2025, 12:22am UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/6 "2025-09-23T00:22:22Z")
more than one…
is it a problem?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 23, 2025, 12:39am UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/7 "2025-09-23T00:39:29Z")
> [@Paolo\_Cesareo](#):
>
> is it a problem?
No, but you’ll want to make sure you delete any extra rows in every sheet. You also might want to modify the formula to account for blanks. I usually use
```css
={“Column”;IFERROR(ARRAYFORMULA(if(len(A2:A),TRUE,)))}
```
---
### Author:  [@Paolo\_Cesareo](https://community.glideapps.com/u/Paolo_Cesareo)
#### Post date: [September 24, 2025, 8:59am UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/8 "2025-09-24T08:59:40Z")
I deleted the thousands of lines, but in the afternoon, another 30,000 lines formed…very strange, what could it depend on?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 24, 2025, 9:23am UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/9 "2025-09-24T09:23:57Z")
Did you adjust your arrayformulas as Bob suggested?
---
### Author:  [@Paolo\_Cesareo](https://community.glideapps.com/u/Paolo_Cesareo)
#### Post date: [October 6, 2025, 11:27am UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/10 "2025-10-06T11:27:15Z")
Yes, in the end in addition to the arrey it depended on a formula that started from line 2 and created synchronization problems because it went one line further, something has settled down even if today 500 empty lines reappeared after two days
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 7, 2025, 12:19am UTC](https://community.glideapps.com/t/synchronization-issues-between-google-sheet-and-glideapps/84546/11 "2025-10-07T00:19:26Z")
What do you mean by “went one line further”? Can you show us the set of formula you’re using?