Overview
The Salesforce integration provides bidirectional sync between your Salesforce CRM and Raycaster sheets. Pull contacts and accounts into your workspace, enrich them with AI-powered research, and push updates back to Salesforce.Setting Up Salesforce
Authorize
Sign in to your Salesforce account and grant Raycaster access. You’ll be redirected to Salesforce’s OAuth page.
Salesforce integrations are always organization-scoped. Each organization has a single Salesforce connection shared by all members.
Using CRM Templates
The fastest way to get started with Salesforce sync is to use a CRM template:- Create a new sheet and select “From Template”
- Choose “Company/Accounts Template for CRMs” or “People Template for CRMs”
- The template includes columns pre-mapped to common CRM fields
Syncing Data
Configuring Sync
Select Entity Type
Choose what you want to sync:
- Contacts — Individual people in your Salesforce
- Accounts — Organizations in your Salesforce
Map Fields
Map your sheet columns to Salesforce fields. The field mapping interface shows available standard and custom fields.Example mappings:
| Sheet Column | Salesforce Field |
|---|---|
| First Name | FirstName |
| Last Name | LastName |
Email | |
| Company | Account.Name |
| Job Title | Title |
Choose Sync Direction
Select the sync direction:
- Pull — Import data from Salesforce into your sheet
- Push — Export data from your sheet to Salesforce
- Bidirectional — Sync in both directions
Sync Directions
- Pull (Salesforce → Sheet)
- Push (Sheet → Salesforce)
- Bidirectional
Import contacts or accounts from Salesforce into your sheet:
- All mapped fields are pulled from Salesforce
- New rows are created for each record
- Both standard and custom Salesforce fields are supported
Custom Fields
Salesforce custom fields are fully supported:- Custom fields appear alongside standard fields in the field mapping interface
- Map them to any sheet column just like standard fields
- Custom field values are synced in both pull and push directions
- Salesforce custom fields typically end in
__c(e.g.,Research_Area__c)
Sync Tracking
Each sync operation is tracked with:- Event type — Pull, push, or bidirectional
- Records processed — Number of contacts/accounts synced
- Errors — Any records that failed to sync, with error details
- Timestamp — When the sync occurred
Troubleshooting
Fields not appearing in mapping
Fields not appearing in mapping
- Verify the field exists in your Salesforce org
- Check that your Salesforce user profile has field-level security access
- Custom fields need to be visible to the API user — check field accessibility settings
Sync creates duplicates
Sync creates duplicates
- Ensure your field mappings include a unique identifier (typically
Emailfor contacts) - Use the pull direction first to import existing records before pushing new data
Permission errors
Permission errors
- Verify the Salesforce account used has API access enabled
- Check that the user profile has CRUD access on the relevant objects (Contact, Account)
- Salesforce API access requires appropriate edition (Enterprise, Unlimited, or Developer)
- Try disconnecting and reconnecting the integration
API limits
API limits
Salesforce enforces daily API call limits based on your edition:
- Large syncs may consume significant API calls
- Monitor your API usage in Salesforce Setup under “API Usage Notifications”
- Consider syncing during off-peak hours for large datasets
Disconnecting
To remove the Salesforce integration:- Go to Settings → Integrations
- Find the Salesforce integration
- Click Disconnect
- Confirm the removal
