To add to this, combining this with LLMs is very powerful. If you describe the structure of your sheets and how you want them manipulated to ChatGPT, it will (in my experience) output hundreds of lines of code that will work on the first try. This has turned me from Just Some Guy into a capable programmer at work, it’s crazy.
Google Sheets also has a criminally under appreciated tool—Google App Script
You can write custom code, as Javascript, and have it run on a schedule, or as a function in a spreadsheet cell, or as a clickable menu item
To add to this, combining this with LLMs is very powerful. If you describe the structure of your sheets and how you want them manipulated to ChatGPT, it will (in my experience) output hundreds of lines of code that will work on the first try.
This has turned me from Just Some Guy into a capable programmer at work, it’s crazy.
Nice, Thanks!