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:
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.
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:
You’ll need to make sure that External Directory sharing is enabled there. That should allow non-admins to also use the Pack.
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: