The integral appearing here is the so-called logistic-normal integral. Denoting it as
\begin{equation}
\varphi(\mu,\sigma) = \frac{1}{\sqrt{2\pi\sigma^2}}\int_{-\infty}^\infty \frac{1}{1+e^{-x}} e^{-\frac{1}{2\sigma^2}(x-\mu)^2}
\end{equation}
then one needs to solve the equation $\varphi(\mu,\sigma) = \bar Y$. One must assume that $\sigma$ is known in order to be able to solve this equation.
One can show that $\varphi(\mu,\sigma)$ can be computed exactly at $\mu = 0, \pm \sigma^2, \pm 2 \sigma^2, \cdots $. This was shown in Pirjol (2013).
(The integral is a limiting case of the Mordell integral from analytic number theory, and has many surprising symmetry properties.)
Then it is just a matter of bracketing $\bar Y$ between two points on the grid of spacing $\sigma^2$, and solving for $\mu$.
References
Pirjol, D. (2013). "The logistic-normal integral and its generalizations." Journal of Computational and Applied Mathematics, 237(1), 460-469.