jmcmurry

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

jmcmurry

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

jmcmurry

license: gpl-3.0

jmcmurry

license: gpl-3.0

jmcmurry

license: mit

jmcmurry

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

jmcmurry

license: gpl-3.0
height: 600

jmcmurry

license: gpl-3.0
height: 600

jmcmurry

license: gpl-3.0
height: 600

jmcmurry