It is no longer possible to pull option chain data directly from the NSE website to Google Sheets (Refer to Option data importing from google finance (open interest & implied volatility)). You can still pull data from the NSE website but it requires your own server (Refer to Option Chain API). The alternative is pulling data from 3rd party sources (like suggested in the above answer). In case you are interested, there is a video explaining how to pull option chain data from Moneycontrol and updating it at regular interval -
