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

Clone this repo:

Branches

Tags

  1. 064d47d Fix broken links to binaries (#4) by Shubheksha · 8 weeks ago master
  2. 74f656b Update main.go by Jess Frazelle · 9 weeks ago
  3. 05ac160 update generated project files by Jess Frazelle · 3 months ago
  4. c9c5ddf :pencil: Fixes Airtable link markdown (#3) by Jeff Triplett · 3 months ago
  5. 80f3351 Update readme (#2) by clippy · 3 months 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 Text).

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