Use a Google Form to let people add new entries to your spreadsheet




  • Avatar
    Fev Ramireli

    I'm trying to use your script but I keep getting the same error in line 7:

    var data = sheet.getDataRange().getValues();

    getDataRange null

    I already checked and double checked the variable sheetName, but since I just inserted the code and I'm by no means a coder or programmer, I don't know what to do.

    Attached a ss for more deatail

  • Avatar
    Awesome Table

    Hello Fav Ramireli,

    Could you create a ticket for your issue? Please, share your view and your spreadsheet.
    Make sure you also give access your spreadsheet at "". 

    Thanks in advance.


  • Avatar
    Fev Ramireli

    Thank you for the follow up, my Awesome Table its working like a charm.

  • Avatar

    On function geteditresponseurl line

    var columnIndex = SpreadsheetApp.getActiveSpreadsheet().getRangeByName("Update").getColumn().toString();

    I'm getting

    TypeError: Cannot call method "getColumn" of null. (line 36, file "Code")

  • Avatar
    Thomas Morin

    Hello Bill,

    You need to reproduce the exact code we mention in the article above. Your code is not the same in this article.

    The var columnIndex allows you to attribute the column where you want to put the link like this:

    var columnIndex = 8 ;

    Finally, the var sheet must be like this:

    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);

    Please, apply identically the code we provide in this article and your view should work.

    Thank you for your understanding.


Please sign in to leave a comment.