← All N8N workflows
AI & researchAgentCodeGoogle Docs ToolGoogle Sheets ToolHTTP Request

Customer Experience Agent (AI)

Configured with Agent, Google Docs Tool, Google Sheets Tool, HTTP Request, and additional nodes. Review the connections and setup before adapting this template.

Workflow preview
AI & modelsCustomer Lead AI AgentAgentAI & modelsOpenAI Chat ModelOpenAI Chat ModelData storeAbbriviationsGoogle Sheets ToolTransformLead BodyEdit FieldsRoutingSource Website andStatus OpenIfMessagingMicrosoft OutlookMicrosoft OutlookTransformEmail Body TextGenerated by AIEdit FieldsCodeFields for OutlookCodeCodeEmail Body for OutlookCodeRoutingInquiry has NotesIfRoutingInquiry is Valid?IfFiles / mediaCompany ProfileGoogle Docs ToolFiles / mediaCompany PoliciesGoogle Docs ToolData storeCompany ContactDatabaseGoogle Sheets ToolWeb / APIGet Lead Data fromERPNextHTTP RequestTriggerWebhookWebhook

Node categories in this workflow

  • AI & models
  • Data store
  • Transform
  • Routing
  • Messaging
  • Code
  • Files / media
  • Web / API
  • Trigger

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Customer Lead AI AgentAI & modelsAgentSee node parameters
OpenAI Chat ModelAI & modelsOpenAI Chat ModelSee node parameters
AbbriviationsData storeGoogle Sheets ToolSee node parameters
Lead BodyTransformEdit FieldsSee node parameters
Source Website and Status OpenRoutingIfSee node parameters
Microsoft OutlookMessagingMicrosoft OutlookSee node parameters
Email Body Text Generated by AITransformEdit FieldsSee node parameters
Fields for OutlookCodeCodeSee node parameters
Email Body for OutlookCodeCodeSee node parameters
Inquiry has NotesRoutingIfSee node parameters
Inquiry is Valid?RoutingIfSee node parameters
Company ProfileFiles / mediaGoogle Docs Toolget
Company PoliciesFiles / mediaGoogle Docs Toolget
Company Contact DatabaseData storeGoogle Sheets ToolSee node parameters
Get Lead Data from ERPNextWeb / APIHTTP RequestSee node parameters
WebhookTriggerWebhookSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • erpNextApi
  • googleDocsOAuth2Api
  • googleSheetsOAuth2Api
  • microsoftOutlookOAuth2Api
  • openAiApi

Workflow notes

Filter the Lead

Filter the Lead

I have done only for theose which are open and where the source is Website. You can remove this if you want to have all leads.

Output from AI Agent

Output from AI Agent

If the INquiry is invalid, not related to the products and services offered, it will invalidate that you can optionnally link the invalid output to email or anything. Options are limitless

Customer Experience Agent (AI)

Customer Experience Agent (AI)

Now this Node is an AI Agent who is speicalized to understand the Lead Source and the Inquiry sent by Cusomter. The Agent will look at company information, which has detials of producuts and services defined in Google Docs, and the Contacts Sheet where a column must be added mentioning that who is the person dealing in which products, solutions and services. Once the inquiry is about speicifc product solution and service it will look from the sheet and then will decide to whom the email has to be sent. Details is defined in the Agent. Make sure to drag fields from http request node

Once the Lead is generatd in ERP

Once the Lead is generatd in ERP

Consider creating creating an inquiry web form in ERPNext and let the Website Visitor fill that Inquiry form, as soon as the iqnuiry form is filled this workflow will start.

Make sure to create a webhook in ERPNext. Follow Below steps in ERPNext.

Go to Wehbooks Doctype : Lead Trigger : on_insert

Paste this webhook there, as test first and finally production

Email Body

Email Body

Get only Email body from Previous Node and then Convert this to HTML Format so that it looks professional.

Get Lead ID

Get Lead ID

This will extract the Lead Name in ERPNext. Ensure to send doc.name from the webhook in ERPnext

It will then send this to next node to get full details of this lead.

Send Email

Send Email

Now drag and drop the fields from Previous Nodes. Email Addresses Subject and Body.

Remember all fields are selected by AI Agent, whom to send email, what to send and so on.

You can alternatively inform your employees by whatsapp for quick action.

Developed by Amjid Ali

Developed by Amjid Ali

Thank you for using this workflow template. It has taken me countless hours of hard work, research, and dedication to develop, and I sincerely hope it adds value to your work.

If you find this template helpful, I kindly ask you to consider supporting my efforts. Your support will help me continue improving and creating more valuable resources.

You can contribute via PayPal here:

http://paypal.me/pmptraining

For Full Course about ERPNext or Automation using AI follow below link

http://lms.syncbricks.com

Additionally, when sharing this template, I would greatly appreciate it if you include my original information to ensure proper credit is given.

Thank you for your generosity and support! Email : user@example.com https://linkedin.com/in/amjidali https://syncbricks.com https://youtube.com/@syncbricks

Inquiry with Notes

Inquiry with Notes

If inquiry is having notes then only it will forward to next node.

Prepare for Email

Prepare for Email

This node will get approprate Fields for Email Email Addresses: Subject : Email Body :

Customer Experience Agent (AI)

Customer Experience Agent (AI)

Purpose and structure

This folder contains the Customer Experience Agent (AI) workflow. Its executable nodes use agent, code, googleDocsTool, googleSheetsTool, httpRequest, if, lmChatOpenAi, microsoftOutlook, set, webhook. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Webhook

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Code/0693_Code_Webhook_Create_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Get Details of Lead from ERPNext. For us most important is Notes

More in AI & research