{"product_id":"migrate-salesforce-accounts-to-gohighlevel-via-google-sheets","title":"Migrate Salesforce Accounts to GoHighLevel via Google Sheets","description":"\u003ch3\u003eMigrate Salesforce Accounts into GoHighLevel from Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow manually migrates Salesforce \u003cstrong\u003eAccount\u003c\/strong\u003e records stored in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e into \u003cstrong\u003eGoHighLevel\u003c\/strong\u003e Business records using the \u003cstrong\u003eLeadConnector API\u003c\/strong\u003e. It creates the business, updates a GoHighLevel custom object with Salesforce fields, bulk-associates related contacts, and logs progress and errors back to Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand\u003c\/strong\u003e: execute by clicking \u003cem\u003eExecute workflow\u003c\/em\u003e in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads pending rows\u003c\/strong\u003e: pulls Salesforce Account rows marked \u003cstrong\u003eNOT DONE\u003c\/strong\u003e from a Google Sheets tab and applies a \u003cstrong\u003ebatch size limit\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks migration progress\u003c\/strong\u003e: processes each account sequentially and marks the row as \u003cstrong\u003eDONE\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates GoHighLevel Business records\u003c\/strong\u003e: uses the \u003cstrong\u003eLeadConnector API\u003c\/strong\u003e to create a Business record with mapped fields such as \u003cstrong\u003ename, address, phone, website, and description\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates a GoHighLevel custom object\u003c\/strong\u003e: writes Salesforce-specific properties (e.g., \u003cstrong\u003eAccount ID, Parent ID, price book\u003c\/strong\u003e, and other mapped attributes) via the LeadConnector API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAssociates related contacts\u003c\/strong\u003e: looks up GoHighLevel contact IDs in a separate Google Sheets \u003cstrong\u003econtacts\u003c\/strong\u003e tab by Salesforce Account ID, then bulk-associates those contacts to the new GoHighLevel Business (if present).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Sheets\u003c\/strong\u003e: stores successful GoHighLevel Business IDs and logs errors for business creation, custom object updates, and contact association in dedicated error tabs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMove legacy Salesforce Accounts into GoHighLevel during CRM cutover.\u003c\/li\u003e\n  \u003cli\u003eIteratively migrate records in controlled batches, using Google Sheets as the staging layer.\u003c\/li\u003e\n  \u003cli\u003eBackfill GoHighLevel custom object fields and ensure contacts are linked to the correct migrated businesses.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes\u003c\/strong\u003e: if, code, limit, sticky note, http request, google sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI integration\u003c\/strong\u003e: GoHighLevel \u003cstrong\u003eLeadConnector API\u003c\/strong\u003e via \u003cstrong\u003eHTTP Request\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuthentication\u003c\/strong\u003e: create a GoHighLevel private integration token and replace \u003ccode\u003eYOUR_GHL_API_TOKEN\u003c\/code\u003e in the \u003cstrong\u003eAuthorization\u003c\/strong\u003e header for every LeadConnect call.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962071933107,"sku":"N8N-19200","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/m7oxrIHvkvd-nT77FvVAt_MLVxCW48.png?v=1788599778","url":"https:\/\/buyflowscripts.com\/products\/migrate-salesforce-accounts-to-gohighlevel-via-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}