Im designing a small interface in flutter where several groups of people manage a google spreadsheet.
- Each group of users manage their own google spreadsheet
- Each spreadsheet lives in a single drive (let's say my drive)
What is the best way to authorize people to manage those sheets? I've seen:
- Using googleapi and google_sign_in (https://pub.dev/packages/googleapis)
- Using google service accounts through gsheets library (https://pub.dev/packages/gsheets)
I was thinking of using method 2, where each group has access to a service account which reads/writes into an specific sheet. I would then require people to sign in on my app to make sure which service account they have access to.
I was wondering if there's a better practice on how to provide access to the users to edit sheets in my drive? I've been searching other options but haven't had any luck.