I'm using this to parse raw website text to pull out business features for a golf related directory website site.

I also used it in the same spreadsheet to read the raw webpage data and create a professional 5 paragraph summary for each one (about 1800 businesses).

Just watch your caps and tokens.

Don't try to process all at onece. Works best to process about 10 at a time.

The GPT4O model works great. It is fast and about 95% accurate.

There are so many uses for this.

Edit: There is an issue that keeps coming up and I've seen others raise the same issue on Reddit and Google Groups getting this error:

Error
Exception: You have exceeded the property storage quota. Please remove some properties and try again. (line 40).

I've tried clearing the cache, clearing the App Script, but nothing works. I hope devs address this well-known issue. Once this "quota" is hit, it renders the entire Power Formula extension useless. The only way to resolve it so far is to transfer to a new sheet.