How to bypass remote caching

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().