I have successfully migrated content into nodes/paragraphs from Excel spreadsheets (using the awesome https://www.drupal.org/project/migrate_spreadsheet module) although it's not really any different if it was CSV. However, the paragraphs had a 1-1 correspondence with the nodes and it was easy to import the data as a single row. Now I need to migrate content where the nodes have multiple paragraphs attached. I'm initially stuck on how the to use the paragraphs reference to its parent content. It seems like each piece of content has its own unique ID, UID, which is stored in the migrate mapping tables to its corresponding Drupal content ID. But how does the paragraphs's parent id get used? Do I need to import that as a separate field and then do a lookup? Do I need a create a custom plugin for this?

Album ID in the Song data is the reference to the Song's parent, which is the UID in the Album data. I'm not clear on how to import the "Album ID" data in Songs and reference it when I import the Albums data.

@ClemensTolboom agreed that it's two separate migrations - first songs, then albums. The issue is - how do songs get mapped to albums? It's easy if there's a 1 to 1 correspondence - ie. one song per album. But how is it done if there are multiple paragraphs (song) per node (album)?
– codesmithSep 19 '18 at 18:28