Create Salesforce Accounts & Contacts from Google Sheets

This no-code n8n workflow streamlines CRM data management by pulling company and contact information from a Google Sheets spreadsheet and synchronizing it with Salesforce. It begins by reading rows from the specified Google Sheet, then searches for matching accounts by name in Salesforce. If an account doesn't exist, it creates a new one; otherwise, it uses the existing record. Data is normalized across branches before converging to create or update associated contacts.

The workflow employs conditional logic via branching nodes, ensuring efficient handling of new versus existing data without manual intervention. Setup is straightforward: authenticate Google Sheets and Salesforce in n8n, input the sheet ID, and execute. This prevents data silos and duplication common in manual entry processes.

Ideal for sales teams onboarding leads from spreadsheets, marketing campaigns importing prospect lists, or any scenario requiring bulk CRM population. Benefits include time savings (automates hours of manual work), reduced errors, scalability for large datasets, and seamless integration between popular tools, boosting productivity in CRM workflows.