Hello Akshay,
I do not think there is out of box connector from quicksight to G-Sheet but may you could find a workaround as mention in the old post here Google Sheet > Athena automation
In addition, you may use Appflow to connect to G-sheet to bring in the data to S3, Redshift, RDS for PostgreSQL etc as one of the supported destination and eventually have the direct Quicksight Connection.
Fore more info -Google Sheets connector for Amazon AppFlow - Amazon AppFlow
Hope this gives some idea.
Cheers,
Deep