Skip to main content

Why Google Groups?

Joining a SourceMedium workspace does not need a Google Group. Invite people from Team instead, which covers the workspace, the warehouse, and your configuration sheets: see Giving dashboard access to a teammate. Use this guide to share the reports and sheets your team owns, including your Looker Studio dashboard.
Google Groups acts as an identity primitive across Google’s ecosystem. One group email grants access to:
  • Looker Studio dashboards (viewer or editor)
  • Google Sheets (config sheets, exports)
Warehouse access is the exception. It comes from your workspace role, not from a group.
A group only opens what you shared with the group. Adding someone gives them everything shared with it and nothing else, and Google can take a little while to catch up. It does not make them a member of your SourceMedium workspace.

Quick Start: Create a Group

1

Go to Google Groups

Navigate to groups.google.com and sign in with your organization account.
2

Click Create Group

Create Group button
3

Configure group details

  • Group name: Descriptive name (e.g., “Acme Analytics Team”)
  • Group email: acme-analytics@googlegroups.com
  • Description: Who should be in this group and what they access Group details form
4

Set privacy settings

Choose who can find and join the group. For internal teams, “Only invited users” is recommended.Privacy settings
5

Add members and create

Enter email addresses for initial members, then click Create group.Add members

Managing Group Members

Add members

Click Add Members at the top of your group page. Add members button

Adjust permissions

Go to Group Settings to modify who can post, view members, or join. Group settings

Allow external members

If you need to add people outside your organization, enable this in Group Settings: External members setting

Sharing Resources with Your Group

Once your group exists, use the group email to grant access across Google products.

Looker Studio Dashboards

  1. Open your dashboard and click Share (top right)
  2. Enter the group email address
  3. Choose permission level:
    • Viewer: Can view and interact with filters
    • Editor: Can modify the dashboard
Share dashboard
Recommendation: Grant Viewer access to most users. Editor access can lead to accidental changes that break dashboards.

Google Sheets (Config Sheets)

  1. Open the sheet and click Share
  2. Enter the group email
  3. Choose permission level:
    • Viewer: Read-only
    • Commenter: Can add comments
    • Editor: Can modify content
Share sheet

BigQuery Datasets

SourceMedium sets warehouse access up from Team, not from a group, so invite people there. If you want one of your own groups to query BigQuery as well, ask us first so the permissions are right.
For most teams, we recommend two groups:
Start with one group for simplicity. Split into viewer/admin groups when you have 5+ users with different needs.

Troubleshooting

”You don’t have access” error

Verify the user is actually in the group at groups.google.com.
Permission changes can take time to propagate across Google services. If you just added someone to the group or shared a resource, have the user sign out and back in, then try again.
Ensure the resource was shared with the group email (e.g., team@googlegroups.com), not an individual.
If adding external users, ensure “Allow members outside your organization” is enabled in Group Settings.

Dashboard shows “No data”

This usually means the data source permissions are separate from dashboard permissions. Contact SourceMedium support to verify data source access.