I wanted to see if it would ask for access to my entire Google Sheets account, so I tried signing into https://gsheet2mail.com/ and got an error message.
Looking at the page again, I saw this, which I missed:
> Hi there! We're currently being verified by Google. So just click "Advanced" when signing up to continue :)
I tried clicking advanced, and yep, it wants access to all my spreadsheets =) I said no, but I don't want a google sheets to RSS converter right now anyway.
This is one advantage Zapier has over unbundled apps - I'm more likely to want to give Zapier permissions to my APIs because it's an established company and it can help with a bunch of different things, than to give access to a new single function tool.
That's the read-only scope that's required to query a single spreadsheet on the user's account. The API doesn't allow listing queries unless you also ask for drive permissions (which I don't).
I'm famiilar with the Google Sheets API. The way to get fine-grained access to the Google Sheets API is by asking for a specific permission within Google Drive. While it involves two APIs, it's less permissions than giving access to all the spreadsheets in a google sheets account.
Another way to go is to use a service account, and have the user share their sheet with your service account's email address.
Looking at the page again, I saw this, which I missed:
> Hi there! We're currently being verified by Google. So just click "Advanced" when signing up to continue :)
I tried clicking advanced, and yep, it wants access to all my spreadsheets =) I said no, but I don't want a google sheets to RSS converter right now anyway.
This is one advantage Zapier has over unbundled apps - I'm more likely to want to give Zapier permissions to my APIs because it's an established company and it can help with a bunch of different things, than to give access to a new single function tool.