Skip to content
99AICREATORCREATE WHAT’S NEXT.
99AI / YOUR EVERYDAY AI LIBRARY↗

Agent prompts.
Ideas into action.

Make the goal clear. Give AI a useful brief.
From research to organisation, find a starting point for your next task.

Explore the library99 task prompts

THE LIBRARY / 099 RESOURCES

Turn a goal into a useful brief.

HOW TO USE THE LIBRARY

99 resources

001Content Creation & Marketing

Write a 1,500-word blog post on the topic of 'The Future of AI in Marketing…

Write a 1,500-word blog post on the topic of 'The Future of AI in Marketing.' The tone should be informative and engaging for an audience of marketing professionals. Include sections on personalization, predictive analytics, and content automation. Please include relevant statistics and cite your sources.

002Content Creation & Marketing

Create a social media campaign plan for the launch of a new eco-friendly wa…

Create a social media campaign plan for the launch of a new eco-friendly water bottle. The campaign should target millennials on Instagram and Facebook. Include 5 post ideas with visuals and captions, relevant hashtags, and a suggested posting schedule for one week.

003Content Creation & Marketing

I'm writing a series of articles about sustainable fashion. Research and pr…

I'm writing a series of articles about sustainable fashion. Research and provide a list of 20 long-tail keywords with high search volume and low competition. For each keyword, provide the search volume and a brief explanation of the user intent.

004Content Creation & Marketing

Write a 5-minute video script for a YouTube video titled '10 Tips for a Mor…

Write a 5-minute video script for a YouTube video titled '10 Tips for a More Productive WFH Day.' The script should be conversational and include visual cues for B-roll footage and on-screen text.

005Content Creation & Marketing

Create the content for a 5-page website for a new coffee shop. The pages ar…

Create the content for a 5-page website for a new coffee shop. The pages are: Home, About Us, Menu, Blog, and Contact. The tone should be warm and inviting. The menu should include a variety of coffee drinks, teas, and pastries.

006Content Creation & Marketing

Generate a welcome email series for a new online course platform. The serie…

Generate a welcome email series for a new online course platform. The series should consist of three emails: one sent immediately upon signup, one three days later, and one a week later, with the goal of onboarding the user and encouraging them to start their first course.

007Content Creation & Marketing

Generate ten episode ideas for a podcast about the digital nomad lifestyle.…

Generate ten episode ideas for a podcast about the digital nomad lifestyle. Each idea should include a catchy title and three to four talking points.

008Business & Finance

Conduct a market analysis of the electric vehicle (EV) industry. The report…

Conduct a market analysis of the electric vehicle (EV) industry. The report should include an overview of the market size, key players, recent trends, and future projections. Please present the findings in a slide deck with charts and graphs.

009Business & Finance

Analyze the Q1 2025 financial performance of Tesla (TSLA). The analysis sho…

Analyze the Q1 2025 financial performance of Tesla (TSLA). The analysis should include a review of the income statement, balance sheet, and cash flow statement. Summarize the key findings and provide a recommendation for potential investors.

010Business & Finance

Create a detailed business plan outline for a new subscription box service…

Create a detailed business plan outline for a new subscription box service for dog owners. The outline should include sections for the executive summary, company description, market analysis, organization and management, marketing and sales strategy, and financial projections.

011Business & Finance

Identify and analyze the top 3 competitors for a new project management sof…

Identify and analyze the top 3 competitors for a new project management software. The analysis should compare features, pricing, and customer reviews. Present the information in a table for easy comparison.

012Business & Finance

I am looking for a reliable supplier of organic cotton t-shirts for my new…

I am looking for a reliable supplier of organic cotton t-shirts for my new clothing brand. Research and provide a list of 5 potential suppliers based in North America. For each supplier, include their contact information, minimum order quantity, and pricing.

013Business & Finance

Draft a preliminary Term Sheet for a seed funding round for a tech startup.…

Draft a preliminary Term Sheet for a seed funding round for a tech startup. It should include valuation, investment amount, equity type, and key protective provisions.

