Table of Contents
When working with Gemini AI for Sheets, mastering the art of writing prompts is crucial.
Four Key Components of a Prompt
- Persona: Specify who the AI should embody or address.
- Task: Clearly define the task you need the AI to accomplish.
- Context: Provide necessary background information for the task.
- Format: Indicate the desired structure of the response, such as bullet points or paragraphs.
Examples of Effective Prompts
Example 1: Email Drafting
“You are a analytics team manager. Draft an executive summary email to [persona] based on [details about relevant program docs]. Limit to bullet points.”
Example 2: Customer Service Scenario
“Help me craft an empathetic email response. I am a customer service representative, and I need to create a response to a customer complaint. The customer ordered a pair of headphones that arrived damaged. They’ve already contacted us via email and provided pictures of the damage. I’ve offered a replacement, but they’re requesting an expedited shipping option that isn’t typically included with their order. Include a paragraph that acknowledges their frustration and three bullet points with potential resolutions.”
Example 3: Team Communication
“Suggest 10 alternative options in place of expedited shipping to resolve the customer’s frustration about receiving the damaged package.”
Example 4: Content Creation
“Draft templates for three different types of customer communication. Create a template for apology emails, order confirmation messages, and thank you notes for loyal customers. Keep each template to one paragraph and use a friendly tone.”
Example 5: Strategic Email
“Draft an email to my colleagues proposing a meeting to discuss customer experience improvement initiatives. Request that marketing, sales, and product stakeholders meet in the next week to get a clear sense of roles and responsibilities.”
Example 6: Project Management
“Create a table to track the progress and impact of different customer experience improvement tactics using relevant metrics including support ticket volume and priority level (high, medium, low).”
Example 7: Executive Communication
“Draft an email confirming that I will be at the board meeting. Ask if we can adjust the agenda to give 15 minutes to [urgent topics].”
Example 8: Marketing Strategy
“Generate a list of four relevant and engaging thought leadership blog post ideas for [company] based on trending topics, target audience analysis, and brand keywords.”
Example 9: Sales Strategy
“Write an email to [name], the new [title] at [company]. Congratulate them on their new role. Introduce me as their contact point at [company name]. Invite them to lunch next week and check if they prefer Monday or Tuesday.”
These examples demonstrate how using the four key components of effective prompts—Persona, Task, Context, and Format—can significantly enhance clarity and effectiveness in your communications with AI.