# Refreshing Data from Google Sheets

**URL:** https://community.glideapps.com/t/refreshing-data-from-google-sheets/33789
**Category:** Ask for Help
**Created:** [October 31, 2021, 6:55am UTC](https://community.glideapps.com/t/refreshing-data-from-google-sheets/33789 "2021-10-31T06:55:17Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![rayo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rayo/32/91372_2.png) [@rayo](https://community.glideapps.com/u/rayo)
#### Post date: [October 31, 2021, 6:55am UTC](https://community.glideapps.com/t/refreshing-data-from-google-sheets/33789/1 "2021-10-31T06:55:17Z")

</div>

Hello, would appreciate any advice.

I have a pro app & using an Integromat scenario when triggered using a button in the app takes 20 seconds to fill in a value in a column.

Data Settings are set to Refresh (While editing or using the app) but it takes several minutes before Glide refreshes the new data.

What is the time frame usually that Glide periodically refreshes data from the Google Sheets in pro apps? and are there ways to get this data from Google Sheets to Glide faster?

---

<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: [October 31, 2021, 2:12pm UTC](https://community.glideapps.com/t/refreshing-data-from-google-sheets/33789/2 "2021-10-31T14:12:58Z")

</div>

This is not a solution. Just an explanation. Something needs to trigger that synchronization if you need it to happen sooner. If data doesn’t change on the glide side, then I think it will check the Google sheet every few minutes for updated data. I believe if you have the sheet open and make a change yourself, then Google might sent that update to glide, but there is no guarantee on how timely that is. Certain formulas, scripts, or outside changes (such as updates from integromat) won’t necessarily trigger Google to send the update to glide. My only suggestion is to also update some data in the sheet at that same time that you trigger the webhook. It might help, but if your integromat scenario is taking 20 seconds to update the sheet, then glide might be missing that small windows when it’s actively checking for updated data that may have been recalculated in the sheet.

> [@google spreadsheet update in data taking time,](https://community.glideapps.com/t/google-spreadsheet-update-in-data-taking-time/33122/6):
>
> If a data change is initiated by the app, then that change will first sync to the database on the glide server, then that will initiate the sync of the data to the Google sheet. If there are calculations that happen in the Google sheet and they happen quickly enough, then I believe Glide will do another check for updated data in the Google sheet to update the glide database before going to sleep for a few minutes (assuming you have pro and have the background refresh/sync turned on). If you do…

---

<div class="post-metadata">

### Author: ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)
#### Post date: [October 31, 2021, 2:29pm UTC](https://community.glideapps.com/t/refreshing-data-from-google-sheets/33789/3 "2021-10-31T14:29:41Z")

</div>

We use custom action made up of both a Webhook Action and an Increment Action (before/after our webhooks) so that when what Jeff said above happens, and all three services sync accordingly, updating the user-facing app.

Sometimes its lags for a few seconds, but it’s been working good enough so far! 🤞🏻
