Launched: G Suite Directory Pack [TEAM]

Coda has supported integrations with apps from Google for quite some time now, including Gmail, Google Calendar, and Google Drive. If you’re using these tools with a team, odds are you’re using them as part of G Suite.

To help teams on Team or Enterprise Coda plans stay organized, we’ve launched the G Suite Directory Pack! Use the / command or Explore Panel to install the Pack to build tables and tools that leverage your G Suite Directory information.

After you authorize into G Suite, you can use this Pack to quickly make a table with details for all of the users in your company’s G Suite directory. Available columns include:

  • Name
  • Email
  • First Name
  • Last Name
  • Image
  • Addresses
  • Email Addresses
  • Phone Numbers; and
  • Google ID

Tip: Pair this Pack and its column types with other integrations, like Gmail, Google Calendar, Zoom, or Slack to quickly send the right messages and meeting details to the right team members, or even automate some recurring communication tasks and reminders.

14 Likes

Great for building company team pages and organization charts—also for Onboarding Kits : )

2 Likes

Hey, @oleg.
It seems nice.
I couldn’t find the pack.
Is it already available?
Update. Now I can see it. I had to close the doc first. :smiley:

Breno

3 Likes

i’m having a hard time with this pack. i keep getting error messages of not being able to connect the Google Directory API. do i need to enable something in GSuite Admin?

Hey @Mohamed_Hamad1, G Suite can get locked down in a way that prevents this Pack from having the needed permissions. To start, I’d go to the Google Admin console and head into the directory settings:

image

You’ll need to make sure that External Directory sharing is enabled there. That should allow non-admins to also use the Pack.

I have 2 options here which feel like both do the same thing so not sure which to enable

  • Public data and authenticated user basic profile fields
  • Domain and public data

I’m gonna try Domain and public data for to see if that makes a difference

tried both options for Directory settings , and i’m still getting the error. not sure how to get this working.

Ok, another possibility is that access to G Suite data within your organization got restricted and not available to the Coda Packs app. Google has the following article with steps on how to enable access: Control which third-party & internal apps access G Suite data

The Pack uses the G Suite Admin SDK Directory API, which you can test using this tool. If you’re able to Execute the sample query using the “Try this API” tool, things should start working for the Coda Pack too.

looks like something is odd in my setup coz even the tester too gives me a 400 error. not sure why, coz i have full access to Coda in my API settings. And i’m sing GMail, Calendar, Drive and Search Console with coda.

Unfortunately I’m out of ideas at this point, especially if you’ve tried these suggestions and even Google’s API tester tool is still giving you 400s. I would contact Google’s support to troubleshoot as this is a G Suite configuration issue we do not have insight into. If you do hear back and manage to resolve it, please do post here as I’m sure that would be useful to others!

Just to follow up on this, I realized that there is also an API Controls setting in the G Suite console (I couldn’t see it earlier since I was lacking permissions.) You should see something like this:

You’ll need to make sure that Coda Packs has access to the Admin SDK API there.

1 Like

I’ve given coda trusted access to directory API and its still not working. will hit up google support on this one

1 Like