# User email capture in Google Sheets stopped at line 1000

**URL:** https://community.glideapps.com/t/user-email-capture-in-google-sheets-stopped-at-line-1000/35189
**Category:** Ask for Help
**Created:** [November 28, 2021, 1:02pm UTC](https://community.glideapps.com/t/user-email-capture-in-google-sheets-stopped-at-line-1000/35189 "2021-11-28T13:02:16Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Adriane\_Marie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriane_marie/32/26821_2.png) [@Adriane\_Marie](https://community.glideapps.com/u/Adriane_Marie)
#### Post date: [November 28, 2021, 1:02pm UTC](https://community.glideapps.com/t/user-email-capture-in-google-sheets-stopped-at-line-1000/35189/1 "2021-11-28T13:02:16Z")

</div>

User email address capture in Google Sheets stopped at line 1000.

I have a PRO account so this shouldn’t be a limitation.

How to fix?

Please help fast…I have an app promo coming out tomorrow! Terrible timing.

Thanks in advance!

\*New users can still enter their email addresses and access the app. No problems there. Just the emails don’t populate into the spreadsheet!

---

<div class="post-metadata">

### 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: [November 28, 2021, 1:58pm UTC](https://community.glideapps.com/t/user-email-capture-in-google-sheets-stopped-at-line-1000/35189/2 "2021-11-28T13:58:02Z")

</div>

That’s a bit odd. Are there any empty rows after row 1000, or does the spreadsheet end there?

---

<div class="post-metadata">

### Author: ![Adriane\_Marie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriane_marie/32/26821_2.png) [@Adriane\_Marie](https://community.glideapps.com/u/Adriane_Marie)
#### Post date: [November 28, 2021, 10:39pm UTC](https://community.glideapps.com/t/user-email-capture-in-google-sheets-stopped-at-line-1000/35189/3 "2021-11-28T22:39:01Z")

</div>

At first the spreadsheet ended there. Upon seeing that I added another 1000 rows but that was several days now and still nothing has populated. Refreshing did nothing. Any ideas?

---

<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: [November 28, 2021, 11:24pm UTC](https://community.glideapps.com/t/user-email-capture-in-google-sheets-stopped-at-line-1000/35189/4 "2021-11-28T23:24:45Z")

</div>

Might be obvious, but have you checked with a completely new email? If yes, that does not produce a new line?

---

<div class="post-metadata">

### 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: [November 29, 2021, 1:17am UTC](https://community.glideapps.com/t/user-email-capture-in-google-sheets-stopped-at-line-1000/35189/5 "2021-11-29T01:17:58Z")

</div>

> [@Adriane\_Marie](#):
>
> At first the spreadsheet ended there. Upon seeing that I added another 1000 rows but that was several days now and still nothing has populated. Refreshing did nothing. Any ideas?

Adding extra rows isn’t necessary, new rows are added automatically as they are needed.  
I was asking because sometimes you might find large numbers of empty rows in a Google Sheet and new rows are being added way down at the bottom. That often happens when you have arrayformulas that aren’t set up correctly.

Just to be clear - the sheet in question is the one that’s used for your User Profiles, yes? (_not_ `App: Logins`)