TypeError: cannot call method "getRange" of null

Home Forums Basic setup TypeError: cannot call method "getRange" of null

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #816
    michelleganz
    Participant

    I set up my sheet according to the directions and was able to run it successfully. But it hasn’t pulled any new tweets in spite of being set up to pull every hour. When I try to run now I get the following error message:

    TypeError: Cannot call method “getRange” of null

    Any way to fix this?

    #822
    mhawksey
    Keymaster

    Hi michelle – if you start a fresh archive do you get the same error?

    #823
    michelleganz
    Participant

    I do 🙁

    #824
    mhawksey
    Keymaster

    … also other than setting the search term have you changed anything else like sheet names

    #825
    mhawksey
    Keymaster

    still an issue if you rerun the setup?

    #826
    michelleganz
    Participant

    I’ve got multiple sheets. should I delete them all and start over again?

    #827
    mhawksey
    Keymaster

    If rerunning the setup works on one sheet the others should cover back to life.

    Also to confirm within the spreadsheet the sheet names are unchanged

    #828
    michelleganz
    Participant

    I renamed the new sheets so I could keep track of them. is that where the problem is coming from???

    #829
    mhawksey
    Keymaster

    Yes the script doesn’t currently handle renamed sheets. Defaulting back to the original sheet names should fix it.

    #830
    michelleganz
    Participant

    Huzzah! I deleted all my sheets and started over again and it’s working perfectly now! Thanks so much for all your help 🙂

Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.