search

scryfall / google-sheets

Custom =SCRYFALL() function for Google Sheets
69 stars 12 forks source link

Concerns with using the function while building a catalog #19

Open jkarn88 opened 11 months ago

jkarn88 commented 11 months ago

I had the idea that I wanted to create a catalog in Google Sheets rather than using a site to handle my collection, mostly because I would have more control over generating various statistics of my collection. I came across the custom function here and started using it to generate a handful of the objects for each of my entries. After I had entered around 100 rows of separate entries I noticed in the API Documentation the bit about the rate limit and that every time I reload the sheet it recalculates the formula. Since then I've been hesitant to continue using it per row as to not abuse it. Is this something I should be concerned with while using this function or is there a way to limit it's recalculation?

jkarn88 commented 11 months ago

I guess I just answered my own question as far as the concern goes. I have reloaded the page a handful of times today on top of playing with a formula that definitely populated too many cells and I got the error about too many requests for the day.