We propose quantum algorithms for projective ground-state preparation and calculations of the many-body Green's functions directly in frequency domain. The algorithms are based on the linear combination of unitary (LCU) operations and essentially only use quantum resources. To prepare the ground state, we construct the operator exp(−τ Ĥ2 ) using Hubbard-Stratonovich transformation by LCU and apply it on an easy-to-prepare initial state. Our projective state preparation procedure saturates the near-optimal scaling, O( 1 γ∆ log 1 γη ), of other currently known algorithms, in terms of the spectral-gap lower bound ∆, the additive error η in the state vector, and the overlap lower bound γ between the initial state and the exact ground state. It is straightforward to combine our algorithm with spectral-gap amplification technique to achieve quadratically improved scaling O(1/ √ ∆) for ground-state preparation of frustration-free Hamiltonians, which we demonstrate with numerical results of the q-deformed XXZ chain. To compute the Green's functions, including the single-particle and other response functions, we act on the prepared ground state with the retarded resolvent operator R(ω +iΓ; Ĥ) in the LCU form derived from the Fourier-Laplace integral transform (FIT). Our resolvent algorithm has O( 1 Γ 2 log 1 Γ ) complexity scaling for the frequency resolution Γ of the response functions and the targeted error , while classical algorithms for FIT usually have polynomial scaling over the error . To illustrate the complexity scaling of our algorithms, we provide numerical results for their application to the paradigmatic Fermi-Hubbard model on a one-dimensional lattice with different numbers of sites.