AutoHotkey automation review (003)
Here’s an AutoHotkey automation review of what I automated with AutoHotkey

This week I walk through some AutoHotkey automation review:
1) Grabbing email addresses from Facebook
2) Regular Expression for email address. You can see a detailed walkthrough here: https://youtu.be/4LRM5jJIG_8
3) Survey on working / mentoring in AutoHotkey. You can take the survey here: https://www.surveygizmo.com/s3/4756782/f41d855f3f74
4) RetsRabbitt for accessing data in MLS (you need to legally have access to MLS already)

Check out more of my scripts at: https://the-automator.com Joe Glines
TLDR: Automating processes to quickly grab email addresses from a webpage and using APIs to send automated emails for marketing purposes.

1. 00:00 Automated a process to quickly grab 50 email addresses from a webpage using AutoHotkey.
1.1 Using AutoHotkey, I created a script to grab 50 email addresses from a webpage instead of manually copying and pasting them.
1.2 Viewing previous comments on Facebook may require running the page multiple times to view all comments.

2. 02:43 Accessing the email address from a webpage by looping over the count of 140 and getting the inner text of the first span tag.
2.1 Looping over the count of 140, a message is passed and the outer HTML of the first element is accessed to get the email address.
2.2 Get the inner text of the first span tag by using getElementByTagName(/”span/”)[0].

3. 05:50 Copied and pasted into Excel to quickly find an automated way to check if a string contains an @ sign to determine if it is an email address.
3.1 I used a simple if statement to check if a string contains an @ sign to determine if it is an email address.
3.2 In less than 5 minutes, a way to automate the process of finding email addresses was figured out by copying and pasting into Excel.
3.3 The last comment was 204, but there was no indication of how many comments there were.

4. 09:39 Use a regex expression to parse and find email addresses in text and create fake ones to demonstrate a hack.
4.1 Using a regex expression, you can parse and find email addresses in text and keep track of where you are in the text.
4.2 Create fake email addresses to demonstrate a hack.

5. 12:32 Copy and paste to create a tab-delimited file for importing a list.
5.1 Copy and paste text as text, delete, insert first name and email address, and save as a tab-delimited file.
5.2 Copying and pasting from Excel to a tab delimited file can be done to import a list.

6. 15:28 Half of respondents were willing to get paid for mentoring/coding, but not to pay for it.
6.1 Illegal characters in nearly 2,000 email addresses caused an issue when attempting to deploy a script.
6.2 Half of respondents were willing to get paid for being a mentor and two-thirds for writing code, but most were not interested in paying for it.

7. 18:12 Used an API to query MLS and Gzip compression to reduce file size.
7.1 I figured out how to use an API to query the MLS and pull back data about a property.
7.2 Gzip compression can be used to reduce file size.

8. 20:34 Using Mailgun API for automated drip campaigns to send 10,000 emails/month for free.
8.1 I’m working on gzip and autohotkey to make text look normal, and I’m also working on a mailgun API for drip campaigns.
8.2 Mailgun is an API that provides 10,000 emails a month for free and is great for follow-up emails for webinars, real estate, and autohotkey stuff.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.