Do you use formulas in your Google Sheets like =today()?
Google Sheets formulas like NOW, TODAY, RAND, and RANDBETWEEN - will often only update when the Spreadsheet is opened or updated.
This can cause issues with Zaps if we expect those dates to be updated automatically to trigger Zaps.
In the Sheet itself - we can adjust how often Google updates the values for those formulas.
- Go to File > Spreadsheet Settings.
- In the screen that pops up - click on the Calculation tab and change the setting for Recalculation to be either “On change and every minute” or “On change and every hour” - then click Save.
With the every minute setting - Google will update the calculations for formulas like today() every minute. Every hour would do the same thing on an hourly basis.
This will enable Zaps that use those formula columns to trigger (or find records) without the spreadsheet needing to be opened to update the value.