Google Sheets can be surprisingly handy as a UI for editing data. For example, I have a job on AWS that scrapes a handful of URLs and snapshots them. Instead of creating a database and hosting it somewhere, or hard-coding them, I put them in a spreadsheet that the AWS job reads at the beginning of every run.
There is more I could do with this (like trigger an email if something fails, etc). But at least does what you describe above in a (hopefully) succinct fashion!
Also, shill alert as I'm an author for this service (but this was a fun project to build over a few minutes, so thank you).
That's the best part, I don't even use an API! I just go File -> Publish to the web, then select "Comma-separated values" instead of "Web page" from the dropdown. Then I use Pandas to read the CSV in Python.
haha yeah and I always wonder why especially engineers are so creative in using Excel as a graphics/painting tool :) Looks good, but a nightmare to read in a programmatic way ^^
I use this to automate a lot of tasks. E.g. automatically clip supermarket coupons every week, check for tax loss harvesting opportunities in my portfolio, etc.
