Julie McMurry jmcmurry

## gGroupMembersToGSheet.gs
// Note: API must be enabled before use.
// the person running the script needs to authorize the script AND from an email address that is listed as an administrator or owner on the group.

function main(){

  // Destination sheet of members
    var ss = SpreadsheetApp.openByUrl('SOMEURL');

  //array of emails; here I fetch them from the a named range in the above spreadsheet, but they could be hardcoded as an array
  var groupEmails = ss.getRangeByName("listOfGroups").getValues();

## 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();

## .block
license: gpl-3.0

## .block
license: gpl-3.0

## .block
license: mit

## License.txt
This is free and unencumbered software released into the public domain.

Anyone is free to copy, modify, publish, use, compile, sell, or
distribute this software, either in source code form or as a compiled
binary, for any purpose, commercial or non-commercial, and by any
means.

In jurisdictions that recognize copyright laws, the author or authors
of this software dedicate any and all copyright interest in the
software to the public domain. We make this dedication for the benefit

## .block
license: gpl-3.0
height: 600

## .block
license: gpl-3.0
height: 600

## .block
license: gpl-3.0
height: 600

## test.csv

          
            source
            target
            value

            
              lead_15
              S
              300

            
              lead_15
              N
              700

            
              S
              INIB
              150

            
              S
              N_INIB
              150

            
              INIB
              INIB_A
              50

            
              INIB
              INIB_B
              50

            
              INIB
              INIB_C
              50

            
              N
              PAGOU
              500

            
              PAGOU
              ESPONTANEO
              300
	// Note: API must be enabled before use.
	// the person running the script needs to authorize the script AND from an email address that is listed as an administrator or owner on the group.

	function main(){

	// Destination sheet of members
	var ss = SpreadsheetApp.openByUrl('SOMEURL');

	//array of emails; here I fetch them from the a named range in the above spreadsheet, but they could be hardcoded as an array
	var groupEmails = ss.getRangeByName("listOfGroups").getValues();
	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();
	This is free and unencumbered software released into the public domain.

	Anyone is free to copy, modify, publish, use, compile, sell, or
	distribute this software, either in source code form or as a compiled
	binary, for any purpose, commercial or non-commercial, and by any
	means.

	In jurisdictions that recognize copyright laws, the author or authors
	of this software dedicate any and all copyright interest in the
	software to the public domain. We make this dedication for the benefit
source	target	value
lead_15	S	300
lead_15	N	700
S	INIB	150
S	N_INIB	150
INIB	INIB_A	50
INIB	INIB_B	50
INIB	INIB_C	50
N	PAGOU	500
PAGOU	ESPONTANEO	300