Automate Sheet from Template

I have been trying to find a way and have been searching for the last few days, I need to create a sheet from a template then import some data from another sheet (Google/OneDrive) into it. I assume using the API would be the route to go but am unsure how to accomplish such a feat. If anyone has any useful information or has done this before please let me know, thank you.