I also posted one recently, a plugin to connect to APIs directly in Google Sheets [1]. The primary use case I had in mind was for people looking to grab data from various APIs, in which case it's pretty clear why someone would want to directly access the output in Google Sheets. However, I was surprised to discover a lot of people are actually using it as an alternative to CMSes like Wordpress, like bolting it together to other plugins and sheets to create their own apps. It's a trend for sure, I think it all falls under the "low code/no code" movement.

[1]: https://chrome.google.com/webstore/detail/api-connector/cebn...