I have read and researched on google and find that any refresh, clone or copy options copies all or selected data plus the metadata or only the metadata from the Production org to Sandbox. Is there a way to copy just the records or data and no metadata from Production to Sandbox without a third-party tool? And can this process be automated?
You could use SFDX for this. I am not sure what level of experience you have with it but the guide over here walks you through an example of how that can be done.
A trailhead to get started with SFDX - https://trailhead.salesforce.com/en/content/learn/projects/quick-start-salesforce-dx/set-up-your-salesforce-dx-environment
Also not sure what you mean by automating this process but you can run a script that essentially runs these commands and loads the data into any Sandbox.