Tagged: error; typeerror; getRange; null
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?
Hi michelle – if you start a fresh archive do you get the same error?
I do 🙁
… also other than setting the search term have you changed anything else like sheet names
still an issue if you rerun the setup?
I’ve got multiple sheets. should I delete them all and start over again?
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
I renamed the new sheets so I could keep track of them. is that where the problem is coming from???
Yes the script doesn’t currently handle renamed sheets. Defaulting back to the original sheet names should fix it.
Huzzah! I deleted all my sheets and started over again and it’s working perfectly now! Thanks so much for all your help 🙂
You must be logged in to reply to this topic.