Although Github provides a summary of repositories I have personally seen many project/product managers using Google sheets to keep track of issues and other repository related summary details. It’s a tiresome task to manually copy-paste these details into a google sheet. Choreo makes this integration between Github and Google Sheets super easy! Let’s see how we can do this integration in a few minutes. Login to the Choreo developer portal through https://console.choreo.dev/login/ Click on Get Started in the Integrations card and click on Create. Insert your integration service name under the card and click on Create with Choreo Create. Select the webhook trigger and select and provide authorization for Choreo to access your Github account. Github Connect to GitHub Provide the following details for the Github Trigger. Select a which lists all your available repositories. GitHub Repository Select the you want to add to your sheets. It can be issues, labels, pull requests or anything else listed in the dropdown. event Select the related to the event you selected. I selected issues and i’m going to extract the opened issues. action After adding all the details, click on . Save Select under API calls and provide Choreo authorization to connect to Google Sheets and click on . Google Sheets Save Select the necessary operation related to Google Sheets that satisfies your requirement and provide the following details. I selected the Append Row operation. i. Create a Google sheet and provide the . Google Sheet ID ii. Provide the . Worksheet name You can add the row values required to be shown in the sheet. I want the following details and the corresponding Row value is shown below. item iii. Click on after inserting each Item value. Add Item a. Issue url : b. Issue title : c. Issue created time: event.issue.html_url event.issue.title event.issue.created_at You can refer to the Github issues API for more properties: https://docs.github.com/en/rest/reference/issues After adding all the details, click on . Save Click on the button at the bottom of the page to test your integration. Run & Test You can create a new issue in. your Github repository and check whether the issue is recorded in the Google sheet. In a few minutes, you have integrated Github with Google sheets to record the newly created issues in your repository. Choreo just made every manager’s life so much easier!
