Quick overview
Quick overview This workflow reads contacts from Google Sheets, uses Google Gemini to classify each contact’s job function and seniority from their job title and company name, and writes the Function, Seniority, and Confidence Score back to the same sheet. How it works Starts manually when you click Execute workflow. Reads rows from a specified Google Sheets worksheet and maps your column headers to the workflow’s expected fields. Keeps only contacts that have a Job Title and no existing Seniority value. Normalizes job titles and company names, deduplicates identical Job Title + Company pairs, and batches the unique combinations to save LLM tokens. Waits between batches to respect rate limits, then sends each batch to Google Gemini to return Function, Seniority, and a confidence score for every original row ID. Parses Gemini’s JSON response and updates the matching rows in Google Sheets with Function, Seniority, and Confidence Score. Setup Add Google Sheets OAuth credentials and set the Google Document ID and Sheet ID in the Global Settings values. Add a Google Gemini (PaLM) API credential for the Google Gemini node. Ensure your sheet has columns for #, Job Title, Company Name (recommended), Function, Seniority, and Confidence Score, and update the column name settings if your headers differ. Adjust Batch Size and Wait Time in Global Settings to control Gemini batching and throttling before activating the workflow. Requirements Google Sheet Gemini API Key Customization Update column names in the Global Settings node if your sheet uses different headers. Change the Batch Size in the Global Settings node to control how many contacts are sent to Gemini at once. Change the Wait Time in the Global Settings node to control how many seconds the workflow will wait before hitting the Gemini API again. An n8n automation workflow template by Rishabh Patil.
Rishabh Patil
web
free
Others in the same category, ranked by how often they are opened.
