Use case

Your pipeline sheet,
answering back

Plenty of teams run their pipeline in a Google Sheet long before they buy a CRM. Share it with wuup as a viewer and ask about deals by stage, rep performance or stale opportunities; wuup reads the rows and answers with a table and the exact range it used.

Who it's for

Founders and sales leads who run the pipeline in a Google Sheet

Sources

  • Google Sheets: Pipeline tab
  • Google Sheets: Targets tab

The problem today

  • Pivot tables break whenever someone adds a column.
  • Stale deals hide in long tabs.
  • Quarter-end numbers need a manual roll-up.

Six questions,
and what wuup does

Ask in plain English. Here is what happens behind each answer, including the query when there is one.

  1. 01

    What's the open pipeline by stage?

    Reads the Pipeline tab, filters open deals and sums value per stage.

    Reads: Pipeline!A1:H120

  2. 02

    Which rep has the highest win rate?

    Counts won vs lost deals per owner and computes the rate.

    Reads: Pipeline!A1:H120 (Owner, Stage)

  3. 03

    Which deals have gone stale?

    Compares Last activity with today and lists deals older than 30 days.

    Reads: Pipeline!A1:H120 (Last activity)

  4. 04

    How does pipeline compare with target?

    Reads both tabs and lines up months.

    Reads: Pipeline!A1:H120 and Targets!A1:C13

  5. 05

    What's the average deal size by region?

    Groups deal value by region and averages it.

    Reads: Pipeline!A1:H120 (Region, Value)

  6. 06

    What should close this month?

    Filters expected close dates in the current month and totals them.

    Reads: Pipeline!A1:H120 (Expected close)

From question
to answer

  1. 1

    Share the sheet as Viewer

    Add wuup's service account email; nothing else changes.

  2. 2

    Ask about the pipeline

    "Open value by stage, and how it compares with target."

  3. 3

    Check the range

    Every answer names the tab and range it read.

Why it works
for this job

Reads headers, not cell addresses

Ask about "Owner" and "Stage"; wuup maps them to columns from the header row.

Across tabs

Pipeline in one tab, targets in another: one question covers both.

No edits, ever

The service account has read-only Sheets access, so your pipeline stays exactly as you left it.

What changes

  • Pipeline reviews driven by questions, not pivot tables.
  • Stale deals surfaced before they slip.
  • No CRM migration needed to get answers.
How the connector works

Questions,
answered

Bring the data.
Ask the question.