How to Integrate GitHub with Google Sheets in Five Minutes!

  • By Sachini Ranasinghe
  • 11 Aug, 2021

Problem Summary

The software industry uses GitHub extensively for version control, tracking issues, managing projects, continuous deployment, etc. Think of a scenario where a company’s software product source codes are hosted in GitHub and are developed by a number of developers worldwide. Often, senior management need statistics of a project and details about how it is managing and progressing.

If we look at GitHub as a service, although it provides a summary of the repository activity in its web console, a person who is not aware of the platform’s functions will not be able to get the necessary information. To cater to requirements like creating reports and visualizing charts, Google Sheets is the best solution. Google Sheets allows users to edit, organize, and analyze different types of information. But this integration between GitHub and Google Sheets will not be an easy task if a company decides to go with their own in-house solution.

Solution

There are different solutions that provide such integration capabilities, where a user can choose a B2B integration. It can be mainly classified into two categories: code driven and configuration (low-code) driven. Both approaches have their pros and cons.

The Choreo platform is an intelligent integration platform as a service (iPaaS), which provides its subscribers a complete, AI-powered experience with code, low-code, or both to build applications. It allows you to visually draw the steps of any integration.

This post focuses on Choreo’s powerful capabilities in speeding delivery and significantly reducing complexity in cloud-native enterprise application development to address the above software as a service (SaaS) integration scenario. In this integration, we focus on generating an issue summary report for senior management. In the Choreo low-code editor, we will use the GitHub listener and Google Sheet connector to implement the scenario.

The following video also provides a walkthrough of the required steps.

Implementation

Step 1: Login to the Choreo platform and select Integrations. Then, click Create.

Step 2: Provide a name for your project and click Create.

Step 3: Select the trigger for your integration scenario. In this instance, the trigger will be a GitHub webhook trigger. Select it and click Connect to GitHub.

Step 4: Provide authorization for Choreo to access your GitHub account. Provide the necessary credentials.

Step 5: Configure the GitHub trigger with the necessary parameters.

Step 6: Select Google Sheets from visiting the API Calls tab. Click Connect to Google Sheets.

Step 7: Provide authorization for Choreo to access your Google account. Provide the necessary credentials.

Step 8: Configure the action you need to perform in the Google Sheet by selecting the sheet's endpoint and adding the necessary data for the action. Finally, click Save.

The final solution of your integration will be able to append a new row to a given Google Sheet when a new issue is created in a selected GitHub repository. By using this integration, we can automate summarizing the data in a specific GitHub repository. The final product of your integration will look like this.

If we were to use the traditional approach to build this integration, there are many complicated tasks which involve studying APIs, implementing HTTP calls, response handling, error handling, deployment complexities, etc. But, using the Choreo platform, it is simplified to just a few drag and drop steps. This is an example of the platform’s powerful capabilities to perform cloud integrations.

Moreover, you can edit the integration using the code editor as well. This facilitates developers who prefer to code. The code editor for this example integration scenario looks like this.

As a final step, you can run and test the integration to check whether it works as expected. If everything works properly, once we create a new issue in the selected GitHub repository, it should be recorded in the Google Sheet.

We hope this example helped understand how easy it is to create a custom integration scenario using Choreo’s low-code editor. The platform supports easy integrations not only between GitHub and Google Sheets but also between many other cloud platforms and services. You can try out these capabilities by accessing https://console.choreo.dev/login/.

You can also visit the Choreo homepage to find out more about how the solution gives organizations a single, all-inclusive platform for creating integrations, services and APIs; managing APIs; and deploying services and APIs—going from ideas to production in hours.

Table of Contents

Sign in to get started

An intelligent iPaaS that does not make you choose between code and low-code

Create your first Choreo App

This website uses cookies so that we can provide you with the best user experience. Read our Cookie Policy to find out more.

If you wish to disable cookies you can do so from your browser.

I Understand