Yes, it is possible to automate the service discovery of target nodes in Prometheus and Grafana. With static configuration, the target nodes and the accompanying metrics endpoints are manually entered into a configuration file.
However, Prometheus provides additional service discovery methods that can be automated. These methods include file-based service discovery, DNS-based service discovery, and integration with popular orchestration systems like Kubernetes. These automated service discovery methods allow Prometheus to dynamically discover and monitor new nodes as they are added or removed from the environment.