You are correct, @jduprey, that some of the automations are helpful but that there isn’t that much magic to them. Pulling in batches of data is basically as easy as mapping the fields, ordering the columns, and then filling in a few special columns.
I’d consider making a manual account and then using that manual account id for all imported Apple Card transactions. The Week, Month, Full Description, and Date Added columns really aren’t used and can be left blank. The Transaction ID column is not important for non-feeds data… so that can stay blank also.
I hope this helps.