Manual mapping of drupal fields to new WP post

Hello!

Although I’m a very new user with WP, I have the task to “migrate” a drupal site to WP. The drupal site is VERY simple, all nodes consist in simple text fields with a single Jpeg picture per page. All nodes are identical (this drupal site served as a catalog for a music record collection).

The WP site uses Pods with Custom Post Type and there is a “Pod” for the music records with custom fields (users can add new items in the collection via the standard WP post form and the pods custom fields…).

I would like to automate the data migration from drupal to WP but reading and researching around I see there are many ways to do this. My first idea was to write a shell script to do the following (pseudocode):

for loop from 1 to max node number in Drupal
   create a new WP post via wp_post_insert
   scrape the drupal page with node ID using html/json parsers (pup, jq, etc)
   insert the scraped data into the WP MySQL database
end loop

This is only a **rough** idea… To be honest I envisioned using BASH script at first but I see WP most likely requires php script which I have NO experience with. Moreover, I have never manually worked with SQL db’s (statements, etc) so I will take all the need I can help.

Is this something achievable? The current drupal site has over 500 items so this is going to be a significant operation and I need something reliable and stable.

thanks!