how do I stay in touch with hundreds of people with a simple system

Automation


Let’s start from the end. Every morning I receive a short email that says:

Hey,

Today you must contact __. Here are the entries you made: __

Here’s who you should keep in touch with: __

I check my inbox every day, so this reminder is perfect for me. Checking a database or some site would certainly add to the worries. And the letter tells me exactly what to do. And I do it.

The email is created using simple Airtable automation. To create it, click on the Automations button in the upper right corner.

Here’s what my full automation looks like.

In words:

  • Automation starts every day at 6 am.
  • The first step is to find all records in the Established Contacts table where the Trigger Reminder column contains the word “Trigger Reminder”. (Remember that this column is populated with a formula that compares today’s date to the Next Contact column.)
  • The second action is a small custom script that automatically selects one random entry from the Potential New Contacts table and then updates the Reach Out and When to Reach Out fields for that entry. Of course, the script only selects entries from the list that were not previously selected. Therefore, the Reach Out column is updated. Only records where the Reach Out column is not “Yes” are used. What’s more, the script returns the entry it randomly selected so that I can use that information in the next step.
  • The last step puts all the information from the previous steps into an email which is then sent to my email address. This includes one entry from the table of potential new contacts, which was chosen at random, and a list of people from the table of established contacts who should receive a new message.

That’s all!

Every morning I get an email telling me who I should contact today. After sending messages, I open Airtable and update the Last Contact column to today’s date. In total, this process takes about 15 minutes a day.

You can find all the additional technical details below, but first I want to talk a little about something more important.

What message are you actually sending people?

What to write


That’s what I’m doing. I usually spend a few minutes studying what they’ve been up to lately. I check their social profiles, personal websites, read or watch any content they have posted that I have missed. Then I share a few thoughts or questions.

Most importantly, I always send messages that I would like to receive. They are short, sincere, and (ideally) helpful. I never try to sell anything and have no purpose other than keeping in touch.

Sometimes I just share an article or book on a topic I think they might be interested in, other times I offer specific help or advice on a problem they are currently facing.

Of course, not everyone publishes content or updates it regularly. In this case, I usually just ask what they’ve been doing lately. You’d be surprised how many people are actually happy to receive messages like this, and they often spark all sorts of deeper conversations.

Okay, like I said, more technical details below. And anyway, let me knowwhat do you think and if you have any suggestions to improve my system.

Technical details


Here’s what the trigger looks like:

Here’s what the first action looks like:

And this is the second action:

And here is the code I use to select a random record and update the fields accordingly:

let table = base.getTable("Potential New Contacts");

let queryResult = await table.selectRecordsAsync();

var items = queryResult.records

let todo_items = [];

for (let i = 0; i < items.length; i++) {

var record = items[i]

if (record.getCellValue("Reach Out") != "Yes") {

todo_items.push(record);

}

}

console.log(todo_items.length);

let rightNow = new Date();

var random_record = todo_items[todo_items.length * Math.random() | 0];
await table.updateRecordAsync(random_record.id, {
“Reach Out” : “Yes”
“When to Reach Out” : rightNow
})
output.set(“Name”,random_record.getCellValue(“Name”))
output.set(“Notes”,random_record.getCellValue(“Notes”))

Last but not least, this is the action I use to compose and send my daily email.

In the meantime, you are building social connections, we continue to make a Telegram bot Get Me It to anonymously and quickly establish contact between you and your dream job. Set up filters in the bot and get the most relevant offers for your needs.
Follow the white rabbit by clicking on the picture below😉

Similar Posts

Leave a Reply