Last updated: January 2026
Connect Google Sheets to Ralivi to automatically import leads from your spreadsheets. Perfect for importing leads from forms, marketing campaigns, or any other source that outputs to Google Sheets.
Before connecting, your Google Sheet must be properly formatted:
Your sheet must have these columns (names can vary, you'll map them later):
Include any of these for richer lead data:
| timestamp | first_name | last_name | phone | company | lead_source | status | |
|---|---|---|---|---|---|---|---|
| 2026-01-28 10:30 | John | Smith | john@example.com | 0412345678 | Acme Corp | Website Form |
Navigate to Settings → Data Connections in Ralivi.
Click the "Connect" button and select "Google Sheets" from the modal.
You'll be redirected to Google to grant Ralivi permission to access your spreadsheets. Click "Allow" to continue.
After authorization, you'll be redirected to complete the setup. Click "Complete Setup" to continue.
Enter the URL of your Google Sheet. You can find this in your browser when viewing the sheet. It looks like:
https://docs.google.com/spreadsheets/d/[SHEET_ID]/editMap your spreadsheet columns to CRM fields. Required fields must be mapped before you can continue.
Choose how often to automatically sync:
Click "Sync Now" to import your first batch of leads. The connection is now active and will sync automatically based on your schedule.
Field mapping tells Ralivi which spreadsheet columns correspond to which CRM fields. This is crucial for accurate data import.
During each sync, Ralivi:
Ralivi prevents duplicate imports by:
After each sync, you'll see:
Click "Sync Now" on any connection to immediately import new leads. This is useful for testing or when you need leads imported right away.
Click on the sync frequency (e.g., "Every 30 minutes") to change it. Select a new frequency from the dropdown and it will be saved automatically.
Click "Edit Mapping" to change how your spreadsheet columns map to CRM fields. This is useful if you add new columns or restructure your sheet.
Each connection shows the last sync time and results. This helps you monitor import activity and catch any issues quickly.
Always include a "status" column and map it. This prevents duplicate imports and lets you track which leads have been processed.
Before enabling automatic syncing, do a manual sync to verify your field mappings are correct and leads import as expected.
Always map the lead_source field so you can track where your leads are coming from and measure campaign effectiveness.
Regularly check sync results to catch any errors. If you see errors, check your sheet for missing required fields or invalid data.
Use 15-minute syncs for high-volume sources, 30-60 minutes for moderate volume, and manual for low-volume or one-time imports.
Connect your website form (Google Forms, Typeform, etc.) to output to Google Sheets, then sync those leads automatically into Ralivi.
Import leads from different marketing campaigns, using the campaign_name field to track which campaigns generate the most leads.
Collect event registrations in Google Sheets and automatically create contacts in your CRM for follow-up.
Export leads from Facebook Lead Ads or LinkedIn to Google Sheets, then sync them into Ralivi for nurturing.
Set up your Google Sheet with the required structure and connect it to start automatically importing leads.
Go to Data Connections →