I am busy writing a Google spreadsheet with the Sheets API. I have a process that gives users access to the created spreadsheet (via database table).
Spreadsheets can be shared on the internet, and when you share a spreadsheet; the user can request access to the sheet from the owner.
The question is whether it's possible to get the list of users/email addresses that requested access using the Drive SDK?
I am using go (language doesn't matter here) and currently give access like this:
func (g *GoogleSheetsService) AddUserToSpreadsheet(email string) error {
_, err := g.DriveSDK.Permissions.Insert(g.sheetID, &drive.Permission{
Type: "user",
Value: email,
Role: "reader",
}).Do()
if err != nil {
return err
}
return nil
}