Github
Google Sheets
Workflow Template

Copy GitHub contributors to a Google Sheet

This playbook will get all contributors of a given repository and add them to a Google Sheet.
Bardeen automates your repetitive tasks without code.
Install the Chrome extension for free.
Get GitHub contributors
Action
Add data to sheet tab
Action

How does this automation work?

Bardeen's playbook "Copy GitHub contributors to a Google Sheet" enables teams to seamlessly transfer contributor data from GitHub repositories to a Google Sheet. This workflow is essential for project managers and team leaders who want to keep track of contributions and collaborate more effectively. By automating the process of data transfer, you can save time, reduce errors, and maintain a real-time overview of your project's contributors.

Here’s a step-by-step guide to using this automated workflow:

  • Step 1: Get GitHub Contributors - This command retrieves a list of all contributors from a specified GitHub repository. You'll need to input the repository from which you want to gather contributor information.
  • Step 2: Add to Google Sheet - Bardeen then takes the list of contributors and appends it to a designated Google Sheet tab. You'll specify which Google Sheet you'd like to update with the new data, ensuring your spreadsheets stay up-to-date with the latest contributor details.
Run this Github automation with Bardeen in minutes.

How to run the workflow


Is there a way to get a list of GitHub contributors with their contact info as a simple Google Sheet? 

There are over one million contributors on GitHub who push thousands of lines of code every single day. Each time a pull request is merged into a repository, the person who generated the pull request will get added as a contributor to the repository.

GitHub displays the contributors at the bottom right-hand corner of the repository, and it isn’t very convenient given that it only displays names and avatars.

What if you want an updated list of contributors with details like Username, Profile URL, and organization URL?

The answer is to use this automation!

The automation has two arguments to input when you run it:

1- GitHub repository

2 - Google sheet name

Boom! Just like that, you have a list of contributors for the repository in a Google Sheet. No copy-pasting!

This automation is helpful if you want access to an updated list of contributors for a repository or if you want to display the contributors in a Readme.md file.

Tip: Check out our other playbooks that will help you get information from GitHub. You can get a list of contributors who starred a GitHub repository and copy their information to Google Sheets or Find the email address of a GitHub user with one click.

Discover more integration opportunities with GitHub integrations, Google Sheets, or both GitHub + Google Sheets, or tailor the playbook to better suit your distinct workflow preferences.

Learn more about the awesome product development integrations and data sourcing integrations available.

Run this Github automation with Bardeen in minutes.

Available actions & triggers

Apps:
Copy GitHub contributors to a Google Sheet
Copy GitHub contributors to a Google Sheet
Copy GitHub contributors to a Google Sheet
Types:
Both
Actions
Triggers
Get GitHub issue body
Get GitHub issue body
Action
When row is added to or changed in Google Sheet
When row is added to or changed in Google Sheet
Trigger
Create Google Sheet
Create Google Sheet
Action
Update or add rows in/to sheet
Update or add rows in/to sheet
Action
When new row is appended or changed
When new row is appended or changed
Action
When comment is added to issue or PR in GitHub
When comment is added to issue or PR in GitHub
Trigger
When row is added to Google Sheet
When row is added to Google Sheet
Trigger
Create new spreadsheet tab
Create new spreadsheet tab
Action
When GitHub issue is added
When GitHub issue is added
Trigger
When row changes
When row changes
Trigger
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use

FAQs

Bardeen - Playbook / Autobooks: Is it possible to create a Playbook that scrapes data from a website and sends it as an email attachment?

You can create a Bardeen Playbook to scrape data from a website and then send that data as an email attachment.

Youtube: Can I download a Youtube video to my computer using Bardeen?

Unfortunately, Bardeen is not able to download videos to your computer.

Google Sheets: What is the best way to export data to Google Sheets?

Exporting data (ex: scraped data or app data) from Bardeen to Google Sheets is possible with our action to “Add Rows to Google Sheets”.

Meetings: Is there a playbook to record and summarize meetings?

There isn't a specific AI use case available for automatically recording and summarizing meetings at the moment

Playbooks/Autobooks: How do I edit an action in a Playbook or Autobook?

Please follow the following steps to edit an action in a Playbook or Autobook.

Scraper: How can I get data from multiple sections of a profile (Eg: getting the experience section on a linkedin profile)?

Cases like this require you to scrape the links to the sections and use the background scraper to get details from every section.

By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.
No items found.