GitHub Action
Transfer GitHub Project Issues into Google Sheets
Wanna import your Issues info to Google Sheets?
Cause we want Repository dashboard, Burndown Chart and other analysis. Google Sheets is simplest way to build your custom dashboard!
It's pretty easy. But 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 writer 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
