Data synchronization from Salesforce to Google Sheets

• Automate the synchronization of company data between Salesforce and Google Sheets.
• Reduce manual data entry by automatically creating and updating Salesforce accounts.
• Ensure accurate and up-to-date contact information for companies in Salesforce.

Download a spreadsheet file containing company information. Search for existing Salesforce accounts based on company names. Merge new and existing company data to eliminate duplicates. Create new Salesforce accounts if they do not already exist. Retrieve and create associated contacts for each account.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure Salesforce credentials for account access.
3. 3
   Set the URL for the spreadsheet file download.
4. 4
   Map the fields in the spreadsheet to the corresponding Salesforce fields.