Hi @Vaibhav B ,
Thank you for posting this query in Microsoft Q&A Platform.
Google sheets connector for supports in Mapping data flows only with Azure IR. Since you cannot use that, Below are few approaches which I could suggest.
To move data to/from a data store that the Azure data factory does not support, or to transform/process data in a way that isn't supported by the service, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline. The custom activity runs your customized code logic on an Azure Batch pool of virtual machines. Click here to know more about this.
You can consider writing your own code in Azure Functions which makes API calls to Google sheets and fetch data for you. Azure Functions activity can be used in Azure data factory pipeline.
You can consider move data from google sheets to Google cloud Storage(S3 API). And then use Copy activity in Azure data factory to take data from Google Cloud storage to your destination. Click here to know about google cloud storage connector in ADF.
you can try to use REST connector data set in Copy activity source tab. Inside REST connector dataset make API call to google sheets and fetch data.
Hope this helps. Please let me know if any further queries. Please feel free to share your implementation details if you processed to some extent along with error details so that we can help better.