TypeError: cannot call method "getRange" of null

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

This topic contains 9 replies, has 2 voices, and was last updated by  michelleganz 4 years, 4 months ago.

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.