014Business & Finance

Analyze the performance of the S&P 500 over the last five years and compare…

Analyze the performance of the S&P 500 over the last five years and compare it to the NASDAQ 100. Summarize which index performed better and explain the likely reasons why.

015Productivity & Automation

Create a set of 5 email templates for a freelance writer. The templates sho…

Create a set of 5 email templates for a freelance writer. The templates should cover common scenarios such as pitching a new client, following up on a pitch, sending an invoice, and requesting a testimonial.

016Productivity & Automation

Generate a meeting agenda for a project kick-off meeting for a new mobile a…

Generate a meeting agenda for a project kick-off meeting for a new mobile app development project. The agenda should include a list of attendees, topics for discussion, and time allocations for each topic.

017Productivity & Automation

Plan a 7-day trip to Japan for two adults in April. The itinerary should in…

Plan a 7-day trip to Japan for two adults in April. The itinerary should include a mix of cultural experiences, sightseeing, and culinary activities. Please include recommendations for flights, accommodations, and transportation.

018Productivity & Automation

I have a folder of 50 resumes for a 'Software Engineer' position. Please sc…

I have a folder of 50 resumes for a 'Software Engineer' position. Please screen the resumes and shortlist the top 5 candidates based on their experience with Python, and machine learning. For each shortlisted candidate, provide a brief summary of their qualifications.

019Productivity & Automation

I have a spreadsheet of 1,000 customer contacts. The data is messy and need…

I have a spreadsheet of 1,000 customer contacts. The data is messy and needs to be cleaned and organized. Please format the data into a clean table with columns for 'First Name,' 'Last Name,' 'Email,' and 'Phone Number.' Remove any duplicate entries.

020Development & Technical

Write a Python script that scrapes the headlines from the BBC News homepage…

Write a Python script that scrapes the headlines from the BBC News homepage and saves them to a CSV file. The script should be well-commented and handle potential errors.

021Development & Technical

I want to integrate the Stripe API into my e-commerce website to process pa…

I want to integrate the Stripe API into my e-commerce website to process payments. Provide a step-by-step guide on how to do this, including code examples in JavaScript.

022Development & Technical

I have a static website built with HTML, CSS, and JavaScript. I want to dep…

I have a static website built with HTML, CSS, and JavaScript. I want to deploy it to Netlify. Provide a step-by-step guide on how to do this, from creating a new site to setting up continuous deployment from a GitHub repository.

023Development & Technical

Create a simple weather application that displays the current weather for a…

Create a simple weather application that displays the current weather for a given city. The app should have a clean user interface and use a free weather API. Provide the complete source code in React.

024Development & Technical

I have a Python script that is supposed to send an email, but it's throwing…

I have a Python script that is supposed to send an email, but it's throwing an error. Here is the code and the error message. Please analyze the code, identify the bug, and provide the corrected code.

025Creative & Miscellaneous

Create an outline for an online course on the basics of graphic design. The…

Create an outline for an online course on the basics of graphic design. The course should be aimed at beginners and cover topics such as color theory, typography, and layout. The outline should include a list of modules, lessons, and practical exercises.

026Creative & Miscellaneous

I want to learn how to play the guitar. Create a personalized 3-month learn…

I want to learn how to play the guitar. Create a personalized 3-month learning plan for me. I am a complete beginner and can practice for 30 minutes a day. The plan should include a list of resources such as online tutorials, and practice exercises.

027Creative & Miscellaneous

I have chicken, broccoli, and rice in my fridge. Generate 3 different healt…

I have chicken, broccoli, and rice in my fridge. Generate 3 different healthy and easy-to-make dinner recipes using these ingredients. Each recipe should include a list of ingredients, step-by-step instructions, and nutritional information.

028Creative & Miscellaneous

Write a short story (around 1,000 words) in the science fiction genre. The…

Write a short story (around 1,000 words) in the science fiction genre. The story should be about a group of astronauts who discover a new planet and must decide whether to colonize it. The tone should be suspenseful and thought-provoking.

029Creative & Miscellaneous

