# Data not visible in glide, even after being present in google sheet **URL:** \ **Category:** Ask for Help\ **Created:** [June 10, 2023, 1:05pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629 "2023-06-10T13:05:24Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Dotstory\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dotstory_admin/32/46941_2.png) [@Dotstory\_Admin](https://community.glideapps.com/u/Dotstory_Admin)\ **Post date:** [June 10, 2023, 1:05pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/1 "2023-06-10T13:05:24Z")
Hi, Data is present in google Sheets but its showing in glide, even after syncing thrice ![Screenshot 2023-06-10 at 18.31.52](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a33ee2368438c632d5a1568eb386ed43b05dcab6.jpeg) . Other sheets are visible but not this one. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 10, 2023, 1:10pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/2 "2023-06-10T13:10:16Z")
By chance is it at the bottom of the Glide table if you scroll down? Are you using any formulas in your ‘Bookings’ sheet like import range or array formula? ---
**Author:** ![Dotstory\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dotstory_admin/32/46941_2.png) [@Dotstory\_Admin](https://community.glideapps.com/u/Dotstory_Admin)\ **Post date:** [June 10, 2023, 1:13pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/3 "2023-06-10T13:13:18Z")
Its not even in the bottom. We do have formula. But this apps is been in used since a week no issues were there. We have another csutomer app using the same sheet and its working flowlessly ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 10, 2023, 1:15pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/4 "2023-06-10T13:15:43Z")
Well if that formula is an importrange make sure to start it on row 2. If importrange is in the header row there are some edge cases where data will not display. My other suggestion would be to clear any and all Glide related cookies. ---
**Author:** ![Dotstory\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dotstory_admin/32/46941_2.png) [@Dotstory\_Admin](https://community.glideapps.com/u/Dotstory_Admin)\ **Post date:** [June 10, 2023, 1:16pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/5 "2023-06-10T13:16:44Z")
The formula is already there in the second row. Just cleared the brower chache issue is still there. We dont have support in our starter plan ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 10, 2023, 1:20pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/6 "2023-06-10T13:20:26Z")
Ok that does sound odd. Just to be clear is that formula an importrange? Could you attach a screenshot of the ‘Bookings’ tab from GSheet and select the cell with your formula ---
**Author:** ![Dotstory\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dotstory_admin/32/46941_2.png) [@Dotstory\_Admin](https://community.glideapps.com/u/Dotstory_Admin)\ **Post date:** [June 10, 2023, 1:22pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/7 "2023-06-10T13:22:38Z")
Yeah the formula is import range. ![Screenshot 2023-06-10 at 18.51.21](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/caf536365077593d91d9c3610bb33c26b2228800.jpeg) ---
**Author:** ![Dotstory\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dotstory_admin/32/46941_2.png) [@Dotstory\_Admin](https://community.glideapps.com/u/Dotstory_Admin)\ **Post date:** [June 10, 2023, 1:23pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/8 "2023-06-10T13:23:06Z")
Shared ^ ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 10, 2023, 1:31pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/9 "2023-06-10T13:31:03Z")
Thanks for the share. Sorry if this is a silly question but you are not using any additional import ranges for the headers correct? Your headers are static yes? From what I can tell it looks correct and should work. One other thing I’ve tried is to change the data source to a copy of the original sheet… but it was for different issue. If you try that be sure to duplicate your app first. ---
**Author:** ![Dotstory\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dotstory_admin/32/46941_2.png) [@Dotstory\_Admin](https://community.glideapps.com/u/Dotstory_Admin)\ **Post date:** [June 10, 2023, 1:36pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/11 "2023-06-10T13:36:14Z")
> [@Dotstory\_Admin](#): > > Thanks for reply. Yes the headers are static. We have another which is running on the same sheet and the data are visible there. Only this app has the problem. Will the support help ? Thanks for reply. Yes the headers are static. We have another which is running on the same sheet and the data are visible there. Only this app has the problem. Will the support help ? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 10, 2023, 1:37pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/12 "2023-06-10T13:37:45Z")
I believe official support is only available for PRO plans or higher. As you know there are many experts on here willing to help… let’s see what others might have to say. ---
**Author:** ![Dotstory\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dotstory_admin/32/46941_2.png) [@Dotstory\_Admin](https://community.glideapps.com/u/Dotstory_Admin)\ **Post date:** [June 10, 2023, 4:48pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/13 "2023-06-10T16:48:40Z")
Yeah Will be waiting for them, Thanks for your time and responses ---
**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 10, 2023, 11:26pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/14 "2023-06-10T23:26:15Z")
In cases like this, maybe a script that periodically takes the data from Sheet A to move it to Sheet B might be a better choice. What do you think? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 10, 2023, 11:50pm UTC](https://community.glideapps.com/t/data-not-visible-in-glide-even-after-being-present-in-google-sheet/62629/15 "2023-06-10T23:50:15Z")
Well you might be right. I don’t find myself using importrange anymore… at least not in ways that are connected to Glide. If it helps I do have a good script for moving rows periodically credit @Darren_Murphy > **Summary** > > ```auto > function copy_new_rows_to_database() { > console.time('Archive'); > // Open the source sheet and read all data into an array > var ss = SpreadsheetApp.getActiveSpreadsheet(); > var sourcesheet = ss.getSheetByName('YOUR SOURCE SHEET'); > var data = sourcesheet.getDataRange().getValues(); > data.shift(); // Discard the header row > var data_rows = data.length; > if (data[0][2] == '') { // If there is nothing in the second row, assume the sheet is empty > console.log('No Data in source sheet') > console.timeEnd('Archive'); > return; > } > var archive_data = []; > var moved_rows = []; > > // Iterate through the array of data, adding any matching rows to the archive_data array > // and tag the original row as 'Moved' > var row = 0; > while (row <= data_rows) { > var rec = data[row]; > if (typeof rec == 'undefined') { // Exit as soon as we hit the first empty row > console.log("Done at row %s", row+1); > break; > } > > // If column 22 is blank process that row > if (rec[21] == '') { > archive_data.push(rec.slice(0,21)); > moved_rows.push(['Moved']); > } > else { > moved_rows.push([rec[21]]); > } > row++; > } > > var source_sheet_rows_processed = row; > var archive_rows = archive_data.length; > // If we found any rows that need moving, append them to the end of the Database sheet > // And then write the altered data array (with newly archived rows tagged), back to the source sheet > if (archive_rows) { > var archive_sheet = ss.getSheetByName('YOUR DESTINATION SHEET'); > var start_row = archive_sheet.getLastRow()+1; > archive_sheet.getRange(start_row, 1, archive_rows, 21).setValues(archive_data); > console.log("Archived %s rows", archive_rows); > sourcesheet.getRange(2,22,source_sheet_rows_processed, 1).setValues(moved_rows); // Start from row 2 so we don't mess with the header > } > else { > console.log('No new rows to archive.'); > } > console.timeEnd('Archive') > } > > ```