How to Sync Salesforce and Google Sheets Contacts with N8n

Workflows > Add workflow

Create new N8n workflow

Start a fresh workflow in N8n and configure it for bi-directional sync. This workflow will need two separate branches - one for each sync direction.

1. 1Click 'Add workflow' from the N8n dashboard
2. 2Name it 'Salesforce-Sheets Contact Sync'
3. 3Click 'Save' to create the workflow

Node Library > Triggers > Salesforce

Add Salesforce trigger for Contact updates

Set up the Salesforce trigger to fire when contacts are modified. This catches updates made directly in Salesforce.

1. 1Click the '+' button to add first node
2. 2Search for 'Salesforce Trigger'
3. 3Select 'On Updated Record'
4. 4Choose 'Contact' as the object type
5. 5Set polling interval to 5 minutes

Credentials > Salesforce > OAuth2

Connect Salesforce credentials

Authenticate with your Salesforce org using OAuth2. N8n needs read/write access to Contact records.

1. 1Click 'Create New' under Credentials
2. 2Select 'OAuth2' authentication method
3. 3Paste your Salesforce Connected App Consumer Key
4. 4Paste Consumer Secret and authorize
5. 5Test the connection

Node Library > Apps > Google Sheets

Add Google Sheets node for Salesforce updates

Connect the node that will update your Google Sheets when Salesforce contacts change. This completes the first sync direction.

1. 1Add new node after Salesforce trigger
2. 2Select 'Google Sheets'
3. 3Choose 'Update' operation
4. 4Select your target spreadsheet
5. 5Map Contact fields to sheet columns

Node Library > Triggers > Google Sheets

Set up Google Sheets webhook trigger

Add a second trigger for when Google Sheets rows change. This requires a separate execution branch for the reverse sync direction.

1. 1Click 'Add Trigger' to create second branch
2. 2Select 'Google Sheets Trigger'
3. 3Choose 'On Row Updated' event
4. 4Select the same spreadsheet from step 4
5. 5Configure which columns to monitor for changes

Node Library > Apps > Salesforce

Add Salesforce update node

Complete the reverse sync by adding a Salesforce node that updates contacts when Google Sheets changes. This creates true bi-directional sync.

1. 1Add new node after Google Sheets trigger
2. 2Select 'Salesforce'
3. 3Choose 'Update' operation
4. 4Select 'Contact' as object type
5. 5Map sheet columns back to Salesforce fields

Node Library > Logic > If

Add duplicate prevention logic

Prevent infinite loops where updates trigger counter-updates. Use a filter to check if the change originated from the sync itself.

1. 1Add 'If' node before each update operation
2. 2Set condition to check LastModifiedBy field
3. 3Filter out changes made by your integration user
4. 4Connect 'true' path to update nodes

Google Sheets Node > Parameters > Field Mapping

Configure field mappings

Map specific contact fields between both systems. Focus on the fields your team actually uses to avoid syncing unnecessary data.

1. 1Open the Google Sheets update node
2. 2Map Salesforce Contact.FirstName to Sheet column A
3. 3Map Contact.LastName to column B
4. 4Map Contact.Email to column C
5. 5Add any custom fields your team tracks

Workflow Settings > Error Handling

Add error handling

Configure what happens when syncs fail due to API limits, network issues, or data validation errors. This prevents silent failures.

1. 1Click workflow settings gear icon
2. 2Enable 'Continue on Fail' for both update nodes
3. 3Add 'Set' node after each update to log success
4. 4Connect error paths to notification node

Workflow > Execute Workflow

Test with sample data

Run a controlled test with one contact record to verify both sync directions work correctly before enabling for all data.

1. 1Create a test contact in Salesforce
2. 2Click 'Execute Workflow' to trigger manually
3. 3Verify the contact appears in Google Sheets
4. 4Update the sheet row and confirm Salesforce reflects the change

Workflow > Activate

Enable workflow and monitor

Activate the workflow for production use and set up monitoring to catch sync issues early. Both triggers will now run automatically.

1. 1Click the toggle to activate workflow
2. 2Set up email notifications for failed executions
3. 3Monitor the execution log for first 24 hours
4. 4Document any field mapping adjustments needed

Drop this into an n8n Code node.

// Add this to a Code node for phone number standardization
const phone = items[0].json.Phone;
if (phone) {

// Add this to a Code node for phone number standardization
const phone = items[0].json.Phone;
if (phone) {
  // Remove all non-digits and format consistently
  const cleaned = phone.replace(/\D/g, '');
  items[0].json.Phone = cleaned.length === 10 ? cleaned : phone;
}
return items;