How to bypass remote caching

Updated on June 1, 2023

Alongside the save button, remote caching is a performance optimization that prevents the odd Google Sheets quirk of periodically refreshing your formulas and wasting monthly characters.

Remote caching is just one of the many performance optimizations that Flowshot has under the hood.

What is remote caching?

Remote caching saves a copy of your generated outputs in our own cache, rather than relying on Google Sheets' local cache.

This means that scenarios such as refreshing the page or inserting rows will not retrigger the formula and use up your character quota — instead, you'll get a cached version of the generation delivered back to you.

Bypassing the cache

There are certain scenarios where you might want to bypass the cache and get an original response every time.

To do this, you can structure your formulas as follows:

=AI("Generate a random number between 1 and 100,000", FALSE)Code language: PHP (php)

Adding FALSE to the formula will reset the cache.

This applies to both =COMPLETE() and =AI().

Try Flowshot for free

View on Google Marketplace
No setup or credit card required ✨
GET 30% OFF • GET 30% OFF •

Something new is on the way!

We're re-launching Flowshot at the end of January with a revamped new look and performance upgrades! Sign up to be notified when we go live 🚀