WhatsApp PersonalBusiness
Recruitly LogoRecruitly
How-to

How to update thousands of CRM records without doing it by hand

Match the tool to the change: a bulk action when every record gets the same value, the Data Agent when each record needs its own value from its CV or LinkedIn, an import when the values are in a spreadsheet. How each works and how to undo a mistake.

Ask AI about this

ChatGPT
Perplexity
Grok
Claude
Google AI

You update thousands of CRM records without doing it by hand by matching the tool to the kind of change. When every record gets the same value, such as a new owner, a status or a tag, a bulk action on a saved search does it in one go. When each record needs its own value worked out from its CV, its LinkedIn profile or its company, the Data Agent reads and fills every record in the background. When the values already sit in a spreadsheet, an import updates the matching records. Only judgement calls are left for people.

Which tool should I use to update records in bulk?

Ask what the new value depends on. That one question decides the tool.

Same value for everyrecord?yesBulk actionowner, status, tags, fieldsnoCan it be worked outfrom the CV or LinkedIn?yesData Agentfills and tidies per recordnoIs it in a spreadsheetor another system?yesImport, update on matchmatched by email or phonenoA judgement per record: a recruiter, or Claude or ChatGPT for a few dozenSTART
Most big updates are the first kind and take a minute. The second kind is where agencies lose weeks, because it looks like it needs a person to read every record.

Agencies usually get the first kind right and give up on the second. "Fill in the job title on 8,000 candidates from their CVs" sounds like a temp's summer project. It is a Data Agent job you can preview in a minute and leave running overnight.

How do I change the same field on many records at once?

Tick the records, open the toolbar's More menu and choose the change. Every grid in Recruitly has the same toolbar, so it works the same way on candidates, contacts, companies, leads, deals and jobs.

ChangeWhereRecords
OwnerTick rows › OwnerAll modules
StatusMore › Update StatusCandidates, contacts, companies
Pipeline stagePipelineLeads and deals
TagsMore › Add Tags / Remove TagsAdd on every module; remove on candidates and companies
FoldersMore › Add to Folder / Remove from FolderCandidates, contacts, companies
Sectors, industries, nationalitiesMore › Add / RemoveCandidates
Rating, genderMore › Update Rating / Update GenderCandidates
Do Not ContactMore › DNC StatusCandidates
Any custom fieldMore › Custom FieldsEvery module with custom fields
Archive, restore, deleteMoreAll modules

How do I update every record in a search, not just the ones on screen?

Use select-all. When you tick the box at the top of the grid and choose to select every result, Recruitly applies the change to everything the search matches, however many pages that is, minus any rows you untick. Save the search first if it is one you will use again, such as "Candidates owned by a consultant who has left".

Before a big change, read the count. The grid tells you how many records the search matches, and that number is how many records will change. If it is far bigger than you expected, the search is wrong, and the time to find out is before you press Update.

How do I fill in fields that are different on every record?

Use the Data Agent. It works through a set of records one by one, reads what each one already holds, and fills and tidies the fields you tick from the CV, the notes, the LinkedIn profile or the company's own record.

  1. Choose the records. Up to 100 ticked in a grid, a saved search of up to 25,000, or a ready-made list such as records missing a location, an email or a phone.
  2. Tick the work. It is grouped in cards: profile (name, job title, employer, work history, education, skills, languages, years of experience), tidying (job titles with emojis, hashtags and slogans, name casing, placeholders like N/A, dates, duplicate entries, skill spellings), location, contact details, classification into your own industries, sectors and tags, a LinkedIn refresh, and AI writing such as a summary or overview. Each tick shows how many records are missing that field.
  3. Read the cost. A cost card shows the estimate before anything runs, split into clean-up, LinkedIn, email and phone.
  4. Press Preview. It runs on up to five records, writes nothing, charges nothing, and shows card by card what it would change, where each value came from and how sure it is.
  5. Start it. A super user's job starts at once. Anyone else's waits for a super user, and nothing is charged until one starts it. You can close the window; you get an email when it finishes, and any credit not used goes back to your balance.
By hand2 minutes a record, 10,000 records333 hoursWith the Data AgentRuns in the background; you get an emailminutes to set up, $50 to run
At an assumed 2 minutes a record to open it, read the CV, fill the gaps and save, 10,000 records is 333 hours, about eight working weeks for one person. The Data Agent's clean-up for the same records is $50, plus $50 if every record also gets a LinkedIn refresh.

