Google Add-ons has a core problem of randomly deactivating triggers associated with the automatic imports. We are aware of this problem and are working to solve it. To re-activate the automatic import you just need to open Import Sheet sidebar by selecting the spreadsheet Menu: Add-Ons -> Import Sheet -> Manage Connections.
Have more questions? Submit a request