Franklin Silveira Baldo franklinbaldo

## google-form-to-github-issue.md

      
              1 file
            
          
              16 forks
            
          
              21 comments
            
          
              78 stars
            
          
                bmcbride
                / google-form-to-github-issue.md
            
            
              Last active
              April 5, 2024 15:47
            
              
                Create a new GitHub Issue from a Google Form submission
              
          
    Wiring up a Google Form to GitHub is not that difficult with a little bit of Apps Script automation. All you need is a Google account, a GitHub account, and a web browser...
Set up your GitHub Personal Access Token

Personal access tokens provide an easy way to interact with the GitHub API without having to mess with OAuth. If you don't already have a personal access token with repo or public_repo access, visit your GitHub settings page and generate a new token.
Be sure to copy your token some place safe and keep it secure. Once generated, you will not be able to view or copy the token again.
Set up the Form & Spreadsheet


Create a Google Form.


## Apps Script Code - Copy the edit response link from Google Forms entries into a Google Sheet
function assignEditUrls() {
  var form = FormApp.openById('yourFormKey');
    //enter form ID here

  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('yourWorksheetName');

    //Change the sheet name as appropriate
  var data = sheet.getDataRange().getValues();
  var urlCol = ; // column number where URL's should be populated; A = 1, B = 2 etc
  var responses = form.getResponses();

## index.html
<html><head><title>Google Spreadsheet Explorer</title>

<script type="text/javascript" src="//www.google.com/jsapi"></script>
<script type="text/javascript">
  google.load('visualization', '1', {'packages':['table', 'scatterchart', 'linechart','piechart', 'barchart','columnchart']});


function removeChildrenFromNode(node) {
    if(node.hasChildNodes()) {
        while(node.childNodes.length >= 1 ) {
	function assignEditUrls() {
	var form = FormApp.openById('yourFormKey');
	//enter form ID here

	var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('yourWorksheetName');

	//Change the sheet name as appropriate
	var data = sheet.getDataRange().getValues();
	var urlCol = ; // column number where URL's should be populated; A = 1, B = 2 etc
	var responses = form.getResponses();
	<html><head><title>Google Spreadsheet Explorer</title>

	<script type="text/javascript" src="//www.google.com/jsapi"></script>
	<script type="text/javascript">
	google.load('visualization', '1', {'packages':['table', 'scatterchart', 'linechart','piechart', 'barchart','columnchart']});


	function removeChildrenFromNode(node) {
	if(node.hasChildNodes()) {
	while(node.childNodes.length >= 1 ) {