Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
DIW 2016: Github Project Scaffolding with Googl...
Search
dirtystylus
November 15, 2016
Technology
0
220
DIW 2016: Github Project Scaffolding with Google Sheets and Zenhub
Talk given at Delaware Innovation Week. November 15, 2016
dirtystylus
November 15, 2016
Tweet
Share
More Decks by dirtystylus
See All by dirtystylus
Rapid Data APIs using GraphQL and Drupal
mllobrera
0
62
Decoupled Drupal Days 2018: Drupal Unhitched
mllobrera
0
310
Drupaldelphia 2018: Drupal Unhitched: The CMS in Decoupled Architectures
mllobrera
0
260
Drupalcon 2017: Pattern Language: Pattern Libraries in the Wild
mllobrera
0
460
Philly Tech Week 2016: Decoupled Development: Feeding Your Application with Off-the-Shelf Tools
mllobrera
0
150
Drupal Beyond the Browser: Using Drupal to Power Apps and Touchscreens
mllobrera
0
350
Decoupled Development with WordPress JSON APIs
mllobrera
0
700
Drupaldelphia 2014: Progressive Enhancement in Drupal 7, Using Ajax-Include Patterns
mllobrera
0
160
Drupaldelphia 2013 - Tyler School of Art: A Case Study in User-Centered Decision-Making
mllobrera
0
1k
Other Decks in Technology
See All in Technology
改めてAWS WAFを振り返る~業務で使うためのポイント~
masakiokuda
2
250
Delta airlines®️ USA Contact Numbers: Complete 2025 Support Guide
airtravelguide
0
340
【5分でわかる】セーフィー エンジニア向け会社紹介
safie_recruit
0
27k
SaaS型なのに自由度の高い本格CMSでサイト構築と運用のコスパ&タイパUP! MovableType.net の便利機能とユーザー事例のご紹介
masakah
0
110
「良さそう」と「とても良い」の間には 「良さそうだがホンマか」がたくさんある / 2025.07.01 LLM品質Night
smiyawaki0820
1
550
赤煉瓦倉庫勉強会「Databricksを選んだ理由と、絶賛真っ只中のデータ基盤移行体験記」
ivry_presentationmaterials
2
360
AWS Organizations 新機能!マルチパーティ承認の紹介
yhana
1
280
整頓のジレンマとの戦い〜Tidy First?で振り返る事業とキャリアの歩み〜/Fighting the tidiness dilemma〜Business and Career Milestones Reflected on in Tidy First?〜
bitkey
2
16k
敢えて生成AIを使わないマネジメント業務
kzkmaeda
2
440
KubeCon + CloudNativeCon Japan 2025 Recap
ren510dev
1
380
FOSS4G 2025 KANSAI QGISで点群データをいろいろしてみた
kou_kita
0
400
united airlines ™®️ USA Contact Numbers: Complete 2025 Support Guide
flyunitedhelp
1
300
Featured
See All Featured
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.7k
Making Projects Easy
brettharned
116
6.3k
Facilitating Awesome Meetings
lara
54
6.4k
What’s in a name? Adding method to the madness
productmarketing
PRO
23
3.5k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
31
1.3k
Music & Morning Musume
bryan
46
6.6k
StorybookのUI Testing Handbookを読んだ
zakiyama
30
5.9k
Documentation Writing (for coders)
carmenintech
72
4.9k
Measuring & Analyzing Core Web Vitals
bluesmoon
7
510
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
20
1.3k
Building Flexible Design Systems
yeseniaperezcruz
328
39k
Improving Core Web Vitals using Speculation Rules API
sergeychernyshev
18
970
Transcript
Github Project Scaffolding with Google Sheets and Zenhub Delaware Innovation
Week November 15, 2016
Hi. I’m Mark. Director of Technology, Bluecadet @dirtystylus
Let’s talk about workflow. Beginnings, and endings.
Clues from cooking • Recipes—what is the base set of
things you repeat for success? • Tasks for setting up a project • Tasks for launching a project • Manual entry = time
Interlude: Bench Time @ Bluecadet • List of pre-approved internal
agency projects • Folks can chip away at things they’re excited about • Some examples: Electron for web-based apps. Unity 3D in Oculus Rift.
Addressing the pain points at the start and end.
Ingredients • Listening • Empathy • Github API • Python
• PyGithub (https://github.com/PyGithub/PyGithub)
Automation to reduce friction.
Step One: Create an Issue
#!/usr/bin/python import sys sys.path.append("./PyGithub"); from github import Github import getpass
# Authenticate to github.com and create PyGithub "Github" object username
= raw_input("Github username: ") pw = getpass.getpass() g = Github(username, pw) repository = "dirtystylus/pygithub-sandbox" repo = g.get_repo(repository) issue = repo.create_issue("Test issue", "This is a test issue.")
Step Two: Labels and Milestones
Prerequisites • Create Labels and Milestones first • Label is
String • Milestone is Integer • ¯\_(ツ)_/¯
username = raw_input("Github username: ") pw = getpass.getpass() g =
Github(username, pw) user = g.get_user(username) repository = "dirtystylus/pygithub-sandbox" repo = g.get_repo(repository) milestone = repo.get_milestone(1) labels = ["Launch Checklist"] issue = repo.create_issue("Test issue", "This is a test issue.", user, milestone, labels)
Step Three: CSV
Prerequisites • CSV file with a column of Issue names
• csv, time libraries
username = raw_input("Github username: ") pw = getpass.getpass() g =
Github(username, pw) user = g.get_user(username) repository = "dirtystylus/pygithub-sandbox" repo = g.get_repo(repository) milestone = repo.get_milestone(1) labels = ["Launch Checklist"] csv_file = "launch-checklist.csv"
with open(csv_file, 'rb') as f: reader = csv.reader(f) for row
in reader: issue = repo.create_issue("Launch Checklist: " + row[0], row[0], user, milestone, labels) print "Created issue Launch Checklist: " + row[0] time.sleep(2)
Step Four: Google Sheet
Living Documents • Launch Checklist Template item examples: ◦ Enable
caching ◦ Performance Tests (Webpagetest) ◦ Test 404 page ◦ Test 301 redirects
Prerequisites • Google Quick Start: https://developers.google.com/sheets/quickstart/python • client_secret.json • google-api-python-client
library
None
None
def get_credentials(): # Google OAuth stuff here def main(): #
Pretty much the same as before, except now we’re pulling in the spreadsheet from Google’s Sheets API and then looping through it
Example Time
None
None
None
None
None
None
Sudden-death overtime
Github + Zenhub • Zenhub (https://www.zenhub.com) • Lightweight kanban-style project
boards • Estimates, burndowns
Zenhub Board Setup • Backlog (sometimes we set up future
pipelines to reduce volume) • Ready • In Progress • Blocked • Done
None
Thank you. Mark Llobrera (@dirtystylus) Slides: https://speakerdeck.com/mllobrera/diw-2016-github-project-scaffolding-with-google-sheets-and-zenh ub Repo: https://github.com/dirtystylus/diw-2016