Classification is where it saves the most argument. Industries, sectors and tags are matched to your agency's own lists, not a generic taxonomy, so the result fits the searches your recruiters already run. The tags your team added are kept. There is more on how the agent decides in how we built the Data Agent.

Can bulk updates run on their own every week?

Yes, for the Data Agent. A super user can set a job on a saved search to repeat every day, week or month, and each run works on the records added since the last one, so new records are cleaned the day after they arrive without anyone starting a job. The schedule runs as the person who set it, emails only when a run fails, and stops when you stop it. How to keep candidate data up to date puts it into a routine.

How do I update records from a spreadsheet?

Use Import Data in Settings › Data Management. Load the CSV, map its columns to Recruitly's fields, and choose what happens when a row matches an existing record on email or phone: skip it, update it, or create a new one. Choose update, and the records you hold take the spreadsheet's values while new people are added.

Each import keeps a history with how many rows succeeded and failed and a retry for the failures. Imports work for leads, contacts, companies, deals, candidates, jobs and placements, and new records count toward your plan's record capacity.

Can Claude or ChatGPT update records for me?

Yes, for changes that need a judgement on each of a few dozen records. Connect Recruitly to Claude or ChatGPT through the Recruitly MCP server, and once a super user allows assistants to make changes, you can ask in a sentence: move the five candidates I interviewed today to the next stage and add a note of what each said. Every change is made as you, with your normal permissions.

For thousands of records, the Data Agent is the better tool. It shows the cost first, previews its work, and keeps a record of where every value came from.

What if a bulk update goes wrong?

Most mistakes can be put right, and the record of what changed is always there.

If this goes wrongHow you put it right
Records archived or anonymised by mistakeSystem Activity Log › Bulk actions › Undo, within 30 days
Records deleted by mistakeSettings › Recover Deleted Records, within 90 days (each record comes back on its own; a company brings back its contacts and deals)
A field changed on the wrong recordsEach record's Audit Logs show the old and new value of every change, by whom and when
A Data Agent job filled something you did not wantIts changes are kept per record with where each value came from; filling only writes to empty fields, so nothing your team typed was replaced

A bulk change of status or tags has no single undo button. That is why the count before you press Update matters, and why a large change is worth trying on a small saved search first.

Who should be allowed to make bulk changes?

Anyone can tick a page of records and retag them, which is how it should be for day-to-day work. For the changes that cost money or reach the whole database, Recruitly puts a super user in the loop: Data Agent jobs by anyone else wait for a super user to start them, Data Health is for super users, and super users set export limits per module so the whole database cannot leave with one person. A monthly cap on Data Agent spending means a mistake cannot become a large bill.

What should I check before a large bulk update?

  1. Save the search and give it a name that says what it is for.
  2. Read the count and make sure it is what you expected.
  3. Open three records from the search and check they belong in it.
  4. For the Data Agent, read the cost card and run Preview.
  5. Try it on a small slice first, such as one consultant's records.
  6. Note what you did and when, so anyone reading the audit log later knows why.

The work this frees up is the work people joined recruitment for. The recruiter who used to spend Friday afternoons fixing records spends them on the phone, and the database they search on Monday is one they can trust.

How much does it cost to update records with the Data Agent?

$0.005 a record for clean-up and filling, $0.005 for each LinkedIn profile refreshed, and $0.15 to $0.25 for each email or phone found. 10,000 candidates cleaned costs $50. Every agency gets $10 of Data Agent credit on first use, enough for 2,000 records. Bulk actions, imports and the audit log cost nothing. See the pricing page.

Will a bulk update overwrite what my recruiters typed?

A bulk action sets the field you chose to the value you chose, on every record selected, so check the selection. The Data Agent's filling only writes to empty fields, the tidy-ups you tick, such as casing and emoji removal, reformat existing values without changing what they mean, and Preview shows every change before it runs.

Is there a limit to how many records I can update at once?

A bulk action applies to everything a search matches. A Data Agent job takes up to 100 ticked records from a grid or up to 25,000 from a saved search; split a bigger database into several searches.

bulk updateData Agentdata qualityCRMautomation
Recruitment software for agencies

The product this came out of

Nineteen modules on one record: sourcing, screening, campaigns, calls, e-signature and billing, without a second system to keep in step. Free to start, no card, no call.