"dotenv.load() is not a function" while trying to run a Node script

Based on NPM documentation you should use dotenv.config().

This worked for me:

require('dotenv').config({path:'my-app/.env'});

I right-clicked on the .env file to get the relative path.