Hello, I am very new to this process so I feel very lost.
This Google Sheets will be where the data for email subscriber list will be stored. There’s three emails on there already. When this list gets a new entry, I need the action to then add the email to the new subscriber list to Mailerlite. On Mailerlite is a separate automation to actually send the welcome email. If there is a way to have this welcome email send to the emails already on this list as well, that would save me a headache.
My problem is that I can’t quite figure out what this email value is supposed to be. I would want it to autofill to be whatever the newest line in the spreadsheet says. In the given options, I can’t pick the column the emails are filled into on the spreadsheet, and the one email option it does give me is a single client. My knowledge with Spreadsheets is pretty limited, and I have some experience with Mailchimp from an old job, but not Mailerlite.
My problem would be solved by paying for Core Squarespace so I can properly connect it to Mailerlite, but until my money trees start producing, I’m trapped figuring out how to do this for free. I’ll gladly clarify anything that doesn’t make sense. Please HELP!!!
