undefined | Better HN

0 pointsdragonwriter5y ago0 comments

> Aren't you forced to use Google Apps Script to interact with Sheets?

No, it has a REST API; you need Apps Script if you want automation within Sheets, but you can interact with Sheets without it.

0 comments

paulgb5y ago

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.

j / k navigate · click thread line to collapse

0 pointsdragonwriter5y ago0 comments

> Aren't you forced to use Google Apps Script to interact with Sheets?

No, it has a REST API; you need Apps Script if you want automation within Sheets, but you can interact with Sheets without it.

0 comments

paulgb5y ago

j / k navigate · click thread line to collapse