If you use single ships instead of a carrier based survey force, much of the process you describe can already be automated.
I often use larger survey vessels and the only thing one has to do manually is to send them to overhaul (every 5-10 years is what I aim for), once their deployment time is exceeded and to send ships through unexplored JPs. Also ground based survey, but that is something I rarely do to every suitable body (which there are only a few of).
I use the standing orders: "Survey location"/"Survey bodies" and "Go to System needing Grav/Geosurvey" with conditional orders Refuel, when fuel <30-50% and resupply, when MSP <20%.
A pair (geo and grav) of these ships surveys every system you have discovered. It doesn't need special player attention apart from hostile contact, overhaul once or twice an decade and manual orders(or help from a specialised fleet) to explore new jumppoints.
Some of my empires do this with special geo/grav vessels, other use general survey vessel which can easily switch roles if the demand for grav/geo surveys changes. Some empires use jumpcapable ships, other give the role of exploring JPs to stabilisation ships or jump tenders.