# Problems to connect with the google sheet file source (not resolved)

**URL:** https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736
**Category:** Ask for Help
**Created:** [January 26, 2022, 5:25pm UTC](https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736 "2022-01-26T17:25:39Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Falco\_Pilgrim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/falco_pilgrim/32/39502_2.png) [@Falco\_Pilgrim](https://community.glideapps.com/u/Falco_Pilgrim)
#### Post date: [January 26, 2022, 5:25pm UTC](https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736/1 "2022-01-26T17:25:40Z")

</div>

the other topic was close but no resolve I was trying:

" [SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)Support Team & Certified Expert.: Has intentado hacer una copia de la Gsheets, y reemplazarla en Glide.? Una vez que hagas la copia vas a settings \> data \> replace Por lo general eso ayuda con cualquier problema que puedas tener"

Result:

### Oh sheet!

Something went wrong replacing the spreadsheet."

“[Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem) :you try duplicating the app and sheet? If the problem still persists you should submit a ticket.”  
but don’t have good result the system say:

"An error occurred duplicating the app.

most cases this is caused by a large and/or complex Google sheet. Delete all rows and columns that your app is not using or there is no data. Glide will append rows as needed so you can remove all empty rows below the existing data on all of your sheets. Then try to duplicate the app again."

Please I have 3 days with this problem

Hello good morning

I have the same problem as the first time, but now worse, the page where I have the profiles or the data does not load for three days, I did everything, try not to open from another browser, private mode, clean the cache of the 3 browsers, force the update I have made many changes in the source file while I was waiting for it to update but it does not happen, the file is still unchanged and giving an error when I update it.

Please if you can help me. thank you buenos dias

Tengo el mismo problema que la primera vez, pero ahora peor, no me carga la hooja donde tengo los perfiles ni la data desde hace tres dias, hice de todo intentadno abrir desde otro navegador, private mode, limpiar el cache de los 3 navegadores, forzar la actualizacion he hechos muchos cambios en el archivo fuente mientras esperaba que actualizara pero no sucede, el archivo sigue estando sin modificaciones y dando error cuando le doy actualizar.

Por favor si me pueden ayudar. muchas gracias

---

<div class="post-metadata">

### Author: ![Falco\_Pilgrim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/falco_pilgrim/32/39502_2.png) [@Falco\_Pilgrim](https://community.glideapps.com/u/Falco_Pilgrim)
#### Post date: [January 26, 2022, 7:34pm UTC](https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736/2 "2022-01-26T19:34:09Z")

</div>

hello somebody to help ? what can i do? please i have a lot time spend in this project, Can i receive help from support?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 26, 2022, 9:02pm UTC](https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736/3 "2022-01-26T21:02:57Z")

</div>

Have you submitted a ticket to support?

[https://glide-help.zendesk.com/hc/en-us/requests/new](https://glide-help.zendesk.com/hc/en-us/requests/new)

---

<div class="post-metadata">

### Author: ![Falco\_Pilgrim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/falco_pilgrim/32/39502_2.png) [@Falco\_Pilgrim](https://community.glideapps.com/u/Falco_Pilgrim)
#### Post date: [January 26, 2022, 9:54pm UTC](https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736/4 "2022-01-26T21:54:13Z")

</div>

no yet but I going to do it. thanks Jeff, you’re always there

---

<div class="post-metadata">

### Author: ![Falco\_Pilgrim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/falco_pilgrim/32/39502_2.png) [@Falco\_Pilgrim](https://community.glideapps.com/u/Falco_Pilgrim)
#### Post date: [January 27, 2022, 1:03am UTC](https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736/5 "2022-01-27T01:03:21Z")

</div>

nothing jet. Some body with this issue please

---

<div class="post-metadata">

### Author: ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [January 27, 2022, 1:12am UTC](https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736/6 "2022-01-27T01:12:39Z")

</div>

Please, check your email!

---

<div class="post-metadata">

### Author: ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [January 27, 2022, 2:40pm UTC](https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736/11 "2022-01-27T14:40:18Z")

</div>

Hola Carlos!

Tu enviaste un ticket. Por fa, revisa tu correo ya que te hemos enviado información que te ayudará a solucionar el problema.

---

<div class="post-metadata">

### Author: ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [January 27, 2022, 3:18pm UTC](https://community.glideapps.com/t/problems-to-connect-with-the-google-sheet-file-source-not-resolved/37736/13 "2022-01-27T15:18:16Z")

</div>

Aquí tienes varias manera de pasar tus 45k+ filas a Glide Table

> [@robot Importing data to Glide by use of robot (RPA)](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008):
>
> Challenge 1 In this moment of time it is not possible to import data (or paste chunks of data) into Glide. @Manu.n has shown a way to import a row at a time from Google sheets to Glide tables which is quite handy if you have not to much data to import. But if you have hundreds or thousands of rows this approach is not the way to go. 
> 
> > **Manu.n's approach - great for a smaller number of rows**
> >
> > \<a href="https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/…

> [@\[SOLVED white\_check\_mark\] I want to create a Webhook that adds a row to a Glide Table (for fun grin)](https://community.glideapps.com/t/solved-i-want-to-create-a-webhook-that-adds-a-row-to-a-glide-table-for-fun/32477/4):
>
> Hola… good point! As far I know, the Glide’s backend is built on Firebase/Firestore so, the Glide Tables are Firebase tables indirectly. Anyone can access Firebase databases via API using a Key but we depend on Glide’s rules, restrictions and security reasons to get that API Key. This post created by @Zancoper time ago shows how to connect a Firebase database and put its data into a Google Sheet in an “easy way”: [Import data from Firebase to Glide](https://community.glideapps.com/t/import-data-from-firebase-to-glide/26230) , Saludos!

> [@Import Data From Excel & Sheets into Glide Table](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/18):
>
> Hello, Failing to have an import function. I used a fairly simple method to import 3 tables of around 400 rows each, it’s not ideal, but it’s better than editing everything. For simplicity You have a Sheet Source table and a Glide Destination table. Add a column to your Sheet Source “Copy ok” of type boolean. Create a List style tab with the Sheet Source as the source. And as filter “Copy ok is not 1” Then use a custom action ADD row, with as Sheet “Glide Destination” then mat…
