3 ms·
Aren't you forced to use Google Apps Script to interact with Sheets? I remember being forced to use it for interacting with Google Forms API.
by valtism 7y ago
Aren't you forced to use Google Apps Script to interact with Sheets? I remember being forced to use it for interacting with Google Forms API.
- dragonwriter 7y ago> 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.
- paulgb 7y agoThat'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.