Since version 1.0.0, the plugin works with a dedicated code environment.
You need to make sure that:
1. The dedicated code env is created.
In DSS 5.1, it looks like this:
2. The code env has been set-up (dependencies are installed).
You can check and rebuild in Administration > Code Envs > plugin_googlesheets_managed
I hope it will solve your issue.