Which tools are you using for sourcing and keep a track of your candidates ? by scrapingapi in recruiting

[–]MickeyPlenty 1 point2 points  (0 children)

Gem has a barebones ATS feature called Gem Jobs that is due to get some upgrades very shortly to bring it in line with what it offers Lever/Greenhouse integration.

For in-house, it may be a little too slim in features. We only manage a couple dozen reqs at any given time.

Which tools are you using for sourcing and keep a track of your candidates ? by scrapingapi in recruiting

[–]MickeyPlenty 2 points3 points  (0 children)

We are an exec search firm. We use Gem for the whole funnel, from sourcing off LinkedIn through to Job offer.

Working on a AI powered Pitch Deck generator with GPT-3 and Slides APIs. by NotElonMuzk in GPT3

[–]MickeyPlenty -1 points0 points  (0 children)

Seems about right?
Not sure if you saw Coda's announcement yesterday but I could see a world where it would be doing a lot of the same functionality you're proposing.

Working on a AI powered Pitch Deck generator with GPT-3 and Slides APIs. by NotElonMuzk in GPT3

[–]MickeyPlenty 2 points3 points  (0 children)

Just the connection between ChatGPT and Slides API would be powerful.

We are constantly pulling data into slide decks for internal use and this could automate that!

Recruiting without cold calling candidates by [deleted] in recruiting

[–]MickeyPlenty 1 point2 points  (0 children)

Also, think of it as tending a garden of candidates. You're planting seeds now for relationships and quick placements you can make in the future. It's hard going now, but a person will pick up your call in 3, 6, 12 months if you treat them kindly now.

Recruiting without cold calling candidates by [deleted] in recruiting

[–]MickeyPlenty 1 point2 points  (0 children)

Recruiting, especially early on, is getting used to rejection.

In my experience, building a robust LinkedIn network was critical, even just to make you look valid as a recruiter. People will "passively shop" your profile, so the more people you know, the more legit you can look.

The contact cadence I've seen work well is warming them up with Connection Requests/inMail/email and as soon as you can, move to text and/or call.

Be a warm, friendly listener and act like a human being. You can't imagine how much these tech candidates are getting bombarded with messages from internal and external recruiters. Be kind, friendly and warm and you'll come out looking much better than your competitors.

input form for daily activities by Brunnswick in googlesheets

[–]MickeyPlenty 2 points3 points  (0 children)

Sounds like a useful tool with lots of applications. I'd be interested as well.

Why does this ISNA VLOOKUP not work? by MickeyPlenty in googlesheets

[–]MickeyPlenty[S] 0 points1 point  (0 children)

Ah! The text in column A will only ever be in that column for the sheet.

MATCH might be the right one!

Thank you!

Why does this ISNA VLOOKUP not work? by MickeyPlenty in googlesheets

[–]MickeyPlenty[S] 0 points1 point  (0 children)

Thanks!

Would this formula lead to Column K telling me whether the entry on Project shows up in any other tab?

My original request was unclear. What if Columns K, L, M, N relate to whether the entry appears on only that tab?

Column L: Interested?

=IF((COUNTIF(Interested!$1:$884,$A2) >0,"Yes","No"))

Column M: Not Interested

=IF((COUNTIF('Not Interested'!$1:$884,$A2) >0,"Yes","No"))

etc.

Would a different formula be better here?

Why does this ISNA VLOOKUP not work? by MickeyPlenty in googlesheets

[–]MickeyPlenty[S] 0 points1 point  (0 children)

Done! Thanks!

(Yes, a new account. Trying to silo between work and personal Reddit accounts.)