Hello, my company sells real estate and we would like to use the location information for contacts to send contacts homes near them. Since this information is stored in our website database, I need to somehow ping my website to generate the nearest homes, and then I need to create an email and send it to the corresponding contact, and this all needs to happen automatically in an automation.
I have not found any way to do this easily on ActiveCampaigns blog. First I thought of creating a dynamic RSS feed on my site where I can put the location in the URL and it would return the listings which can be done in an email, but it doesn’t seem like there’s a way to put custom fields in an RSS URL within a campaign. I also tried using webhooks to call a custom endpoint when it wants to send an email, then having my server generate the email and use the API to send it, but it doesn’t look like the API allows my to simply send a single email.
So now I’m not really sure what to do. I hope this is possible because it is a pretty crucial feature to us. If anyone has any guidance it would be greatly appreciated!