{"action":"created","comment":{"url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/comments/131767528","pull_request_review_id":54779079,"id":131767528,"diff_hunk":"@@ -63,7 +63,21 @@ Screenshot:\n ![screenshot](screenshot.png)\n \n \n-## Creating Tasking Sheets\n+## Google Sheets (Tasking and Significant Changes)\n+\n+The analysis UI keeps some data and runtime configuration separate from the public web monitoring database ([`web-monitoring-db`](http://github.com/edgi-govdata-archiving/web-monitoring-db)). This data is kept in 3 Google Docs spreadsheets. You can use the UI without configuring them, but you will be missing some functionality.\n+\n+First, you’ll need to create a *service account* the application can use to access the sheets. To do so, follow the first half of [this tutorial](http://isd-soft.com/tech_blog/accessing-google-apis-using-service-account-node-js/). During the process, you should have downloaded a `.json` file with authentication information. Add the `client_email` and `private_key` fields from the file to you `.env` file:\n+\n+```sh\n+GOOGLE_SERVICE_CLIENT_EMAIL=73874number-example@developer.gserviceaccount.com\n+GOOGLE_SHEETS_PRIVATE_KEY=-----BEGIN PRIVATE KEY-----\\EXAMPLEExampleG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCsBjS7qpN+vUhz\\nXRhcL3pwKZtewjZ478rs7FylT+YAJMmy1wOS3ze2FVYaBHelloFromXm9gL82OCSJn1ZThePastuwGA0\\npe9oZSAtiB4ujaHhcWCO7ZYZzBvsPRJZR2eo4UokDpmgAS9ExTU7zN+eKTBTFGB4\\nKDc7FAxqhk9dBcYFpLU34wuQsS/SZY1j3I/pmqQ7CHnGG+KLhyRiZ6UvlT8KjWejWTFdfMoredksjfGibberishkljfkls+\\nkerGibberishll7\\n7oU0VVs3xY5nhkjd#r34jkd7vxjknfy3jsdhf5zjkGYfyXFNhVjsl/bJ3AHA/C9Fd5z9JmOCsZE\\nyD9Yjy72C50CjOgCp568pse85A==\\n-----END PRIVATE KEY-----\\n\n+```\n+\n+In the next two sections, you’ll create the 3 sheets.\n+\n+\n+### Creating Tasking Sheets\n \n User tasking data (analysis timeframes, who is assigned what domains and pages, etc.) is currently kept in a Google Docs spreadsheet for easy manipulation by project admins. To enable tasking in your local build, you’ll need to create your own copy of this spreadsheet.\n ","path":"README.md","position":31,"original_position":31,"commit_id":"fc0ad52700bf6ae5a4b3406bc6c10a299a0ac918","original_commit_id":"dd107cd7167c7ef3a9fc92d3a8202df8f9cdbe78","user":{"login":"Mr0grog","id":74178,"avatar_url":"https://avatars0.githubusercontent.com/u/74178?v=4","gravatar_id":"","url":"https://api.github.com/users/Mr0grog","html_url":"https://github.com/Mr0grog","followers_url":"https://api.github.com/users/Mr0grog/followers","following_url":"https://api.github.com/users/Mr0grog/following{/other_user}","gists_url":"https://api.github.com/users/Mr0grog/gists{/gist_id}","starred_url":"https://api.github.com/users/Mr0grog/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mr0grog/subscriptions","organizations_url":"https://api.github.com/users/Mr0grog/orgs","repos_url":"https://api.github.com/users/Mr0grog/repos","events_url":"https://api.github.com/users/Mr0grog/events{/privacy}","received_events_url":"https://api.github.com/users/Mr0grog/received_events","type":"User","site_admin":false},"body":"Done. How’s the change look to you, @lightandluck?","created_at":"2017-08-07T21:25:26Z","updated_at":"2017-08-07T21:25:26Z","html_url":"https://github.com/edgi-govdata-archiving/web-monitoring-ui/pull/94#discussion_r131767528","pull_request_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/94","_links":{"self":{"href":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/comments/131767528"},"html":{"href":"https://github.com/edgi-govdata-archiving/web-monitoring-ui/pull/94#discussion_r131767528"},"pull_request":{"href":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/94"}}},"pull_request":{"url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/94","id":130925626,"html_url":"https://github.com/edgi-govdata-archiving/web-monitoring-ui/pull/94","diff_url":"https://github.com/edgi-govdata-archiving/web-monitoring-ui/pull/94.diff","patch_url":"https://github.com/edgi-govdata-archiving/web-monitoring-ui/pull/94.patch","issue_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/issues/94","number":94,"state":"open","locked":false,"title":"ENH: 86-send important changes to sheets","user":{"login":"lightandluck","id":3014813,"avatar_url":"https://avatars1.githubusercontent.com/u/3014813?v=4","gravatar_id":"","url":"https://api.github.com/users/lightandluck","html_url":"https://github.com/lightandluck","followers_url":"https://api.github.com/users/lightandluck/followers","following_url":"https://api.github.com/users/lightandluck/following{/other_user}","gists_url":"https://api.github.com/users/lightandluck/gists{/gist_id}","starred_url":"https://api.github.com/users/lightandluck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lightandluck/subscriptions","organizations_url":"https://api.github.com/users/lightandluck/orgs","repos_url":"https://api.github.com/users/lightandluck/repos","events_url":"https://api.github.com/users/lightandluck/events{/privacy}","received_events_url":"https://api.github.com/users/lightandluck/received_events","type":"User","site_admin":false},"body":"~**WIP - DO NOT MERGE**~ Now ready for review & merging.\r\n\r\nHi guys, sorry I didn't make as much progress on this as I would have liked. But was able to create a function that appends records to the spreadsheets from the server. The meat of this WIP are the instructions in the README on how to setup Google service client account and` addRowGoogleSheet` in `sheet-data.js.` Also, new .env variable to hold all the required information.\r\n\r\nI wasn't able to hook things up on the React side. Unfortunately, I'm just too inexperienced with Node, React, and Typescript and with all the different PR's that haven't been merged, I couldn't figure out how to do it without mucking things up. That said, I believe the functionality is here, and what's left is just wiring things together properly. HTH\r\n\r\nFixes #38, fixes #86.","created_at":"2017-07-17T18:53:53Z","updated_at":"2017-08-07T21:25:26Z","closed_at":null,"merged_at":null,"merge_commit_sha":"929f7e77c7814a332af253788cbfd87bad9d1ab3","assignee":null,"assignees":[],"requested_reviewers":[],"milestone":null,"commits_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/94/commits","review_comments_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/94/comments","review_comment_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/comments{/number}","comments_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/issues/94/comments","statuses_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/statuses/fc0ad52700bf6ae5a4b3406bc6c10a299a0ac918","head":{"label":"lightandluck:86-send-important-changes-to-sheets","ref":"86-send-important-changes-to-sheets","sha":"fc0ad52700bf6ae5a4b3406bc6c10a299a0ac918","user":{"login":"lightandluck","id":3014813,"avatar_url":"https://avatars1.githubusercontent.com/u/3014813?v=4","gravatar_id":"","url":"https://api.github.com/users/lightandluck","html_url":"https://github.com/lightandluck","followers_url":"https://api.github.com/users/lightandluck/followers","following_url":"https://api.github.com/users/lightandluck/following{/other_user}","gists_url":"https://api.github.com/users/lightandluck/gists{/gist_id}","starred_url":"https://api.github.com/users/lightandluck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lightandluck/subscriptions","organizations_url":"https://api.github.com/users/lightandluck/orgs","repos_url":"https://api.github.com/users/lightandluck/repos","events_url":"https://api.github.com/users/lightandluck/events{/privacy}","received_events_url":"https://api.github.com/users/lightandluck/received_events","type":"User","site_admin":false},"repo":{"id":81688638,"name":"web-monitoring-ui","full_name":"lightandluck/web-monitoring-ui","owner":{"login":"lightandluck","id":3014813,"avatar_url":"https://avatars1.githubusercontent.com/u/3014813?v=4","gravatar_id":"","url":"https://api.github.com/users/lightandluck","html_url":"https://github.com/lightandluck","followers_url":"https://api.github.com/users/lightandluck/followers","following_url":"https://api.github.com/users/lightandluck/following{/other_user}","gists_url":"https://api.github.com/users/lightandluck/gists{/gist_id}","starred_url":"https://api.github.com/users/lightandluck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lightandluck/subscriptions","organizations_url":"https://api.github.com/users/lightandluck/orgs","repos_url":"https://api.github.com/users/lightandluck/repos","events_url":"https://api.github.com/users/lightandluck/events{/privacy}","received_events_url":"https://api.github.com/users/lightandluck/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/lightandluck/web-monitoring-ui","description":"Website Monitoring project: enable analysts to quickly assess changes to monitored government websites","fork":true,"url":"https://api.github.com/repos/lightandluck/web-monitoring-ui","forks_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/forks","keys_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/keys{/key_id}","collaborators_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/teams","hooks_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/hooks","issue_events_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/issues/events{/number}","events_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/events","assignees_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/assignees{/user}","branches_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/branches{/branch}","tags_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/tags","blobs_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/git/refs{/sha}","trees_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/git/trees{/sha}","statuses_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/statuses/{sha}","languages_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/languages","stargazers_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/stargazers","contributors_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/contributors","subscribers_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/subscribers","subscription_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/subscription","commits_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/commits{/sha}","git_commits_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/git/commits{/sha}","comments_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/comments{/number}","issue_comment_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/issues/comments{/number}","contents_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/contents/{+path}","compare_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/compare/{base}...{head}","merges_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/merges","archive_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/downloads","issues_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/issues{/number}","pulls_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/pulls{/number}","milestones_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/milestones{/number}","notifications_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/labels{/name}","releases_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/releases{/id}","deployments_url":"https://api.github.com/repos/lightandluck/web-monitoring-ui/deployments","created_at":"2017-02-11T23:04:49Z","updated_at":"2017-08-03T22:09:58Z","pushed_at":"2017-08-07T21:22:55Z","git_url":"git://github.com/lightandluck/web-monitoring-ui.git","ssh_url":"git@github.com:lightandluck/web-monitoring-ui.git","clone_url":"https://github.com/lightandluck/web-monitoring-ui.git","svn_url":"https://github.com/lightandluck/web-monitoring-ui","homepage":"","size":1622,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"edgi-govdata-archiving:master","ref":"master","sha":"9fa2a2e325ca28b823d397c009b707e4edbe6914","user":{"login":"edgi-govdata-archiving","id":24626991,"avatar_url":"https://avatars0.githubusercontent.com/u/24626991?v=4","gravatar_id":"","url":"https://api.github.com/users/edgi-govdata-archiving","html_url":"https://github.com/edgi-govdata-archiving","followers_url":"https://api.github.com/users/edgi-govdata-archiving/followers","following_url":"https://api.github.com/users/edgi-govdata-archiving/following{/other_user}","gists_url":"https://api.github.com/users/edgi-govdata-archiving/gists{/gist_id}","starred_url":"https://api.github.com/users/edgi-govdata-archiving/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edgi-govdata-archiving/subscriptions","organizations_url":"https://api.github.com/users/edgi-govdata-archiving/orgs","repos_url":"https://api.github.com/users/edgi-govdata-archiving/repos","events_url":"https://api.github.com/users/edgi-govdata-archiving/events{/privacy}","received_events_url":"https://api.github.com/users/edgi-govdata-archiving/received_events","type":"Organization","site_admin":false},"repo":{"id":80731634,"name":"web-monitoring-ui","full_name":"edgi-govdata-archiving/web-monitoring-ui","owner":{"login":"edgi-govdata-archiving","id":24626991,"avatar_url":"https://avatars0.githubusercontent.com/u/24626991?v=4","gravatar_id":"","url":"https://api.github.com/users/edgi-govdata-archiving","html_url":"https://github.com/edgi-govdata-archiving","followers_url":"https://api.github.com/users/edgi-govdata-archiving/followers","following_url":"https://api.github.com/users/edgi-govdata-archiving/following{/other_user}","gists_url":"https://api.github.com/users/edgi-govdata-archiving/gists{/gist_id}","starred_url":"https://api.github.com/users/edgi-govdata-archiving/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/edgi-govdata-archiving/subscriptions","organizations_url":"https://api.github.com/users/edgi-govdata-archiving/orgs","repos_url":"https://api.github.com/users/edgi-govdata-archiving/repos","events_url":"https://api.github.com/users/edgi-govdata-archiving/events{/privacy}","received_events_url":"https://api.github.com/users/edgi-govdata-archiving/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/edgi-govdata-archiving/web-monitoring-ui","description":"UI to enable analysts to quickly assess changes to monitored government websites","fork":false,"url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui","forks_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/forks","keys_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/keys{/key_id}","collaborators_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/teams","hooks_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/hooks","issue_events_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/issues/events{/number}","events_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/events","assignees_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/assignees{/user}","branches_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/branches{/branch}","tags_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/tags","blobs_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/git/refs{/sha}","trees_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/git/trees{/sha}","statuses_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/statuses/{sha}","languages_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/languages","stargazers_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/stargazers","contributors_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/contributors","subscribers_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/subscribers","subscription_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/subscription","commits_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/commits{/sha}","git_commits_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/git/commits{/sha}","comments_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/comments{/number}","issue_comment_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/issues/comments{/number}","contents_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/contents/{+path}","compare_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/compare/{base}...{head}","merges_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/merges","archive_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/downloads","issues_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/issues{/number}","pulls_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls{/number}","milestones_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/milestones{/number}","notifications_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/labels{/name}","releases_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/releases{/id}","deployments_url":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/deployments","created_at":"2017-02-02T14:16:42Z","updated_at":"2017-08-01T04:20:40Z","pushed_at":"2017-08-07T21:22:56Z","git_url":"git://github.com/edgi-govdata-archiving/web-monitoring-ui.git","ssh_url":"git@github.com:edgi-govdata-archiving/web-monitoring-ui.git","clone_url":"https://github.com/edgi-govdata-archiving/web-monitoring-ui.git","svn_url":"https://github.com/edgi-govdata-archiving/web-monitoring-ui","homepage":"","size":1204,"stargazers_count":9,"watchers_count":9,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":17,"mirror_url":null,"open_issues_count":26,"forks":17,"open_issues":26,"watchers":9,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/94"},"html":{"href":"https://github.com/edgi-govdata-archiving/web-monitoring-ui/pull/94"},"issue":{"href":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/issues/94"},"comments":{"href":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/issues/94/comments"},"review_comments":{"href":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/94/comments"},"review_comment":{"href":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/pulls/94/commits"},"statuses":{"href":"https://api.github.com/repos/edgi-govdata-archiving/web-monitoring-ui/statuses/fc0ad52700bf6ae5a4b3406bc6c10a299a0ac918"}}}}
{"actor":{"display_login":"Mr0grog"}}