\documentclass[fleqn,12pt,a4paper]{article}
\usepackage{chemarrow}
\newcommand\Ra{$\autorightarrow{\scriptsize{Text over arrow}}{} $}
\begin{document}
\Ra
\end{document}
As shown in the image, is it possible to change the gap between the arrow and the text over the arrow. Thanks for your help.