Compose a 2-minute piece of instrumental music in the style of lo-fi hip-ho…

Compose a 2-minute piece of instrumental music in the style of lo-fi hip-hop. The music should be relaxing and suitable for studying or working. Provide the music in a MIDI file format.

030Research & Info Gathering

Search the latest news from the past 24 hours on major news websites (like…

Search the latest news from the past 24 hours on major news websites (like BBC News, Reuters, and Associated Press) and provide a summary of the top 5 global headlines. For each headline, include a link to the source article.

031Research & Info Gathering

Visit the websites of the top 3 electric vehicle manufacturers (Tesla, BYD,…

Visit the websites of the top 3 electric vehicle manufacturers (Tesla, BYD, and Volkswagen). Find their latest quarterly reports and summarize the key findings regarding production numbers and sales growth. Present the information in a table for easy comparison.

032Research & Info Gathering

Go to the websites of three project management software companies: Asana, T…

Go to the websites of three project management software companies: Asana, Trello, and Monday.com. Find their pricing pages and create a feature comparison table for their entry-level paid plans. Include the price, number of users, and key features for each.

033Research & Info Gathering

Search Google Scholar and other academic databases for the top 5 most cited…

Search Google Scholar and other academic databases for the top 5 most cited research papers on the topic of 'Reinforcement Learning from Human Feedback' published in the last three years. Provide the title, authors, and a link to each paper.

034Research & Info Gathering

Find the official biography of the current CEO of Microsoft, Satya Nadella,…

Find the official biography of the current CEO of Microsoft, Satya Nadella, on the Microsoft website. Additionally, search for three recent interviews he has given and summarize his key statements on the future of AI.

035Data Extraction & Comparison

I want to buy a new Sony WH-1000XM5 headset. Search for this product on Ama…

I want to buy a new Sony WH-1000XM5 headset. Search for this product on Amazon, Best Buy, and the official Sony website. Find the current price on each site and provide a link to the product page. Indicate which site has the lowest price.

036Data Extraction & Comparison

Search for the top-rated Italian restaurants in Chicago on Yelp and TripAdv…

Search for the top-rated Italian restaurants in Chicago on Yelp and TripAdvisor. Create a list of the top 3 restaurants that appear on both platforms, including their rating, address, and a link to their menu if available.

037Data Extraction & Comparison

Search for flights from New York (JFK) to London (LHR) for a one-week trip…

Search for flights from New York (JFK) to London (LHR) for a one-week trip next month. Use Google Flights and Kayak to find the best deals on round-trip tickets. Provide the airline, price, and travel dates for the top 3 options.

038Data Extraction & Comparison

Find hotels in Paris, France, for a 3-night stay from August 10th to August…

Find hotels in Paris, France, for a 3-night stay from August 10th to August 13th. Search on Booking.com and Expedia for hotels with a rating of 4 stars or higher and a price under $200 per night. List the top 3 options with their prices and a link to book.

039Data Extraction & Comparison

Search for 'remote data analyst' jobs posted in the last week on LinkedIn,…

Search for 'remote data analyst' jobs posted in the last week on LinkedIn, Indeed, and Glassdoor. Compile a list of 5 job postings that match this criteria, including the company name, a brief job description, and a direct link to the application page.

040Online Task Automation

Visit the following URL: [insert a long article link here] and provide a 5-…

Visit the following URL: [insert a long article link here] and provide a 5-bullet point summary of the key arguments and conclusions presented in the article.

041Online Task Automation

Navigate to the contact form on the OpenAI website. Fill in the form with t…

Navigate to the contact form on the OpenAI website. Fill in the form with the following information: Name - John Doe, Email - mailto:john.doe@email.com, Message - 'I am interested in learning more about your API services.' (Note: This is a hypothetical task and should not be executed to avoid spam).

042Online Task Automation

Search Twitter for mentions of the hashtag #AIforGood in the last 24 hours.…

Search Twitter for mentions of the hashtag #AIforGood in the last 24 hours. Summarize the general sentiment of the tweets and highlight any particularly insightful or popular posts.

043Online Task Automation

Go to the Coursera website and search for a beginner-level Python programmi…

Go to the Coursera website and search for a beginner-level Python programming course. Find the most popular one based on student reviews and provide a link to the course enrollment page.

044Online Task Automation

Find the official website for the 'Web Summit 2025' conference. Navigate to…

Find the official website for the 'Web Summit 2025' conference. Navigate to the registration page and find the price for a general attendee ticket. Provide the price and a link to the registration page.

045Content & SEO

I am writing a blog post about 'healthy breakfast ideas.' Use Google's Keyw…

I am writing a blog post about 'healthy breakfast ideas.' Use Google's Keyword Planner (or a similar tool) to find 10 related long-tail keywords with high search volume. For each keyword, provide the monthly search volume.

046Content & SEO

Analyze the content of this webpage: [insert URL]. Based on the content, ge…

Analyze the content of this webpage: [insert URL]. Based on the content, generate three different meta descriptions (under 160 characters) that are optimized for search engines and include the primary keyword.

047Content & SEO

Use a tool like Ahrefs or SEMrush (or a free alternative) to analyze the ba…

Use a tool like Ahrefs or SEMrush (or a free alternative) to analyze the backlink profile of a competitor's website: [insert competitor URL]. Identify their top 5 referring domains and the type of content that is attracting these links.

048Content & SEO

Visit the product page for the new iPhone on the Apple website. Based on th…

Visit the product page for the new iPhone on the Apple website. Based on the information provided, generate a list of 10 frequently asked questions (FAQs) that a potential customer might have about the product.

049Content & SEO

Analyze the blog content of two of my competitors: [insert competitor 1 URL…

Analyze the blog content of two of my competitors: [insert competitor 1 URL] and [insert competitor 2 URL]. Identify 5 topics that they both cover that I have not yet written about on my own blog.

050Advanced & Multi-Step

Plan a 5-day trip to Rome, Italy. First, search for the best time of year t…

Plan a 5-day trip to Rome, Italy. First, search for the best time of year to visit based on weather and crowds. Then, find and book a round-trip flight from my home city ([insert your city]) for those dates. Next, find a highly-rated Airbnb near the Colosseum. Finally, create a day-by-day itinerary with links to book tickets for major attractions like the Vatican and the Roman Forum.

051Advanced & Multi-Step

Create a detailed profile of the company Palantir Technologies. Start by vi…

Create a detailed profile of the company Palantir Technologies. Start by visiting their official website to understand their products and services. Then, search for their latest investor relations presentations to get financial data. Finally, search for recent news articles and analyst reports to get a sense of their current market position and future outlook. Summarize all findings in a report.

052Advanced & Multi-Step

I am launching a new line of sustainable, reusable coffee cups. Research th…

I am launching a new line of sustainable, reusable coffee cups. Research the current market for reusable coffee cups by analyzing the websites of top competitors like KeepCup and Frank Green. Identify their key marketing messages, pricing strategies, and social media presence. Based on this research, propose a 3-step launch strategy for my new product.

053Advanced & Multi-Step

Perform a user experience (UX) audit of my website: [insert your website UR…

Perform a user experience (UX) audit of my website: [insert your website URL]. Navigate through the site as a new user would. Identify three areas where the user experience could be improved (e.g., confusing navigation, slow loading times, unclear calls-to-action). For each area, provide a specific recommendation for improvement.

054Advanced & Multi-Step

On the first day of every month, search for the latest 'Global E-commerce T…

On the first day of every month, search for the latest 'Global E-commerce Trends' report from a reputable source like eMarketer or Statista. Summarize the key findings in a one-page document and save it to my Google Drive.

055Professional & Industry

Create a patient-friendly handout explaining Type 2 Diabetes. The document…

Create a patient-friendly handout explaining Type 2 Diabetes. The document should be written in simple, clear language (6th-grade reading level), cover causes, symptoms, and management strategies (diet, exercise, medication), and include a section for frequently asked questions.

056Professional & Industry

Draft a standard 'Confidentiality and Non-Disclosure' clause for a freelanc…

Draft a standard 'Confidentiality and Non-Disclosure' clause for a freelance employment contract. The clause should define confidential information, outline the obligations of the recipient, specify the duration of the confidentiality obligation, and include provisions for the return of information upon termination.

057Professional & Industry

Research and outline a proposal for incorporating sustainable design featur…

Research and outline a proposal for incorporating sustainable design features into a new office building project. The proposal should cover three areas: energy efficiency (e.g., solar panels, smart HVAC), water conservation (e.g., rainwater harvesting, low-flow fixtures), and sustainable materials (e.g., reclaimed wood, recycled steel). For each feature, provide a brief description of its benefits and an estimated ROI.

058Professional & Industry

I have a photo of a tomato plant leaf showing yellow spots and brown lesion…

I have a photo of a tomato plant leaf showing yellow spots and brown lesions [hypothetically provide image]. Based on this visual evidence, search agricultural databases and university extension websites to identify the three most likely diseases. For each possibility, describe the symptoms and recommend an organic treatment method.

059Professional & Industry

Create a lesson plan for a 9th-grade history class on the topic of the Silk…

Create a lesson plan for a 9th-grade history class on the topic of the Silk Road. The plan should include differentiated activities for three learning levels: visual learners (create a map of the trade routes), kinesthetic learners (design a board game based on the challenges of Silk Road merchants), and auditory learners (prepare a short podcast-style report on a key city like Samarkand).

060Data Analysis & Viz

I have a CSV file with customer data, including tenure, monthly charges, an…

I have a CSV file with customer data, including tenure, monthly charges, and a 'Churn' column. Analyze this data to identify the top three factors that correlate with customer churn. Summarize your findings and create a bar chart visualizing the churn rate for different customer segments (e.g., by contract type).

061Data Analysis & Viz

Download the latest public dataset on global CO2 emissions from a reputable…

Download the latest public dataset on global CO2 emissions from a reputable source like the World Bank or NASA. Create a time-series line graph showing the change in CO2 emissions over the last 50 years for the top 5 emitting countries. Title the graph and label the axes clearly.

062Data Analysis & Viz

I ran an A/B test on my website's homepage. Version A (control) had a 2.5%…

I ran an A/B test on my website's homepage. Version A (control) had a 2.5% conversion rate, and Version B (variant) had a 3.1% conversion rate, with 10,000 visitors for each version. Calculate the statistical significance of this result (using a p-value) and write a brief report explaining whether we should confidently declare Version B the winner.

063Data Analysis & Viz

I have a list of 100 customer addresses in a spreadsheet. Use a geocoding A…

I have a list of 100 customer addresses in a spreadsheet. Use a geocoding API to find the latitude and longitude for each address. Then, create a heatmap visualization on a map of San Francisco to show the density of my customer base across the city.

064Data Analysis & Viz

Analyze my website's Google Analytics data for the last month. Create a sal…

Analyze my website's Google Analytics data for the last month. Create a sales funnel visualization showing the user journey from the landing page to the 'thank you' page after a purchase. Identify the stage with the highest drop-off rate and suggest two potential reasons for this leakage.

065Personal Development

I want to build the habit of reading for 30 minutes every day. Create a 6-w…

I want to build the habit of reading for 30 minutes every day. Create a 6-week 'habit installation' plan based on James Clear's 'Atomic Habits' methodology. The plan should include strategies for cue, craving, response, and reward, and a system for tracking my progress.

066Personal Development

I am preparing to negotiate a salary for a new job offer. The initial offer…

I am preparing to negotiate a salary for a new job offer. The initial offer is $85,000. Research the average salary for a 'Senior Marketing Manager' in Chicago using sites like Glassdoor and Levels.fyi. Based on the data, help me formulate a counter-offer strategy, including my target salary, my walk-away number, and three key talking points to justify my request.

067Personal Development

Create a 7-day 'digital detox' plan designed to reduce screen time and impr…

Create a 7-day 'digital detox' plan designed to reduce screen time and improve mental focus. The plan should include daily rules (e.g., 'no phone for the first hour of the day'), suggested replacement activities (e.g., 'go for a walk,' 'read a physical book'), and a journaling prompt for each evening to reflect on the experience.

068Personal Development

Design a structure for a personal knowledge management (PKM) system using a…

Design a structure for a personal knowledge management (PKM) system using a tool like Notion or Obsidian. The structure should include interconnected databases for a reading list (books, articles), a project tracker, a daily journal, and a 'second brain' for capturing fleeting ideas. Explain the purpose of each component and how they should link together.

069Personal Development

I want to launch a personal blog and gain my first 1,000 email subscribers…

I want to launch a personal blog and gain my first 1,000 email subscribers in the next quarter. Structure this goal using the Objectives and Key Results (OKRs) framework. Define one clear Objective and three measurable Key Results that will track my progress toward the goal.

070Niche Hobbies

Create a recipe for a 5-gallon batch of a New England IPA (NEIPA). The reci…

Create a recipe for a 5-gallon batch of a New England IPA (NEIPA). The recipe should specify the grain bill (types and weights), the hop schedule (which hops to add at which times, including for dry hopping), the recommended yeast strain, and the target original gravity (OG) and final gravity (FG).

071Niche Hobbies

I want to 3D print a detailed miniature of the Eiffel Tower. Find a high-qu…

I want to 3D print a detailed miniature of the Eiffel Tower. Find a high-quality, free STL file for this on a site like Thingiverse or Printables. Then, provide recommended slicer settings (e.g., layer height, infill percentage, support structure type) for printing on an FDM printer like the Creality Ender 3.

072Niche Hobbies

For my location [insert city/coordinates] and tomorrow's date, generate a s…

For my location [insert city/coordinates] and tomorrow's date, generate a stargazing guide. Identify three prominent constellations that will be visible in the night sky, the time and direction to best view the International Space Station (ISS) if it's passing over, and whether any planets will be visible to the naked eye.

073Niche Hobbies

Design a challenging combat encounter for a party of four 5th-level Dungeon…

Design a challenging combat encounter for a party of four 5th-level Dungeons & Dragons characters. The encounter should take place in a ruined library. Include a mix of monster types (e.g., one 'brute,' several 'minions,' and one 'controller'), describe the environmental hazards on the map, and list a potential treasure reward.

074Niche Hobbies

Create an essay outline analyzing the use of color and shadow in the film '…

Create an essay outline analyzing the use of color and shadow in the film 'Blade Runner 2049.' The outline should include a thesis statement, three main body paragraphs (each with a topic sentence and supporting points), and a conclusion.

075Complex Automation

On the first Monday of every month, perform a series of web searches to gat…

On the first Monday of every month, perform a series of web searches to gather information on the 'Lab-Grown Diamond' market. Find three recent news articles, one market analysis report, and check the stock prices of two publicly traded companies in this space. Compile all findings into a single document and email it to me.

076Complex Automation

Plan a surprise 30th birthday party for a friend who loves hiking and craft…

Plan a surprise 30th birthday party for a friend who loves hiking and craft beer. The plan should include: researching and suggesting three potential venues (e.g., a brewery with a private space near a hiking trail), creating a draft guest list and invitation text, outlining a food and drink menu, and generating a timeline of tasks from '4 weeks out' to the day of the party.

077Complex Automation

Outline the steps to create a personal finance dashboard using Google Sheet…

Outline the steps to create a personal finance dashboard using Google Sheets and a service like Plaid to connect to bank accounts. The dashboard should automatically track monthly income, spending by category, savings rate, and net worth. Specify the charts and graphs to include for a clear visual overview.

078Complex Automation

A fictional tech company, 'Innovate Inc.,' has experienced a major data bre…

A fictional tech company, 'Innovate Inc.,' has experienced a major data breach. Draft an internal memo to all employees, a public press release, and a series of three social media posts to manage the crisis. The tone should be transparent, empathetic, and reassuring.

079Complex Automation

Write a grant proposal outline for a fictional non-profit organization call…

Write a grant proposal outline for a fictional non-profit organization called 'City Sprouts,' which aims to build community gardens in urban food deserts. The outline should include sections for the statement of need, project description, goals and objectives, methods and timeline, and a budget summary.

080Google Drive: Info Retrieval

Search my Google Drive for a document about 'Q3 Marketing Report 2024.pdf'.…

Search my Google Drive for a document about 'Q3 Marketing Report 2024.pdf'. Once found, open it and summarize the key findings from the executive summary section.

081Google Drive: Info Retrieval

In my Google Drive folder named 'Project Phoenix,' there are several meetin…

In my Google Drive folder named 'Project Phoenix,' there are several meeting minute documents. Go through all documents from the last month, extract all action items assigned to 'David Chen,' and compile them into a single list.

082Google Drive: Info Retrieval

I have a 50-page research paper saved in my Drive as 'AI_Ethics_Study.docx'…

I have a 50-page research paper saved in my Drive as 'AI_Ethics_Study.docx'. Please provide a one-page summary highlighting the research methodology, key findings, and conclusions.

083Google Drive: Info Retrieval

Search my 'Financials' folder in Google Drive for any spreadsheets from the…

Search my 'Financials' folder in Google Drive for any spreadsheets from the fiscal year 2024. Find the file for 'Q4_Expenses.xlsx' and tell me the total amount listed in the 'Marketing' category.

084Google Drive: Info Retrieval

Find the 'Client Onboarding Checklist.gdoc' in my Drive. Then, search for t…

Find the 'Client Onboarding Checklist.gdoc' in my Drive. Then, search for the folder for a client named 'Global Tech Inc.' and verify that all the files listed in the checklist exist in that client's folder. Report any missing documents.

085Google Sheets: Data Analysis

Open the 'Q1_Sales_Data.xlsx' spreadsheet in my Google Drive. Calculate the…

Open the 'Q1_Sales_Data.xlsx' spreadsheet in my Google Drive. Calculate the total revenue per product category and identify the top-selling product. Create a new tab named 'Analysis' and present these findings in a summary table.

086Google Sheets: Data Analysis

In the 'Employee List.gdoc' spreadsheet in my Drive, filter the list to sho…

In the 'Employee List.gdoc' spreadsheet in my Drive, filter the list to show only employees in the 'Engineering' department who were hired in the last two years. Sort the filtered list alphabetically by last name and export the result to a new sheet named 'Recent Engineering Hires'.

087Google Sheets: Data Analysis

Access the 'Website Analytics - April.xlsx' file in my Drive. Use the 'Dail…

Access the 'Website Analytics - April.xlsx' file in my Drive. Use the 'Daily Visitors' and 'Conversion Rate' data to create a line chart showing the trend over the month. Create a separate pie chart showing the traffic sources. Place both charts on a new 'Dashboard' tab.

088Google Sheets: Data Analysis

Open the 'MailingList_Combined.xlsx' spreadsheet in my Drive. The list cont…

Open the 'MailingList_Combined.xlsx' spreadsheet in my Drive. The list contains duplicate email addresses. Identify and remove all duplicate entries, then report back with the total number of unique emails remaining.

089Google Sheets: Data Analysis

In the 'Project_Tasks.xlsx' sheet in my Drive, apply conditional formatting…

In the 'Project_Tasks.xlsx' sheet in my Drive, apply conditional formatting to the 'Status' column. Cells containing 'Completed' should be green, 'In Progress' should be yellow, and 'Overdue' should be red.

090Google Drive: Automation

On the first of every month, access the 'Sales_Log.xlsx' spreadsheet. Summa…

On the first of every month, access the 'Sales_Log.xlsx' spreadsheet. Summarize the total sales from the previous month, create a new Google Doc with this summary, and save it in the 'Monthly Reports' folder with the name 'Sales Summary - [Previous Month] 2025'.

091Google Drive: Automation

I have a Google Form for user feedback that populates a sheet named 'Feedba…

I have a Google Form for user feedback that populates a sheet named 'Feedback Responses'. Go to that sheet, find all responses with a rating of 3 stars or lower, and copy those entire rows to a new spreadsheet called 'Urgent Feedback' for my review.

092Google Drive: Automation

Open the 'Client_List.xlsx' spreadsheet. For each client listed in the 'Com…

Open the 'Client_List.xlsx' spreadsheet. For each client listed in the 'Company Name' column that doesn't already have one, create a new folder in my 'Clients' directory in Google Drive.

093Google Drive: Automation

Access the 'Billing_Hours_May.xlsx' sheet. For each row that has 'Ready to…

Access the 'Billing_Hours_May.xlsx' sheet. For each row that has 'Ready to Bill' in the status column, use the data (Client Name, Hours, Rate) to generate a simple invoice using a Google Doc template I have saved as 'Invoice Template'. Save each new invoice in the 'Invoices_Sent' folder.

094Google Drive: Automation

Consolidate Spreadsheets: In my 'Regional Sales' folder, there are four spr…

Consolidate Spreadsheets: In my 'Regional Sales' folder, there are four spreadsheets: 'North.xlsx', 'South.xlsx', 'East.xlsx', and 'West.xlsx'. Create a new master spreadsheet called 'Total Sales 2025'. Copy the data from all four regional sheets and consolidate it into a single table on the master sheet, adding a new column to specify the region for each row.

095Advanced & Multi-Step

Financial Health Dashboard: Create a new Google Sheet named 'Personal Finan…

Financial Health Dashboard: Create a new Google Sheet named 'Personal Finance Dashboard'. Access my 'Bank Statements' folder, open the last three monthly statements (CSVs), and import the data. Categorize my spending, and create a dashboard on the first tab with a pie chart for spending categories, a line chart for my account balance over time, and a summary of my average monthly income and expenses.

096Advanced & Multi-Step

Competitor Analysis Report: Search the web for the top 3 competitors to my…

Competitor Analysis Report: Search the web for the top 3 competitors to my company, 'Innovate Inc.' For each competitor, find their latest quarterly revenue and number of employees. Create a new Google Sheet named 'Competitor Matrix' with this data. Then, search my Drive for my own 'Q1_Performance.gdoc' to find my revenue and employee count, and add it to the sheet for comparison.

097Advanced & Multi-Step

Meeting Preparation Automation: I have a meeting tomorrow with 'Acme Corp'.…

Meeting Preparation Automation: I have a meeting tomorrow with 'Acme Corp'. Search my Google Drive for any documents, spreadsheets, or presentations that mention 'Acme Corp'. Create a new Google Doc named 'Acme Meeting Prep', list all the files found with hyperlinks, and add a summary of the three most recently modified documents.

098Advanced & Multi-Step

Inventory Management: Open my 'Sales_Data.xlsx' sheet. For every item sold…

Inventory Management: Open my 'Sales_Data.xlsx' sheet. For every item sold today, go to the 'Inventory.xlsx' sheet and decrease the 'Stock' number for that corresponding item. If any item's stock drops below 10, highlight that row in red and send me an email notification.

099Advanced & Multi-Step

Generate Presentation from Spreadsheet Data: Access the 'Annual_Report_Data…

Generate Presentation from Spreadsheet Data: Access the 'Annual_Report_Data.xlsx' in my Drive. Create a new Google Slides presentation with 5 slides. The first slide should be a title page. The next three slides should each feature a different chart created from the data in the spreadsheet (e.g., Year-over-Year Growth, Revenue by Quarter, Market Share). The final slide should be a summary of key takeaways.

HOW TO USE THE LIBRARY

01

Find your starting point

Search by task or browse a category.

02

Make it your own

Replace the example details with your context.

03

Copy. Try. Refine.

Review the output, then add detail and constraints.

KEEP YOUR CURIOSITY GOING

Better questions.
Practical skills.

Turn the tools and prompts you discover into skills you and your team can use.

Explore AI training

Full resource

Replace the placeholders and add your context and goals before copying.