How to integrate Google Sheets – GitHub bundle using Zapier?
in
Integrations | September 3, 2024
Automate your workflow: every new GitHub commit will automatically be added to Google Sheets using Zapier. Set up the integration in minutes and track changes effortlessly!
Creating a new row in a Google Sheet when a new commit on GitHub is made
How the integration works:
- A new commit on GitHub is made
- Zapier creates a new row in the Google Sheet
- On the “Home” tab, click on “Create”
- In the dropdown menu, select “Zaps”
Setting up the trigger event
- Trigger event is the event that occurs in the target app and informs Zapier to start the Zap.
- Select the trigger event app
- In the dropdown menu, select “New Commit” and click on “Continue”. This way, the trigger will only activate when a new commit is made in the corresponding repo.
- Select your GitHub account and click “Continue”
- Fill out the required fields and click on “Continue”
- Test the trigger by clicking on the corresponding button
- If everything is correct, the system should display all the information. Click on “Continue with selected record”
Setting up the action in Google Sheets
- Select the target app
- Select “Create Spreadsheet Row” as an action to do when a new commit is made
- Select your Google account and click “Continue”
- Fill out the required fields and click “Continue”
- Test the connection between GitHub and Google Sheets
- If everything was done correctly, you should see the test data in your spreadsheet
- Click “Publish”
- After that, the Zap is now created, set up and working.