# Importrange

**URL:** <https://community.glideapps.com/t/importrange/1635>\
**Category:** Ask for Help\
**Created:** [November 3, 2019, 2:24pm UTC](https://community.glideapps.com/t/importrange/1635 "2019-11-03T14:24:18Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [November 3, 2019, 10:45pm UTC](https://community.glideapps.com/t/importrange/1635/11 "2019-11-03T22:45:17Z")

</div>

I don’t think so George!

Try using this:

=Query(ImportRange()) and you will see how fast the data is updated.

In my spreadsheets, If I modify or add a new record (I have 150.000 records in my source spreadsheet), my other sheet gets new data in less than 1 min.

That is my sintaxys to get it:  
=query(IMPORTRANGE(“1mEoXgU2StLrYa9TbvX00RdGFHsa1RFV\_WP2Tnc7dtnw”,“Sheet 3!A1:F9”),"Select \* ", -1)

I set up a timer trigger to change the date/time in some cells and I can see how my query retrieves the new data from my source spreadsheet every 1 min without problem.

Let me know if this solves your problem.

Saludos

Gavp

---

_[View the full topic](https://community.glideapps.com/t/importrange/1635)._