The advancement of molecular electronics endeavors to build miniaturized electronic devices using molecules as the key building blocks by harnessing their internal structures and electronic orbitals. To date, linear planar conjugated or cross-conjugated molecules have been extensively employed in the fabrication of single-molecule devices, benefiting from their good conductivity and compatibility with electrode architectures. However, the development of multifunctional single-molecule devices, particularly those with unique charge transport properties, necessitates a more rigorous selection of molecular materials. Among different assortments of molecules suited for the construction of molecular circuits, Spiro-conjugated structures, specifically spirobifluorene derivatives, stand out as promising candidates due to their distinctive electronic properties. In this work, we focus on the charge transport characteristics of Spiro-conjugated molecules sandwiched between graphene nanogaps. Experiments reveal significant Coulomb blockade and distinct negative differential conductance effects. Beyond two-terminal device measurements, solid-state gate electrodes are utilized to create single-molecule transistors, successfully modulating the molecular energy levels to achieve an on/off ratio exceeding 1000. This endeavor not only offers valuable insights into the design and fabrication of future practical molecular devices, blessed with enhanced performance and functionality, but also presents a new paradigm for the investigation of fundamental physical phenomena.