Sync team assignments from Sheets to GitHub repository access
Add someone to your project in Sheets, and they're automatically added to the GitHub repo with the right permission. No more waiting for manual access requests or forgotten onboarding steps.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Add a repository collaborator
Adds a github user as a repository collaborator, or updates their permission if already a collaborator; `permission` applies to organization-owned repositories (personal ones default to 'push' and ignore this field), and an invitation may be created or permissions updated directly.
Why this helps
A new team member gets assigned work in your spreadsheet, but nobody remembers to add them to the GitHub repository. They can't see the code or open PRs, so onboarding takes extra back-and-forth.
- Instant repository access for new team members
- Eliminate manual access grant delays
- Keep team rosters in sync across tools
- Reduce onboarding friction
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and GitHub to Notis
- 2Create an automation: 'When a team member is assigned to my project sheet, add them as a GitHub repository collaborator'
- 3Select 'New Rows in Google Sheet' as your trigger
- 4Tell Notis which column holds the team member email/username and what permission level they should get (read, write, or admin)
- 5Test by adding a team member to your project sheet and verifying they appear in the GitHub collaborators list
Questions about this workflow
What if someone is already a collaborator?
Notis checks first and will update their permission level if needed. It won't duplicate entries or cause errors.
Can I assign different permission levels to different people?
Yes. Use a 'permission' column in your sheet (e.g., 'read', 'write', 'admin') and Notis will set each person's level accordingly.
Does this work across multiple repositories?
You can create separate automations for different repos, or tell Notis to add collaborators to multiple repos at once based on project type.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to GitHub. A trigger fires from one place; an action lands in another.
Google Sheets triggers
GitHub actions
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Accept a repository invitation
Accepts a pending repository invitation that has been issued to the authenticated user.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
List repositories starred by the authenticated user
Deprecated: lists repositories starred by the authenticated user, including star creation timestamps; use 'list repositories starred by the authenticated user' instead.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
List stargazers
Deprecated: lists users who have starred a repository; use `list stargazers` instead.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Star a repository for the authenticated user
Deprecated: stars a repository for the authenticated user; use `star a repository for the authenticated user` instead.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Add email for auth user
Adds one or more email addresses (which will be initially unverified) to the authenticated user's github account; use this to associate new emails, noting an email verified for another account will error, while an existing email for the current user is accepted.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Add app access restrictions
Replaces github app access restrictions for an existing protected branch; requires a json array of app slugs in the request body, where apps must be installed and have 'contents' write permissions.
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Add a repository collaborator
Adds a github user as a repository collaborator, or updates their permission if already a collaborator; `permission` applies to organization-owned repositories (personal ones default to 'push' and ignore this field), and an invitation may be created or permissions updated directly.
New Sheet Added in Google Spreadsheet
Polling trigger that detects when a new sheet is added to a Google Spreadsheet.
Add a repository to an app installation
Adds a repository to a github app installation, granting the app access; requires authenticated user to have admin rights for the repository and access to the installation.
Connect any two apps with Notis in the middle.
Not just Google Sheets and GitHub. Any combination from 985+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business GitHub.