Data Entry into Google Spreadsheet

hey,
I need 1500 Book details from provided PDF directories files and then change the name of the file to the listed SKU-model number Its pure Data entry.
you can read the name from the file and then get data from amazon etc thru its ISBN number up to you
i need :
TITLE
AUTHOR
Description
No of pages
year Published
Meta Tag Title
Meta Tag Description
Categories
ISBN
Publisher
SEO URL Unique based on (Title-Author-PDF)
Image link
have a look in to the sheet sample and directory to which i will load the data files

This Doc
https://docs.google.com/spreadsheets/d/1uWhp9xMHVxxOT_9Wf7c9vBuemS0BqZcP1rSqopdEoI0/edit?usp=sharing

The directory which names to be changed after entry to the SKU- Model number as per sheet
https://drive.google.com/drive/folders/1J9leQNr4_o2hTeS0gC9Skik5aT4AoNPD?usp=sharing

SO I can use it for CSV import.