Update on June 27'th 2018:
Google has managed to sort this issue and Supermetrics for Google Sheets add-on is working again.
Supermetrics add-on is currently not available in Google Sheets or in the Chrome Store. We are working with Google to resolve it. We will update the situation here as soon as the Add-on has been restored. We're terribly sorry for all the inconvenience this has caused.