使用 Perplexity、OpenAI 和 Google Doc 创建数据驱动的 UX 角色画像(描述和图像)
高级
这是一个Market Research, Multimodal AI领域的自动化工作流,包含 16 个节点。主要使用 SplitOut, GoogleDocs, Perplexity, FormTrigger, GoogleDrive 等节点。 使用 Perplexity、DALL·E 3 和 Google Doc 生成数据驱动的 UX 角色画像
前置要求
- •Google Drive API 凭证
- •OpenAI API Key
使用的节点 (16)
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "gdQ7R3obn4CWmI29",
"meta": {
"instanceId": "eb6cdf70dd526a1c97d7dcb6b9292757001af53236f7ca64a2582483540c6ee4",
"templateCredsSetupCompleted": true
},
"name": "使用 Perplexity、OpenAI 和 Google Doc 创建数据驱动的 UX 角色画像(描述和图像)",
"tags": [],
"nodes": [
{
"id": "13cb8a59-e5de-49dc-9d2f-a14c2f7fd12c",
"name": "表单提交时1",
"type": "n8n-nodes-base.formTrigger",
"position": [
2320,
112
],
"webhookId": "7184765b-f939-4d1c-b435-ad6d62b5caf8",
"parameters": {
"options": {},
"formTitle": "Creating Personas",
"formFields": {
"values": [
{
"fieldLabel": "Website url",
"placeholder": "Enter website url",
"requiredField": true
},
{
"fieldLabel": "Region"
},
{
"fieldLabel": "Inductry"
}
]
},
"formDescription": "This form is used to create personas for your service based on market research."
},
"typeVersion": 2.2
},
{
"id": "edb2152e-a8fd-415a-921d-13d7bb952b48",
"name": "更新文档1",
"type": "n8n-nodes-base.googleDocs",
"position": [
3376,
-96
],
"parameters": {
"actionsUi": {
"actionFields": [
{
"text": "={{ $json.output }}",
"action": "insert"
}
]
},
"operation": "update"
},
"credentials": {
"googleDocsOAuth2Api": {
"id": "QNNpAKDcqSbqCpbG",
"name": "Google Docs account 3"
}
},
"typeVersion": 2
},
{
"id": "2e4e8c52-e702-406d-bace-740ab2df1a6e",
"name": "OpenAI 聊天模型2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2864,
320
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "c0zo07KHkFyAOwYy",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.2
},
{
"id": "2d577fd4-e97a-4344-8940-8b588902214f",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1648,
0
],
"parameters": {
"color": 5,
"width": 520,
"height": 808,
"content": "***自动化数据驱动 UX 角色画像创建 – 立即试用!***"
},
"typeVersion": 1
},
{
"id": "79fc67ed-7b0b-4f78-9704-20c4b1db0176",
"name": "将提示解析为 JSON 数组",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
3552,
496
],
"parameters": {
"jsonSchemaExample": "[\n {\n \"prompt\": \"...\"\n },\n {\n \"prompt\": \"...\"\n },\n {\n \"prompt\": \"...\"\n }\n]"
},
"typeVersion": 1.2
},
{
"id": "be5b036d-bcc2-41ba-b697-4aebc8198dd4",
"name": "🔍 研究",
"type": "n8n-nodes-base.perplexity",
"position": [
2592,
112
],
"parameters": {
"model": "sonar-deep-research",
"options": {},
"messages": {
"message": [
{
"content": "=You are a user experience researcher and a Perplexity (research) prompt agent. Your task is to generate a UX personas for each segment based on credible market research and statistics. Use the following structured scope to guide your research and findings. Your output should be data-informed and well-cited with links to relevant sources.\n\n{{ $json['Website url'] }}{{ $json.Region }}{{ $json.Inductry }}\n⸻\n\n1. Business Overview\n\nProvide a brief summary of the business based on its website, industry, and regional context. Include an overview of all user segments relevant to the product/service. For each segment, provide:\n\t•\tSegment name\n\t•\tBrief description\n\t•\tEstimated size\nQuantify the potential market this segment represents. Include data such as:\n\t•\tTAM (Total Addressable Market)\n\t•\tCAGR (Compound Annual Growth Rate)\n\t•\tNumber of companies or professionals\n\t•\tRegional breakdown (if relevant)\n\nReference links:\n\t•\t[URL]\n\t•\t[URL]\n\n⸻\n\n2. Persona Descriptions\n\nDevelop a detailed persona profile for each user segment identified in the business overview. Use the following structure:\n\nA. Identify and describe a distinct user segment relevant to the query, grounded in market data. Include:\n\t•\tDemographic details (age, gender, location, income level)\n\t•\tPsychographics (lifestyle, behavior, interests)\n\t•\tJob roles or consumer type (if relevant)\n\nReference links:\n\t•\t[URL]\n\t•\t[URL]\n\n\n⸻\n\nB. Market Size\n\nEstimate the size of the target user group, including:\n\t•\tNumber of potential users/customers\n\t•\tGrowth rate (if available)\n\t•\tRelevant geographic distribution\n\nReference links:\n\t•\t[URL]\n\t•\t[URL]\n\n\n⸻\n\nC. User Needs\n\nList the primary needs or goals of this persona in relation to the product or service described in the query. Back your findings with:\n\t•\tBehavioral data\n\t•\tIndustry reports or surveys\n\t•\tRelevant UX research or trend reports\n\nReference links:\n\t•\t[URL]\n\t•\t[URL]\n\n\n⸻\n\nD. Pain Points\n\nDescribe key frustrations, obstacles, or unmet needs of the user segment. Support with:\n\t•\tUser feedback data\n\t•\tCustomer reviews or complaint summaries\n\t•\tResearch studies on the user experience\n\nReference links:\n\t•\t[URL]\n\t•\t[URL]\n\n\n⸻\n\nE. Usage Story\n\nWrite a concise story showing how this persona would interact with the product or service in a real-life scenario. The story should demonstrate:\n\t•\tMotivation to use\n\t•\tUsage context\n\t•\tKey touchpoints and emotional moments\n\t•\tOutcome\n\nReference links include to the output:\n\t•\t[URL]\n\t•\t[URL]\n\n"
}
]
},
"requestOptions": {}
},
"credentials": {
"perplexityApi": {
"id": "nxgDKDrFRajW3rls",
"name": "Perplexity account"
}
},
"typeVersion": 1
},
{
"id": "779f98ee-2f84-42ea-a8a9-06cec6724a4e",
"name": "角色画像描述",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2864,
112
],
"parameters": {
"text": "={{ $json.choices[0].message.content }}{{ $json.citations }}{{ $json.search_results }}",
"options": {
"systemMessage": "You are a helpful formatter assistant, you will receive a copy, your job is to format it.\n\nGoal:\nDevelop full personas descriptions tailored to different user groups. The personas will be used in a business case to illustrate target users, validate product–market fit, and guide go-to-market strategy.\n\n⸻\n\n📄 Output Format\n\n⸻\n\nPersona 1: [Name and Segment Title]\n\n⸻\n\n1. User Segment\n\nBrief overview of this group. Describe who they are (e.g., role, industry), what they do, and why they are relevant to the product or market.\nReference links:\n\t•\t[Include the full url of Source ] \n⸻\n\n2. Market Size\n\nQuantify the potential market this persona represents. Include data such as:\n\t•\tTAM (Total Addressable Market)\n\t•\tCAGR (Compound Annual Growth Rate)\n\t•\tNumber of companies or professionals\n\t•\tRegional breakdown (if relevant)\n\nReference links:\n\t•\t[Include the full url of Source]\n\t\n⸻\n\n3. User Needs\n\nWhat problems or goals does this persona need the product to solve or support?\n\nReference links:\n\t•\t[Include the full url of Source]\n\t\n⸻\n\n4. Pain Points\n\nDescribe typical challenges or friction this persona experiences.\n\nReference links:\n\t•\t[Include the full url of Source]\n\t\n\n⸻\n\n5. Usage Story\n\nA realistic story showing how this persona uses the product to solve problems or achieve goals.\n\n“As a [job title], I use the product to [action], which helps me [benefit].”\n\n– Format headings using Markdown‑style (e.g., `## Executive Summary`) so the Google Doc node will render them as section titles. \n- Copy Reference links section\n"
},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "2d6627be-3236-430f-95e9-604acd66a36f",
"name": "生成图像提示",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
3360,
288
],
"parameters": {
"text": "=",
"options": {
"systemMessage": "={{ $json.output }}\nCreate from this input a prompt for Image Generation for each persona based on Usage Story section.\n\n\nRequirements:\n400x400 pixel square, with no props or text, name the file using Persona title. One image for each Persona\n\nPlease return **only** a JSON array of objects, each with a single property `\"prompt\"` containing the image prompt. Example output structure:\n[\n {\n \"prompt\"...\"\n },\n {\n \"prompt\": \"...\"\n },\n {\n \"prompt\": \"...\"\n }\n]"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "b3652274-f800-4bdc-8807-124b60cafb20",
"name": "生成图像",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
4016,
288
],
"parameters": {
"prompt": "={{ $json.prompt }}",
"options": {},
"resource": "image"
},
"credentials": {
"openAiApi": {
"id": "c0zo07KHkFyAOwYy",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.8
},
{
"id": "b727493c-53ac-40b5-b2e4-dcd525f87232",
"name": "上传图像",
"type": "n8n-nodes-base.googleDrive",
"position": [
4224,
288
],
"parameters": {
"name": "={{ $now.format(\"yyyyMMddHHmmSSS\") }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "1kv3Yo3cKK6Vsd2sBQYUN2RsBL4E1KOW8",
"cachedResultUrl": "https://drive.google.com/drive/folders/1kv3Yo3cKK6Vsd2sBQYUN2RsBL4E1KOW8",
"cachedResultName": "n8n"
},
"inputDataFieldName": "=data"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "9mzZMaQ4UW0z9Q5T",
"name": "Google Drive account 2"
}
},
"typeVersion": 3
},
{
"id": "37946092-3323-4cd8-8472-5f4ab94a17f3",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
2496,
16
],
"parameters": {
"color": 5,
"width": 312,
"height": 376,
"content": "用户细分及其市场规模研究"
},
"typeVersion": 1
},
{
"id": "cba606d5-aa81-456e-aded-fb7c87537f60",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2832,
16
],
"parameters": {
"color": 4,
"width": 328,
"height": 440,
"content": "角色画像描述创建"
},
"typeVersion": 1
},
{
"id": "442d43ce-ec95-4de9-aa77-c46fa82b8ba9",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3312,
240
],
"parameters": {
"color": 7,
"width": 360,
"height": 456,
"content": "为每个角色画像创建生成图像的提示"
},
"typeVersion": 1
},
{
"id": "19c19e43-c318-4978-856c-aafb98e6261a",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
3952,
240
],
"parameters": {
"color": 6,
"width": 472,
"height": 456,
"content": "生成图像并上传至 Google Drive"
},
"typeVersion": 1
},
{
"id": "4b0eac98-81ee-4b60-90a0-be6d35c01313",
"name": "GPT-4o",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
3360,
480
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "c0zo07KHkFyAOwYy",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.2
},
{
"id": "1b7144ac-6147-4f24-a02e-9c491176ae01",
"name": "拆分提示",
"type": "n8n-nodes-base.splitOut",
"position": [
3776,
288
],
"parameters": {
"options": {
"includeBinary": true
},
"fieldToSplitOut": "output"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "472470fe-db1d-4fab-9751-e89d980f4e4c",
"connections": {
"GPT-4o": {
"ai_languageModel": [
[
{
"node": "Generate Prompts for Images",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Split Prompts": {
"main": [
[
{
"node": "Generate images",
"type": "main",
"index": 0
}
]
]
},
"Upload images": {
"main": [
[]
]
},
"🔍 Research": {
"main": [
[
{
"node": "Personas descriptions",
"type": "main",
"index": 0
}
]
]
},
"Generate images": {
"main": [
[
{
"node": "Upload images",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model2": {
"ai_languageModel": [
[
{
"node": "Personas descriptions",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"On form submission1": {
"main": [
[
{
"node": "🔍 Research",
"type": "main",
"index": 0
}
]
]
},
"Personas descriptions": {
"main": [
[
{
"node": "Update a document1",
"type": "main",
"index": 0
},
{
"node": "Generate Prompts for Images",
"type": "main",
"index": 0
}
]
]
},
"Generate Prompts for Images": {
"main": [
[
{
"node": "Split Prompts",
"type": "main",
"index": 0
}
]
]
},
"Parse Prompts into JSON Array": {
"ai_outputParser": [
[
{
"node": "Generate Prompts for Images",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
高级 - 市场调研, 多模态 AI
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
使用OpenAI处理UX访谈记录并生成摘要到Google Sheets
OpenAI UX访谈分析:转录并导出到Google Sheets
Filter
Split Out
Google Drive
+7
14 节点Gulfiia
市场调研
WordPress博客自动化专业版(深度研究)v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
使用GPT-4、Dumpling AI和Google Drive生成广告图片变体
使用GPT-4、Dumpling AI和Google Drive生成广告图片变体
Split Out
Form Trigger
Google Drive
+8
14 节点Yang
内容创作
使用 Dumpling AI + GPT-4o 将 Reddit 痛点转化为漫画广告
使用Dumpling AI和GPT-4o将Reddit痛点转换为漫画广告
If
Set
Reddit
+12
31 节点Yang
内容创作
使用GPT-5 nano和Google Sheets抓取网站并回答问题
使用GPT-5 nano和Google Sheets抓取网站并回答问题
If
Set
Xml
+17
44 节点Oriol Seguí
市场调研
💥 使用NanoBanana、Seedream 4、ChatGPT Image和Veo 3自动化视频广告 - VIDE
使用AI(NanoBanana、Seedream、GPT-4o、Veo 3)自动化和发布视频广告活动
Set
Code
Wait
+16
63 节点Dr. Firas
内容创作