
If leads are collected in a Google Sheet, automating the move to your CRM saves typing and avoids missed leads. Prepare a clean sheet, connect it, test with a few rows and keep an eye on the run log.
When it helps
- A team adds leads to a shared sheet from events, calls or partners
- An ad lead form exports into a sheet
- You want leads in your CRM without copy and paste
Prepare the sheet
- One row per lead
- Clear column names: name, phone, email, source, notes
- One phone number per cell
- No merged cells
See what to track in a lead sheet.
Connect and test
In Rivo Automation, use the sheet to leads template with your Google account. Start as a draft, test with two or three rows, check the leads in Rivo Leads, and then turn it on. See Google Sheet to Leads automation.
Check the run log
The run log shows what ran and why anything failed. Check it for the first few days. Fix columns that do not match.
One-time import instead
For moving an old list once, import CSV or Excel; see how to move leads from Excel to a CRM and Google Sheets to Rivo Leads.
Watch for duplicates
If a row is edited, check it does not create a second lead. See how to handle duplicate leads.
Common questions
What if the sheet changes layout? The automation may stop matching columns; check the run log after changes.
Can both import and automation be used? Yes, import the old list once and automate new rows.
Plans
Rivo Automation: 7-day free trial. It is listed under the Growth plan as it opens. See Rivo Automation and pricing.