{"product_id":"gohighlevel-custom-fields-from-google-sheets-slack-alerts","title":"GoHighLevel Custom Fields from Google Sheets | Slack Alerts","description":"\u003ch3\u003eBulk-create GoHighLevel custom fields from Google Sheets—with Slack error alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your \u003cstrong\u003eGoHighLevel (LeadConnector)\u003c\/strong\u003e business custom field definitions from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, creates only the fields that aren’t marked as done, and notifies your team in \u003cstrong\u003eSlack\u003c\/strong\u003e if anything fails.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual trigger:\u003c\/strong\u003e Start by clicking \u003cem\u003e“Execute workflow”\u003c\/em\u003e in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Sheets as the source of truth:\u003c\/strong\u003e Reads the \u003cstrong\u003e“Accounts Custom Fields”\u003c\/strong\u003e tab from Google Sheets and pulls columns such as \u003cstrong\u003eField Name\u003c\/strong\u003e, \u003cstrong\u003eSuggested Field Type\u003c\/strong\u003e, \u003cstrong\u003ekey\u003c\/strong\u003e, \u003cstrong\u003eStatus\u003c\/strong\u003e, \u003cstrong\u003eID\u003c\/strong\u003e, \u003cstrong\u003eLocation ID\u003c\/strong\u003e, and \u003cstrong\u003eParent Field ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches existing fields in GoHighLevel:\u003c\/strong\u003e Retrieves current business custom fields via the GoHighLevel (LeadConnector) API to avoid duplicates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses only UNDONE rows:\u003c\/strong\u003e Loops through each row and continues only when \u003cstrong\u003eStatus\u003c\/strong\u003e is \u003cstrong\u003e“UNDONE”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates fields in bulk:\u003c\/strong\u003e For each eligible row, creates the business custom field in GoHighLevel using the provided field name, data type, key, location ID, and parent field ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back to Google Sheets:\u003c\/strong\u003e Updates the sheet with the created \u003cstrong\u003efield ID\u003c\/strong\u003e and changes \u003cstrong\u003eStatus\u003c\/strong\u003e to \u003cstrong\u003eDone\u003c\/strong\u003e; if creation fails, marks the row as \u003cstrong\u003eError\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack alerts on execution errors:\u003c\/strong\u003e Sends a message to your selected Slack channel whenever the workflow hits an execution error.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eStandardize GoHighLevel custom field creation across multiple client\/location setups.\u003c\/li\u003e\n  \u003cli\u003eShip new account\/contact attributes by updating a Google Sheet, then running the workflow.\u003c\/li\u003e\n  \u003cli\u003eReduce setup time for SaaS operators managing repeated GoHighLevel configurations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth2 read\/write to the \u003cem\u003eAccounts Custom Fields\u003c\/em\u003e tab (row status tracking, field ID backfill).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoHighLevel (LeadConnector) via HTTP Request\u003c\/strong\u003e: Uses your \u003cstrong\u003ePrivate Integration token\u003c\/strong\u003e plus \u003cstrong\u003eLocation ID\u003c\/strong\u003e and \u003cstrong\u003eParent Field ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: OAuth2 error notifications to \u003cstrong\u003eYOUR_SLACK_CHANNEL_ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: if, slack, sticky note, http request, error trigger, google sheets.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962071605427,"sku":"N8N-19202","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qwtkk4r2oz3l4UDK-kgiY_j2MKobxH.png?v=1788599732","url":"https:\/\/buyflowscripts.com\/products\/gohighlevel-custom-fields-from-google-sheets-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}