Skip to main content

Shortlist applicants from a Google Sheet using a role description in Google Docs

  • Nov 11, 2026 3:46 PM UTC
  • 0 replies
  • 0 views

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager

Using Zapier, read the role in my Google Doc called Open role and the applicants in my Google Sheet called Applicants. Pick the five strongest matches, then check them against the role and flag anyone who doesn't fit.

 

Use this prompt to give your AI the background first. It reads the role in a Google Doc and your applicants in a Google Sheet, picks the five strongest matches, then checks its own picks against the role. Nothing in your Doc or Sheet changes.

Apps you need: Google Docs and Google Sheets, both connected to Zapier MCP
Good for: recruiters, hiring managers and anyone sorting a long list against a brief

Make it yours

  • Swap applicants for leads, clients or vendors.
  • Change the number of matches, or add the criteria that matter most.
  • Put more background in the Doc, because the picks are only as good as the context you give.

Tried it on your own list? Let us know how well it did!