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.