Need an automation, intergration, Bot, script or program made

Hi everyone...ok guys heres my issue... I have multiple sites I have built using wix... i need all of these sites to automatically collect their emails/contacts to one place, google sheets perhaps using a zapier zap automation (thats the easy part- i have this figured out already) but then I need to figure out how to automatically upload these emails from that master list on google sheets to a single wix site that i use to send out mass emails... the only way emails can be uploaded to a wix site is manually so far... I need a bot or script or automation built that every time a contacts is added to google sheets it also subcribes to my master site- perhaps a bit that can automatically fill out my subscribe form... can you do this? Mail chimp and constant contact are not a solution for me I need these emails passed through wix...