search

emmtte / list

Google Sheets automatic creation with Google Apps Script (GAS) for managing a cryptocurrency tracking spreadsheet with multi exchanges
262 stars 77 forks source link

sheet.addMenu #12

Closed cryptoTrader9000 closed 6 years ago

cryptoTrader9000 commented 6 years ago

Hello, When trying to run the function onOpen I get the error: TypeError: Cannot call method "addMenu" of null. (line 6, file "Code"). I have a spreadsheet opened with two tabs, one being Market and the other Config. Config has my API keys in B14 and 15.
Thanks.

cryptoTrader9000 commented 6 years ago

Also, in the binance function I get TypeError: Cannot call method "getSheetByName" of null. (line 4, file "binance").

emmtte commented 6 years ago

Hi, I think you're on the wrong way. When you do Click Tools > Script editor... Create script file with File > New > Script file Copy and paste the contents of main.js and save. You need to do this in google sheet, not in google drive. The script editor from google drive not working the same as google sheet script editor. Please control that point it's should be work

cryptoTrader9000 commented 6 years ago

It works now. Thank you!