ETHNOPHARMACOLOGICAL RELEVANCE: Compound Zaoren Granules (CZG), an optimized herbal formulation based on the traditional Chinese medicine prescription Suanzaoren decoction, are designed specifically for insomnia treatment. However, the mechanisms underlying its efficacy in treating insomnia are not yet fully understood. AIM OF THE STUDY: The research investigated the mechanisms of CZG's improvement in insomnia by regulating cAMP/CREB signaling pathway and metabolic profiles. METHODS: The main components of CZG were characterized by liquid chromatography-mass spectrometry (LC-MS). Subsequently, these validated components were applied to network pharmacological analysis to predict signaling pathways associated with insomnia. We evaluated the effect of CZG on BV-2 cells in vitro. We also evaluated the behavioral indexes of CUMS combined with PCPA induced insomnia in rats. HE staining and Nissl staining were used to observe the pathological damage of hippocampus. ELISA was used to detect the levels of various neurotransmitters, orexins, HPA axis, and inflammatory factors in insomnia rats. Then we detected the expression of cAMP/CREB signaling pathway through ELISA, WB, and IHC. Finally, the metabolomics was further analyzed by using UHPLC-QTOF-MS/MS to investigate the changes in the hippocampus of insomnia rats and the possible metabolic pathways were also speculated. RESULTS: The results of CZG in vitro experiments showed that CZG has protective and anti-inflammatory effects on LPS induced BV-2 cells. A total of 161 chemical components were identified in CZG. After conducting network pharmacology analysis through these confirmed components, we select the cAMP/CREB signaling pathway for further investigate. The behavioral research results on insomnia rats showed that CZG significantly prolonged sleep time, mitigated brain tissue pathological damage, and exhibited liver protective properties. CZG treats insomnia by regulating the content of various neurotransmitters, reducing levels of orexin, HPA axis, and inflammatory factors. It can also treat insomnia by upregulating the expression of the cAMP/CREB signaling pathway. Hippocampus metabolomics analysis identified 69 differential metabolites associated with insomnia. The metabolic pathways related to these differential metabolites have also been predicted. CONCLUSION: These results indicate that CZG can significantly prolong sleep time. CZG is used to treat insomnia by regulating various neurotransmitters, HPA axis, inflammatory factors, cAMP/CREB signaling pathways, and metabolic disorders.