This is a CRM built with email capabilities, web scraping and scheduling. The app contains views with a rotating proxy server to check if an email exists, a web scraper that will search a website and the links contained within for emails and a connection to AWS SES/SNS to send emails and receive the analytics such as bounce rate, black listed emails and complaints. This is created for someone who wants to find investors for a startup company. I am not a fan of spamming so please do not use this for such purposes.
I have been solo and need of some help putting the last bit together. I am open to collaboration!!
Explore the docs »
View Demo (soon)
·
Report Bug
·
Request Feature
- React
- Django
- Django Rest Framework
- SQLite (current) or PostgreSQL (maybe for production?)
- AWS
- Ant Design
- Much More...
To get a local copy up and running contact me if you need help.
RealEmail API Key AWS Account
- Clone the repo
git clone https://github.com/giterdun345/Email_leadManagement.git
Dashboard - provides bounce rate and complaints from SNS, emails sent, emails opened
Add Target - Manual input of a single investor
Upload CSV- Has ability to drag and drop multiple csv files to db;
Only required Full Name and Company
-Validate Email button can be clicked to check if the email exists. This uses a rotating proxy server scraped from a website providing IP addresses every 10 minutes. There are ten variations that are checked:
- name combined no seperator johnketterer@domain.com
- name combined seperator as dot john.ketterer@domain.com
- reverse lname fname kettererjohn@domain.com
- reverse lname fname with dot ketterer.john@domain.com
- fname first letter with lastname jketterer@domain.com
- fname letter with lastname dot seperated j.ketterer@domain.com
- lname letter with fname kjohn@domain.com
- lname letter with fname with dot seperator k.john@domain.com
- the variation if all else fails info@domain can be used if it exists
Target list- gives ability to edit or delete investors in the list
- With Emails- investors whose emails have been identified; includes a table with Name, Company, Category, Email and Email Confirmed(Boolean)
- Without Emails- investors without an email; includes a table with Full name, Company, Category, Personal Website and most social media sites to aid in the search for the email.
Emailed- provides a table for emails which have been sent.
Connections- connects to google calenders to set appointments and to keep track all in one place.
New Link to be added shortly- Given a website url, could be multiple from a CSV file, there is a scraper in the sandbox folder that will crawl the domain and extract all email addresses located on the page. We can possibly extract the name from the email or edit manually. Any thoughts?
Any other features you would like to see or add to? Please link up!!
- Implement multithreading for email validation and a few other operations
- Add view and component for the scraper (scrapes a given website for emails)
- Finish email setup with SES and SNS
- Need some HTML templates for the emails to be sent
See the open issues for a list of proposed features (and known issues).
Contributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are greatly appreciated.
- Fork the Project
- Create your Feature Branch (
git checkout -b feature/AmazingFeature
) - Commit your Changes (
git commit -m 'Add some AmazingFeature'
) - Push to the Branch (
git push origin feature/AmazingFeature
) - Open a Pull Request
Distributed under the CC License. See LICENSE
for more information.
John Ketterer - johnmketterer@gmail.com
Project Link: https://github.com/giterdun345/Email_leadManagement
- Big shout out to Ant Design! Thank you for letting me focus more on the logic rather than UI