As college students are now nearing the end of the semester, it’s imperative they get a commercial real estate internship or full-time job. Fortunately, a new tool available can help you streamline the process – ChatGPT. In this video tutorial, we will use ChatGPT for commercial real estate recruiting by creating a list of 50 institutional real estate companies in New York City in Google Sheets and helping you apply for all the jobs.
- This is another post in our ongoing series on using artificial intelligence in commercial real estate.
Using ChatGPT for Real Estate Recruiting Video Tutorial
Before we get started, you should have two web pages open.
One of the main reasons students do not find a commercial real estate summer internship or full-time job is that they do not know where to start.
To help with this process, we will use ChatGPT to create a list of companies to apply to and include some basic information about the company and the company’s career URL so that you can apply instantly. This tool can be highly valuable in assisting with some of the time consuming (and boring) steps that are still required in the recruiting process. As a consequence, it frees you up to use your time toward more valuable recruiting efforts, like networking.
Steps to using ChatGPT in real estate Recruiting
Once you have created an account and opened a new Google Sheets, you must download the ChatGPT extension for your Google Sheets.
- Open new Google Sheets
- Click on Extensions
- Press Add-ons
- Press Get add-ons
- Type in GPT
- Download GPT for Sheets and Docs
After this new add-on has been installed, we will start using this new feature, but first, we must pull an API from Open AI.
- Click on your Open AI avatar
- View API
- Create a new secret key
- Go back to your Google Sheets Extension, click the new Download GPT for Sheets and Docs extension
- Launch a sidebar
- Press home
- Insert API Key
Now you are ready to go.
Formulas to use with ChatGPT in Real Estate Recruiting
You can see my formulas in the video demonstration, but I will also list them here for you to copy/paste.
=GPT_TABLE(“list me 50 institutional real estate companies in New York City and its CEOs”)
=gpt(CONCAT(“write me a two sentence description about this company”,B3))
=GPT(“what is this companies career website”,B2)
=gpt(CONCAT(“write me a 50 word linkedin connection message to this person”,B3))
Are you looking to get a job in Commercial Real Estate? Sign up for Career Connections so we can match you with top companies that are looking to hire.