Bulk Upload With Connected Boards

I am looking to migrate our product onboarding to Monday.com, there are currently 1500 items in our gsheets tracker I am looking to migrate across. The items are currently linked to a table called projects, where each project has between 10-200 items in it.

I am looking to upload the items to a board and have it link to the projects board, is it possible to do this automatically using a ref ID or similar at time of upload, or do I need to manually do this?