Vet community membership applications with Google Gemini, Telegram, and Sheets
Go to Workflow
Anakhuagbor Sule
Description
Quick overview
This workflow collects community membership applications via an n8n Form, vets each candidate with Google Gemini using Tavily web search and an Apify LinkedIn lookup, requests human approval in Telegram when needed, sends invite or rejection emails via Gmail, and logs outcomes to Google Sheets.
How it works
Receives a submission from an n8n Form that captures applicant details such as name, email, company, role, birthday, and additional notes.
Normalizes the submitted fields and passes the candidate profile to a Google Gemini-powered AI Agent that can use Tavily web search, an Apify LinkedIn search actor, a calculator, and short-term memory.
Produces a structured vetting result (including summary, decision status, and a community-fit score) using a structured output schema.
If the AI decision is “Immediate approval”, sends the candidate summary to Telegram and waits for a response before continuing.
If the AI decision is not “Immediate approval”, sends the summary to Telegram and asks the reviewer to reply with 1 (approve), 2 (reject), or 3 (do nothing).
Sends an approval/invite email or a rejection email via Gmail based on the Telegram response, or stops without action.
Appends the candidate details and decision (including score, status, and timestamp) to Google Sheets for record keeping.
Setup
Configure the n8n Form trigger and share the form URL with applicants.
Add credentials for Google Gemini (PaLM) API, Tavily API, and Apify API (and ensure the selected LinkedIn search actor is available in your Apify account).
Connect a Telegram Bot credential and set the correct chat destination so the send-and-wait messages reach your reviewer.
Connect Gmail OAuth2 credentials and customize the invite and rejection email templates (including replacing {Your organization/community name} and any links).
Connect Google Sheets OAuth2 credentials and update the target spreadsheet and sheet tab to match your logging columns.