community created Vendor Directory

Site URL: https://www.whollyhandmade.com/vending-at-wholly-handmade

Ok, this is my last resort. I have a client who runs two different markets (one runs 7x’s per year and the other runs twice). I need a directory for 140 vendors, some return, some new for each event. I tried community box but it falls very short from what I require. Essentially I want a form to allow for vendor information, photos included, to function both as an application to become a vendor and to be approved and turned into a vendor directory. 

I am using mailchimp automations to push them through the application process (initial approval, payment request, profile set up by vendor in communiry box). 

Closest I got to a seamless process was setting up a an embedded squarespace form for vendors to fill in jotform, with uploadcare plugin to create live links to images. Once filled it populated a google sheets doc, from there it automated to list in mailchimp and I was able to import all data from g sheet for each profile to community box. But the gallery images keep failing in the import to community box. 

Long story short, I need a squarespace compatible directory that can act as a vendor application (so approvals are necessary). 

If there’s someone in here that thinks they can solve this infuriating debacle, I’d be so happy to pay. 

There’s a few complicated moving parts not outlined above but that’s the gist of it. 

FOR THE LOVE OF ALL THINGS PLEASE HELP!