Can I control which spreadsheets the add-on has access to?

Absolutely. Mail My Sheets only accesses the spreadsheet where it’s installed and launched – it doesn’t scan or access your entire Drive.