Sometimes you open you Google Sheets document and you navigate to to Add-ons-> MySalesData for Salesforce
and see only HELP button under the add-on menu.
The solution to fix the issue is to navigate to Add-ons->Manage add-ons
And then remove the add-on
and than add it again
More details how to install MySalesData for Salesforce one can find in this post