CODEWITHSUNDEEP
javascriptoauthgoogle-drive-apigoogle-sheetsgoogle-oauth
Verdagon
Verdagon

Reputation: 2630

Can I associate a user's account with an action to the drive API?

We're looking to make a little webapp to manage our week-long nerf war (humans vs zombies to be precise), and we're thinking about how easy it would be to have Google Sheets be our only backend, and our frontend be entirely javascript/html/css.

Let's say there's two actions that can be done in this javascript:

  1. Register, which adds a row to a certain sheet.
  2. Report tag, which adds a row to another sheet.

Let's say we have 100 players. We'll have each player sign in using a google account. Is there a way that for either of those above actions, we can have sheets know who made that action?

This way, if someone gets hold of the API key and spoofs their referer to make bad requests, then we can know which google account did it and ban them from the game.

For example, if I open up my sheet and say "see revision history", I want to not see one user for all the revisions, I want to see the user who triggered the action.

Is this a reasonable approach, and is it possible? Thanks!

(note: i know these two actions can be done via google forms, which can associate the user's account, but imagine we have more complex actions that cant be achieved with just a google form)

Upvotes: 0

Views: 56

Answers (1)

pinoyyid
pinoyyid

Reputation: 22306

The short answer is no. You'll be using the spreadsheets API (NOT the Drive API) to update the sheet.As far as Google is concerned, the "user" is your application, regardless of which human was driving the application at the time. Your application knows who the human is, and so it is responsible for logging any audit info that your use case may require.

Upvotes: 1

Related Questions