Re:Ask HN: What are your favorite low-coding apps / tools as...
by paulgb on Sunday April 05, 2020 @06:58PM
(#22789442)
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.
No, it has a REST API; you need Apps Script if you want automation within Sheets, but you can interact with Sheets without it.