Prompting Sheets

AI prompts and formulas built into Google Sheets as an add-on

Beginner
Screenshot of Prompting Sheets, AI prompts and formulas built into Google Sheets as an add-on

What is Prompting Sheets?

Prompting Sheets is a Google Sheets add-on that generates tailored project plans and to-do lists from a few project questions. It adds a =PROMPT() formula, reusable prompt templates, prompt optimization and a data chatbot, and requires an OpenAI API key.

Prompting Sheets is an add-on for Google Sheets that brings AI into the spreadsheet itself. Instead of starting a project plan or to-do list from a blank grid or a generic template, the user answers a few questions about the project, and the add-on builds a sheet around that context. The product is made by Sanders Design Ltd and is aimed at people who already live in Google Sheets for planning, reporting and data work. In practice the workflow starts with installing the add-on from the Google Workspace Marketplace and running the Get Started process. The add-on collects project context, then uses it to generate tailored sheets. Beyond generation, it offers a =PROMPT() formula for running prompts from a cell, customizable prompt templates with dynamic placeholders and logical conditions, and an AI prompt optimization feature that suggests improvements for people new to prompt writing. Sheets can be included in a prompt by adding [P] to the sheet name, and rows can be left out by starting them with [-P]. A chatbot answers questions about the data in real time and can generate images, and the add-on can fetch and analyse data from websites. A searchable sheets library with one-click downloads and tools for turning AI prompts into static text round out the set. The intended audience is marketers, designers, planners, business professionals and educators, plus organisations that want better reporting and project management. A practical point from the FAQ: the add-on needs the user's own OpenAI API key, so model usage is billed through OpenAI rather than bundled. The pricing section lists a free Limited AI Sheets tier covering data context, sheets and formulas, and an Unlimited tier that adds prompt optimization, audit reports and the chatbot, though its subscription button is marked as coming soon. Among alternatives, it sits between general AI spreadsheet assistants and template libraries. Its appeal is that planning structure, prompt tooling and formulas stay inside Google Sheets, with no separate app to learn.

How do you use Prompting Sheets?

  1. 1Install the add-on
    Get the Prompting Sheets add-on from the Google Workspace Marketplace link and authorise it for Google Sheets.
    Prompting Sheets — Install the add-on
  2. 2Add your OpenAI API key
    Enter an OpenAI API key during onboarding, since the add-on uses it to access the AI models. The help docs cover the details.
    Prompting Sheets — Add your OpenAI API key
  3. 3Start with Get Started
    Open the Get Started process to begin a new project and answer a few questions so the add-on builds context for your plan.
  4. 4Generate and refine a sheet
    Review the generated project plan or to-do list, then adjust it with the AI sheet and formula features such as =PROMPT().
    Prompting Sheets — Generate and refine a sheet
  5. 5Save custom prompts
    Create prompt templates with placeholders and conditions, use prompt optimization for suggestions, and reuse templates later.
    Prompting Sheets — Save custom prompts
  6. 6Ask the chatbot about your data
    Use the AI chatbot to query sheet data in real time and request suggestions.
    Prompting Sheets — Ask the chatbot about your data

Pros and cons

Pros

  • Works inside Google Sheets, so no separate app or data export is neededAI
  • Builds project plans and to-do lists from project context instead of fixed templatesAI
  • =PROMPT() formula and reusable templates with placeholders and conditions suit repeatable workAI
  • Prompt optimization suggestions help newcomers write better promptsAI
  • A free tier covers AI data context, sheets and formulasAI

Cons

  • Requires the user's own OpenAI API key, adding a separate cost and setup stepAI
  • The unlimited paid plan is listed as coming soon, so upgrade options are unclearAI
  • Limited to Google Sheets, with no Excel or standalone version mentionedAI
  • Pricing for the Teams plan and the free tier's limits are not stated on the homepageAI
  • Include and exclude markers such as [P] and [-P] add a manual convention to learnAI

How much does Prompting Sheets cost?

Free trial

A free Limited AI Sheets tier is available with AI data context, AI sheet and AI formula features. No time-limited trial is described.

Learn more

Pricing

A free Limited AI Sheets tier includes AI data context, AI sheets and AI formulas. An Unlimited AI Sheets plan adds prompt optimization, audit reports and the chatbot, but its subscribe button is marked coming soon. A Teams plan is listed without details. An OpenAI API key is also needed.

Learn more

Support

A help documentation page and a contact support page are provided, and the FAQ points users to the help page or the customer service team.

Learn more

Integrations

Runs as an add-on for Google Sheets and connects to OpenAI through the user's own API key. It can also fetch and analyse data from websites.

Features

Generates tailored project plans and to-do lists, adds a =PROMPT() formula, reusable prompt templates with placeholders and conditions, prompt optimization, an AI chatbot for data queries and image generation, website data fetching, and a searchable sheets library with one-click downloads.

Learn more

Frequently asked questions about Prompting Sheets

  • How much does Prompting Sheets cost?
    A free Limited AI Sheets tier includes AI data context, AI sheets and AI formulas. An Unlimited AI Sheets plan adds prompt optimization, audit reports and the chatbot, but its subscribe button is marked coming soon. A Teams plan is listed without details. An OpenAI API key is also needed.
  • Does Prompting Sheets offer a free trial?
    A free Limited AI Sheets tier is available with AI data context, AI sheet and AI formula features. No time-limited trial is described.
  • How do you use Prompting Sheets?
    The walkthrough on this page covers 6 steps: 1. Install the add-on 2. Add your OpenAI API key 3. Start with Get Started 4. Generate and refine a sheet 5. Save custom prompts 6. Ask the chatbot about your data.
  • What platforms does Prompting Sheets support?
    Prompting Sheets is available on Web App.
  • What does Prompting Sheets integrate with?
    Runs as an add-on for Google Sheets and connects to OpenAI through the user's own API key. It can also fetch and analyse data from websites.
  • What are the limitations of Prompting Sheets?
    Requires the user's own OpenAI API key, adding a separate cost and setup step. The unlimited paid plan is listed as coming soon, so upgrade options are unclear. Limited to Google Sheets, with no Excel or standalone version mentioned.

Status

StatusActive
Views0
Outbound clicks0
Added10/8/2026

Platforms

Web App

Pricing

Freemium