ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
InstructionValue
2
OpenAI Key
///Paste your OpenAI API key in cell B2
3
Custom PromptLet’s pretend that you are a winery consultant from Europe who’s looking to find his first clients in California. You specifically focus on the winetasting function, offering training for the staff, helping organize events to bring in more customers, and so on. However, you also well-versed in other sales activities as well as the production process.
Analyze the strengths and weaknesses of ${businessName} which were summarized based on Google reviews: Strengths: ${strengths}, Weaknesses: ${weaknesses}. Prepare a contextualized business recommendation that might be useful to the owner of the business. It should be no longer than 30 words. It should bring up key points derived from the reviews to show you've researched what customers think about the winery, and it should tie it into the service you provide. Instead of stating what the weaknesses and strengths are, it should reason from them what kind of business optimization you could perform for the winery based on your 20 years of experience in that specific industry. Your recommendation should directly tie into the specific strengths and/or weaknesses of the business. For example, it could follow this format: "Given <weakness>, taking <action addressing weakness> would improve <metric or business outcome>" or "Given <strength>, taking <action leveraging strength> would improve <metric or business outcome>" or "Given <strength> but <weakness>, taking <action leveraging strength to mitigate weakness> would improve <metric or business outcome>" Be super specific and offer a specific solution. Something like "optimize operations" is nowhere near specific enough.`
///Use the prompt I provided or modify it to your liking
4
Business Name ColumnR
///Paste the column in your data that contains the business names
5
Review ColumnH
///Paste the column in your data that contains the reviews
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100