Bot to automatically sync and update an airtable sheet with GitHub pull request and issue data.

Clone this repo:

Branches

Tags

  1. 74f656b Update main.go by Jess Frazelle · 3 days ago master
  2. 05ac160 update generated project files by Jess Frazelle · 4 weeks ago
  3. c9c5ddf :pencil: Fixes Airtable link markdown (#3) by Jeff Triplett · 4 weeks ago
  4. 80f3351 Update readme (#2) by clippy · 5 weeks ago
  5. 7452d31 logging by Jess Frazelle · 5 weeks ago

gitable

Travis CI

Bot to automatically sync and update an Airtable sheet with GitHub pull request and issue data.

NOTE: Your airtable table must have the following fields: Reference (single line text), Title (Single Line Text) , Type (single select), State (single line text), Author (single line text), Labels (multiple select), Comments (number), URL (url), Updated (date, include time), Created (date, include time), and Completed (date, include time) Project (Single Line Test).

The only data you need to initialize (if not running with --autofill) is the Reference which is in the format {owner}/{repo}#{number}.

It should look like the following:

airtable.png

Installation

Airtable baseID and table name

Binaries

Via Go

$ go get github.com/jessfraz/gitable

Running with Docker

$ docker run --restart always -d \
    -v /etc/localtime:/etc/localtime:ro \
    --name gitable \
    -e "GITHUB_TOKEN=59f6asdfasdfasdf0" \
    -e "AIRTABLE_APIKEY=ksdfsdf7" \
    -e "AIRTABLE_BASEID=appzxcvewrwtrewt4" \
    -e "AIRTABLE_TABLE=Current Open GitHub Pull Request and Issues" \
    r.j3ss.co/gitable --interval 1m

Usage

       _ _        _     _
  __ _(_) |_ __ _| |__ | | ___
 / _` | | __/ _` | '_ \| |/ _ \
| (_| | | || (_| | |_) | |  __/
 \__, |_|\__\__,_|_.__/|_|\___|
 |___/

 Bot to automatically sync and update an airtable sheet with
 GitHub pull request and issue data.
 Version: v0.1.0
 Build: 6a3dee6

  -airtable-apikey string
        Airtable API Key (or env var AIRTABLE_APIKEY)
  -airtable-baseid string
        Airtable Base ID (or env var AIRTABLE_BASEID)
  -airtable-table string
        Airtable Table (or env var AIRTABLE_TABLE)
  -autofill
        autofill all pull requests and issues for a user [or orgs] to a table (defaults to current user unless --orgs is set)
  -d    run in debug mode
  -github-token string
        GitHub API token (or env var GITHUB_TOKEN)
  -interval string
        update interval (ex. 5ms, 10s, 1m, 3h) (default "1m")
  -once
        run once and exit, do not run as a daemon
  -orgs value
        organizations to include (this option only applies to --autofill)
  -v    print version and exit (shorthand)
  -version
        print version and exit