GitHub Action
Transfer GitHub Project Issues into Google Sheets
Do you want to import your Issues info into Google Sheets?
Sometimes we need Repository dashboard, Burndown Chart and other analytics. Google Sheets is the simplest way to build your custom dashboard!
It's pretty easy. But it requires some steps:
Google provides cozy button for this:
Create new API project and go to Credentials section.
Then download and save your service account credentials JSON.
More info: https://developers.google.com/identity/protocols/oauth2/service-account#creatinganaccount
Then create new sheet for GitHub Issues data and add Google API Service Account email to your document with editor access
name: github-project-issue-to-sheets
# Controls when the action will run. Triggers the workflow on push or pull request
# events but only for the master branch
on:
workflow_dispatch:
issues:
types: [opened, deleted, transferred, closed, reopened, assigned, unassigned, labeled, unlabeled]
jobs:
github-project-issue-to-sheets:
runs-on: ubuntu-latest
name: github-project-issue-to-sheets
steps:
- name: github-project-issue-to-sheets
id: github-project-issue-to-sheets
uses: ViRGiL175/github-project-issue-to-sheets@dev
with:
google-api-service-account-credentials: ${{ secrets.GOOGLE_SERVICE_ACCOUNT_DATA }}
document-id: '1b0UuGS_HXTGv-BE9dcB_58gZvo5fttyKgle0s4DmRNI'
sheet-name: 'GitHub Issues'More info: https://docs.github.com/en/free-pro-team@latest/actions/learn-github-actions
More info: https://docs.github.com/en/free-pro-team@latest/actions/reference/encrypted-secrets
