Has anyone integrated with Google Workspace (formerly Google Suite)?

Questions
1

Wondering if anyone has integrated with Google Workspace (formerly Google Suite)?

I’m building a multi-tenant SaaS product, and want organisations to be able to:

  • connect their organisation’s workspace (requires admin)
  • search/filter/sort/view lists of docs/sheets/slides
  • view basics meta data (created date, last updated date, last updated by)
  • open files (in new window, to be able to edit it native google interfaces)
  • Manage permissions and sharing

I can’t see a plugin, but workspace offers an API. Just wondering if anyone has any experience or recommendations before leaping in to this

2

I haven’t but I’d be willing to help with this. I figure it’d be done using their API and would need to pore through heir documentation. Do you need an extra hand let’s figure it out together.

1 Like
3

Hi Panto! I’ll send you a DM

4

You can easily accomplish this using the Google Admin API, you just need to make sure you’re requesting access to the scopes you need access to (you have to request for access and Google has to approve the use case)

5

Is there a reason why you recommended the Google Admin API, and not the Google Drive API?

6

Oh sorry, yes, you can use the Google Drive API. But the thing with the Google Drive API is you’ll only be able to access the Drive account for the user making the oauth connection.

AFAIK if you want to access other users’ files in your organization, you’ll need to use a service account with domain delegation, then use the files.list endpoint and loop through each user in your organization. Here’s a stack overflow thread that talks about it.

7

Thanks!

What about the scenario where there’s a paid school/org account on Google workspace, and in a bubble app each school/org admin can link the account, and then individual users can 0auth to view/add files etc?

Essentially I’m trying to reduce the need for particular users to have to log in and check/use two apps.