Thanks but i am having a error when i run the script it shows me TypeError: Cannot read property 'getDataRange' of null. I have verified that I am using the correct spreadsheet name. You have any idea as to what maybe happening? I have just removed the mail function and rest is same
Thanks but i am having a error when i run the script it shows me TypeError: Cannot read property 'getDataRange' of null. I have verified that I am using the correct spreadsheet name. You have any idea as to what maybe happening? I have just removed the mail function and rest is same
Make sure your sheet name is called Websites.