What This Workflow Does
This automation solves a common pain point for sales teams: manually transferring lead information from spreadsheets into your CRM. Every time you or your team adds a new row to your designated Google Sheet, this Make.com workflow instantly creates a corresponding lead in Freshsales with all the contact details properly mapped.
The template handles all the field mapping between your spreadsheet columns and Freshsales lead fields. You can customize which columns correspond to which CRM fields during setup. This eliminates repetitive data entry while ensuring your sales team always has the most current lead information in your central CRM system.
How It Works
1. New row detection
The workflow continuously monitors your Google Sheet for new rows being added. You can configure how frequently it checks for updates (typically every 5-15 minutes).
2. Data extraction
When a new row appears, Make.com extracts all the cell values and prepares them for transfer to Freshsales. The template includes default field mappings for common lead attributes.
3. Lead creation
The system creates a new lead in Freshsales using the extracted data. All contact details, company information, and custom fields are properly mapped to their corresponding CRM fields.
4. Error handling
If any required fields are missing or data formatting issues occur, the workflow can notify your team via email while skipping that particular record to prevent CRM pollution.
Who This Is For
This automation is ideal for:
- Sales teams collecting leads through Google Forms or shared spreadsheets
- Marketing teams running campaigns that generate lead lists in Sheets
- Businesses transitioning from spreadsheet-based lead tracking to Freshsales
- Distributed teams where multiple people add leads to a shared spreadsheet
- Companies running events or webinars that produce spreadsheet-based attendee lists
Pro tip: Use this workflow with a Google Form that feeds into your Sheet to create a complete no-code lead capture and CRM entry system.
What You'll Need
- A Make.com account (free plan available)
- Freshsales account with API access
- Google Sheet with lead data (or a template you can copy)
- Basic understanding of your Freshsales lead fields
Quick Setup Guide
- Copy the template to your Make.com account
- Connect your Google Sheets and Freshsales accounts
- Select your source spreadsheet and worksheet
- Map your spreadsheet columns to Freshsales lead fields
- Set your preferred polling interval for new rows
- Test with a sample row to verify field mappings
- Activate the scenario to begin automatic lead creation
Key Benefits
Eliminate 2-3 hours per week of manual data entry that sales teams typically spend copying information between spreadsheets and CRMs.
Reduce lead entry errors by 90% by removing human transcription mistakes and ensuring consistent field formatting.
Get leads into your CRM 10x faster - new spreadsheet entries appear in Freshsales within minutes rather than waiting for manual processing.
Maintain data hygiene with built-in error checking that prevents incomplete or malformed records from entering your CRM.
Scale your lead capture without adding administrative staff as your business grows.