{"action":"created","comment":{"url":"https://api.github.com/repos/sendwithus/competencies/pulls/comments/211033647","pull_request_review_id":147381221,"id":211033647,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIxMTAzMzY0Nw==","diff_hunk":"@@ -0,0 +1,33 @@\n+# Development\n+\n+## What the script is:\n+The [Competency script](https://github.com/sendwithus/competencies/blob/master/competencySyncScript.gs) is what makes this project work. The script is written in Google Apps Script, a language based off of JavaScript that is specific to the G Suite products. The script takes configuration values from the Google Spreadsheet to which it is attached. You are free to use the script for your own projects. Follow the instructions below to start syncing your Google Drive documents to GitHub.\n+\n+## What the script does:\n+The script's job is to go through the entire process of syncing your Drive files to GitHub. It first gets the contents of all files in the configured Google Drive folders. If a file already exists in the GitHub repo, any changes will be updated, or, if the file does not exist, a new file will be created in GitHub. It then commits all new files and changed files to the specified branch name. After all commits have been made, a pull request is created to merge the branch to `master`. An email will be sent to the configured address with a link to the pull request in GitHub. Don't worry if you delete the branch after merging - the script will create it again.\n+\n+## How to use the script:\n+To use the Competency script, first create a Google Spreadsheet, following the guidelines and mock spreadsheet below. Once you have your spreadsheet set up, you will need to attach the script. In your spreadsheet, go to <b>Tools > Script editor</b> and paste in the contents of [the script](https://raw.githubusercontent.com/sendwithus/competencies/master/competencySyncScript.gs). If this is a new spreadsheet, run the `triggers()` function in your script editor. This will install the trigger in your script, which will run your script once a week. Since the script runs on a time-based trigger, the only work you have to do is merge the pull request when you get the weekly email. If you want to run the script manually, you can run `main()` in the script editor.\n+\n+|    | A                                   | B                      | C           |\n+|----|-------------------------------------|------------------------|-------|\n+| 1  | <b>Github Personal access token:</b>       |                        |\n+| 2  | *Github Personal access token**      |                        |\n+| 3  | <b>Email:</b>                              |                        |\n+| 4  | *Email address**                     |                        |\n+| 5  | <b>Repo name:</b>                          |                        |\n+| 6  | *Repo name**                         |                        |\n+| 7  | <b>Source Google Drive folder name(s):</b> |                        |\n+| 8  | *Folder name 1**                     | *Folder name 2*        |    *...*    |\n+| 9  | <b>Destination GitHub Folder Name(s):</b>  |\n+| 10 | *Folder name 1**                     | *Folder name 2*        |    *...*    |\n+| 11 | <b>Excluded File Name(s):</b>              |\n+| 12 | *Excluded file name 1*              | *Excluded file name 1* |    *...*    |\n+| 13 | <b>Branch name:</b>                        |\n+| 14 | *branch name**                       |\n+\n+<b>Notes about spreadsheet configuration:\n+- The spreadsheet must contain values for each cell in the mock spreadsheet below marked with *.\n+- The folder names in row (i.e. the contents of a Google Drive folder in row 8 will go into the GitHub folder with the name specified in the corresponding column in row 10). This means that for each value in row 8, there must be a value in the corresponding column in row 10.\n+- If a row has a cell with `...`, you can add as many values as needed to that row.\n+</b>","path":"development.md","position":33,"original_position":33,"commit_id":"ecb2c5251beb8aa308d5786470bfd165a1e2592a","original_commit_id":"ecb2c5251beb8aa308d5786470bfd165a1e2592a","user":{"login":"codeallthethingz","id":1261268,"node_id":"MDQ6VXNlcjEyNjEyNjg=","avatar_url":"https://avatars3.githubusercontent.com/u/1261268?v=4","gravatar_id":"","url":"https://api.github.com/users/codeallthethingz","html_url":"https://github.com/codeallthethingz","followers_url":"https://api.github.com/users/codeallthethingz/followers","following_url":"https://api.github.com/users/codeallthethingz/following{/other_user}","gists_url":"https://api.github.com/users/codeallthethingz/gists{/gist_id}","starred_url":"https://api.github.com/users/codeallthethingz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codeallthethingz/subscriptions","organizations_url":"https://api.github.com/users/codeallthethingz/orgs","repos_url":"https://api.github.com/users/codeallthethingz/repos","events_url":"https://api.github.com/users/codeallthethingz/events{/privacy}","received_events_url":"https://api.github.com/users/codeallthethingz/received_events","type":"User","site_admin":false},"body":"Think this `</b>` should be on line 29","created_at":"2018-08-17T21:11:39Z","updated_at":"2018-08-17T21:12:02Z","html_url":"https://github.com/sendwithus/competencies/pull/78#discussion_r211033647","pull_request_url":"https://api.github.com/repos/sendwithus/competencies/pulls/78","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/sendwithus/competencies/pulls/comments/211033647"},"html":{"href":"https://github.com/sendwithus/competencies/pull/78#discussion_r211033647"},"pull_request":{"href":"https://api.github.com/repos/sendwithus/competencies/pulls/78"}}},"pull_request":{"url":"https://api.github.com/repos/sendwithus/competencies/pulls/78","id":209242798,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA5MjQyNzk4","html_url":"https://github.com/sendwithus/competencies/pull/78","diff_url":"https://github.com/sendwithus/competencies/pull/78.diff","patch_url":"https://github.com/sendwithus/competencies/pull/78.patch","issue_url":"https://api.github.com/repos/sendwithus/competencies/issues/78","number":78,"state":"open","locked":false,"title":"Created development file.","user":{"login":"bridgetweston","id":24902441,"node_id":"MDQ6VXNlcjI0OTAyNDQx","avatar_url":"https://avatars3.githubusercontent.com/u/24902441?v=4","gravatar_id":"","url":"https://api.github.com/users/bridgetweston","html_url":"https://github.com/bridgetweston","followers_url":"https://api.github.com/users/bridgetweston/followers","following_url":"https://api.github.com/users/bridgetweston/following{/other_user}","gists_url":"https://api.github.com/users/bridgetweston/gists{/gist_id}","starred_url":"https://api.github.com/users/bridgetweston/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bridgetweston/subscriptions","organizations_url":"https://api.github.com/users/bridgetweston/orgs","repos_url":"https://api.github.com/users/bridgetweston/repos","events_url":"https://api.github.com/users/bridgetweston/events{/privacy}","received_events_url":"https://api.github.com/users/bridgetweston/received_events","type":"User","site_admin":false},"body":"","created_at":"2018-08-17T19:54:29Z","updated_at":"2018-08-17T21:12:02Z","closed_at":null,"merged_at":null,"merge_commit_sha":"8b074e1b3ba1e24d4853872a06063d6c306ea8d6","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/sendwithus/competencies/pulls/78/commits","review_comments_url":"https://api.github.com/repos/sendwithus/competencies/pulls/78/comments","review_comment_url":"https://api.github.com/repos/sendwithus/competencies/pulls/comments{/number}","comments_url":"https://api.github.com/repos/sendwithus/competencies/issues/78/comments","statuses_url":"https://api.github.com/repos/sendwithus/competencies/statuses/ecb2c5251beb8aa308d5786470bfd165a1e2592a","head":{"label":"sendwithus:documentation","ref":"documentation","sha":"ecb2c5251beb8aa308d5786470bfd165a1e2592a","user":{"login":"sendwithus","id":3197391,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMxOTczOTE=","avatar_url":"https://avatars3.githubusercontent.com/u/3197391?v=4","gravatar_id":"","url":"https://api.github.com/users/sendwithus","html_url":"https://github.com/sendwithus","followers_url":"https://api.github.com/users/sendwithus/followers","following_url":"https://api.github.com/users/sendwithus/following{/other_user}","gists_url":"https://api.github.com/users/sendwithus/gists{/gist_id}","starred_url":"https://api.github.com/users/sendwithus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sendwithus/subscriptions","organizations_url":"https://api.github.com/users/sendwithus/orgs","repos_url":"https://api.github.com/users/sendwithus/repos","events_url":"https://api.github.com/users/sendwithus/events{/privacy}","received_events_url":"https://api.github.com/users/sendwithus/received_events","type":"Organization","site_admin":false},"repo":{"id":143906095,"node_id":"MDEwOlJlcG9zaXRvcnkxNDM5MDYwOTU=","name":"competencies","full_name":"sendwithus/competencies","owner":{"login":"sendwithus","id":3197391,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMxOTczOTE=","avatar_url":"https://avatars3.githubusercontent.com/u/3197391?v=4","gravatar_id":"","url":"https://api.github.com/users/sendwithus","html_url":"https://github.com/sendwithus","followers_url":"https://api.github.com/users/sendwithus/followers","following_url":"https://api.github.com/users/sendwithus/following{/other_user}","gists_url":"https://api.github.com/users/sendwithus/gists{/gist_id}","starred_url":"https://api.github.com/users/sendwithus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sendwithus/subscriptions","organizations_url":"https://api.github.com/users/sendwithus/orgs","repos_url":"https://api.github.com/users/sendwithus/repos","events_url":"https://api.github.com/users/sendwithus/events{/privacy}","received_events_url":"https://api.github.com/users/sendwithus/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/sendwithus/competencies","description":"An open source collection of competencies","fork":false,"url":"https://api.github.com/repos/sendwithus/competencies","forks_url":"https://api.github.com/repos/sendwithus/competencies/forks","keys_url":"https://api.github.com/repos/sendwithus/competencies/keys{/key_id}","collaborators_url":"https://api.github.com/repos/sendwithus/competencies/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/sendwithus/competencies/teams","hooks_url":"https://api.github.com/repos/sendwithus/competencies/hooks","issue_events_url":"https://api.github.com/repos/sendwithus/competencies/issues/events{/number}","events_url":"https://api.github.com/repos/sendwithus/competencies/events","assignees_url":"https://api.github.com/repos/sendwithus/competencies/assignees{/user}","branches_url":"https://api.github.com/repos/sendwithus/competencies/branches{/branch}","tags_url":"https://api.github.com/repos/sendwithus/competencies/tags","blobs_url":"https://api.github.com/repos/sendwithus/competencies/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/sendwithus/competencies/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/sendwithus/competencies/git/refs{/sha}","trees_url":"https://api.github.com/repos/sendwithus/competencies/git/trees{/sha}","statuses_url":"https://api.github.com/repos/sendwithus/competencies/statuses/{sha}","languages_url":"https://api.github.com/repos/sendwithus/competencies/languages","stargazers_url":"https://api.github.com/repos/sendwithus/competencies/stargazers","contributors_url":"https://api.github.com/repos/sendwithus/competencies/contributors","subscribers_url":"https://api.github.com/repos/sendwithus/competencies/subscribers","subscription_url":"https://api.github.com/repos/sendwithus/competencies/subscription","commits_url":"https://api.github.com/repos/sendwithus/competencies/commits{/sha}","git_commits_url":"https://api.github.com/repos/sendwithus/competencies/git/commits{/sha}","comments_url":"https://api.github.com/repos/sendwithus/competencies/comments{/number}","issue_comment_url":"https://api.github.com/repos/sendwithus/competencies/issues/comments{/number}","contents_url":"https://api.github.com/repos/sendwithus/competencies/contents/{+path}","compare_url":"https://api.github.com/repos/sendwithus/competencies/compare/{base}...{head}","merges_url":"https://api.github.com/repos/sendwithus/competencies/merges","archive_url":"https://api.github.com/repos/sendwithus/competencies/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/sendwithus/competencies/downloads","issues_url":"https://api.github.com/repos/sendwithus/competencies/issues{/number}","pulls_url":"https://api.github.com/repos/sendwithus/competencies/pulls{/number}","milestones_url":"https://api.github.com/repos/sendwithus/competencies/milestones{/number}","notifications_url":"https://api.github.com/repos/sendwithus/competencies/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/sendwithus/competencies/labels{/name}","releases_url":"https://api.github.com/repos/sendwithus/competencies/releases{/id}","deployments_url":"https://api.github.com/repos/sendwithus/competencies/deployments","created_at":"2018-08-07T17:28:13Z","updated_at":"2018-08-17T17:04:53Z","pushed_at":"2018-08-17T20:55:50Z","git_url":"git://github.com/sendwithus/competencies.git","ssh_url":"git@github.com:sendwithus/competencies.git","clone_url":"https://github.com/sendwithus/competencies.git","svn_url":"https://github.com/sendwithus/competencies","homepage":null,"size":231,"stargazers_count":1,"watchers_count":1,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":1,"license":{"key":"mit","name":"MIT License","spdx_id":"MIT","url":"https://api.github.com/licenses/mit","node_id":"MDc6TGljZW5zZTEz"},"forks":0,"open_issues":1,"watchers":1,"default_branch":"master"}},"base":{"label":"sendwithus:master","ref":"master","sha":"8b8df09ac72bf560600f00bec9ebf75181b3997b","user":{"login":"sendwithus","id":3197391,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMxOTczOTE=","avatar_url":"https://avatars3.githubusercontent.com/u/3197391?v=4","gravatar_id":"","url":"https://api.github.com/users/sendwithus","html_url":"https://github.com/sendwithus","followers_url":"https://api.github.com/users/sendwithus/followers","following_url":"https://api.github.com/users/sendwithus/following{/other_user}","gists_url":"https://api.github.com/users/sendwithus/gists{/gist_id}","starred_url":"https://api.github.com/users/sendwithus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sendwithus/subscriptions","organizations_url":"https://api.github.com/users/sendwithus/orgs","repos_url":"https://api.github.com/users/sendwithus/repos","events_url":"https://api.github.com/users/sendwithus/events{/privacy}","received_events_url":"https://api.github.com/users/sendwithus/received_events","type":"Organization","site_admin":false},"repo":{"id":143906095,"node_id":"MDEwOlJlcG9zaXRvcnkxNDM5MDYwOTU=","name":"competencies","full_name":"sendwithus/competencies","owner":{"login":"sendwithus","id":3197391,"node_id":"MDEyOk9yZ2FuaXphdGlvbjMxOTczOTE=","avatar_url":"https://avatars3.githubusercontent.com/u/3197391?v=4","gravatar_id":"","url":"https://api.github.com/users/sendwithus","html_url":"https://github.com/sendwithus","followers_url":"https://api.github.com/users/sendwithus/followers","following_url":"https://api.github.com/users/sendwithus/following{/other_user}","gists_url":"https://api.github.com/users/sendwithus/gists{/gist_id}","starred_url":"https://api.github.com/users/sendwithus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sendwithus/subscriptions","organizations_url":"https://api.github.com/users/sendwithus/orgs","repos_url":"https://api.github.com/users/sendwithus/repos","events_url":"https://api.github.com/users/sendwithus/events{/privacy}","received_events_url":"https://api.github.com/users/sendwithus/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/sendwithus/competencies","description":"An open source collection of competencies","fork":false,"url":"https://api.github.com/repos/sendwithus/competencies","forks_url":"https://api.github.com/repos/sendwithus/competencies/forks","keys_url":"https://api.github.com/repos/sendwithus/competencies/keys{/key_id}","collaborators_url":"https://api.github.com/repos/sendwithus/competencies/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/sendwithus/competencies/teams","hooks_url":"https://api.github.com/repos/sendwithus/competencies/hooks","issue_events_url":"https://api.github.com/repos/sendwithus/competencies/issues/events{/number}","events_url":"https://api.github.com/repos/sendwithus/competencies/events","assignees_url":"https://api.github.com/repos/sendwithus/competencies/assignees{/user}","branches_url":"https://api.github.com/repos/sendwithus/competencies/branches{/branch}","tags_url":"https://api.github.com/repos/sendwithus/competencies/tags","blobs_url":"https://api.github.com/repos/sendwithus/competencies/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/sendwithus/competencies/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/sendwithus/competencies/git/refs{/sha}","trees_url":"https://api.github.com/repos/sendwithus/competencies/git/trees{/sha}","statuses_url":"https://api.github.com/repos/sendwithus/competencies/statuses/{sha}","languages_url":"https://api.github.com/repos/sendwithus/competencies/languages","stargazers_url":"https://api.github.com/repos/sendwithus/competencies/stargazers","contributors_url":"https://api.github.com/repos/sendwithus/competencies/contributors","subscribers_url":"https://api.github.com/repos/sendwithus/competencies/subscribers","subscription_url":"https://api.github.com/repos/sendwithus/competencies/subscription","commits_url":"https://api.github.com/repos/sendwithus/competencies/commits{/sha}","git_commits_url":"https://api.github.com/repos/sendwithus/competencies/git/commits{/sha}","comments_url":"https://api.github.com/repos/sendwithus/competencies/comments{/number}","issue_comment_url":"https://api.github.com/repos/sendwithus/competencies/issues/comments{/number}","contents_url":"https://api.github.com/repos/sendwithus/competencies/contents/{+path}","compare_url":"https://api.github.com/repos/sendwithus/competencies/compare/{base}...{head}","merges_url":"https://api.github.com/repos/sendwithus/competencies/merges","archive_url":"https://api.github.com/repos/sendwithus/competencies/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/sendwithus/competencies/downloads","issues_url":"https://api.github.com/repos/sendwithus/competencies/issues{/number}","pulls_url":"https://api.github.com/repos/sendwithus/competencies/pulls{/number}","milestones_url":"https://api.github.com/repos/sendwithus/competencies/milestones{/number}","notifications_url":"https://api.github.com/repos/sendwithus/competencies/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/sendwithus/competencies/labels{/name}","releases_url":"https://api.github.com/repos/sendwithus/competencies/releases{/id}","deployments_url":"https://api.github.com/repos/sendwithus/competencies/deployments","created_at":"2018-08-07T17:28:13Z","updated_at":"2018-08-17T17:04:53Z","pushed_at":"2018-08-17T20:55:50Z","git_url":"git://github.com/sendwithus/competencies.git","ssh_url":"git@github.com:sendwithus/competencies.git","clone_url":"https://github.com/sendwithus/competencies.git","svn_url":"https://github.com/sendwithus/competencies","homepage":null,"size":231,"stargazers_count":1,"watchers_count":1,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":1,"license":{"key":"mit","name":"MIT License","spdx_id":"MIT","url":"https://api.github.com/licenses/mit","node_id":"MDc6TGljZW5zZTEz"},"forks":0,"open_issues":1,"watchers":1,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/sendwithus/competencies/pulls/78"},"html":{"href":"https://github.com/sendwithus/competencies/pull/78"},"issue":{"href":"https://api.github.com/repos/sendwithus/competencies/issues/78"},"comments":{"href":"https://api.github.com/repos/sendwithus/competencies/issues/78/comments"},"review_comments":{"href":"https://api.github.com/repos/sendwithus/competencies/pulls/78/comments"},"review_comment":{"href":"https://api.github.com/repos/sendwithus/competencies/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/sendwithus/competencies/pulls/78/commits"},"statuses":{"href":"https://api.github.com/repos/sendwithus/competencies/statuses/ecb2c5251beb8aa308d5786470bfd165a1e2592a"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"codeallthethingz"}}