Google Sheets

Answers that use the plans and lists you keep in Sheets.

Try Dot with Google SheetsRead the docs

Every tab laid out as a table becomes one, and each question reads it live.

Threadanalytics

Lisa Park9:41 AM

@Dot Using our headcount plan sheet, which teams are behind on hiring this quarter?

1 reply

DotAPP9:42 AM

4 steps · 31s · Access Online

Sales and Support, 7 hires short between them.

Source: Google Sheets’ Headcount plan.

Here is the data.

TeamHiredPlan
Sales610
Support25
Engineering88

Threadanalytics

David Mensah9:41 AM

@Dot Use our ‘Account owners’ sheet to show each owner’s bookings and win rate this quarter.

1 reply

DotAPP9:42 AM

6 steps · 36s · Access Online

Maya leads. Six accounts have no owner yet.

Sources: Google Sheets’ Account owners and bookings.

Here is the data.

OwnerBookedWin rate
Maya$2.4M31%
Jonas$1.9M27%
Elif$1.6M29%

Threadanalytics

Sarah Chen9:41 AM

@Dot Restate last quarter’s revenue by country in euros, using the FX rates in our finance sheet.

1 reply

DotAPP9:42 AM

7 steps · 47s · Access Online

€12.8M in total, across 14 countries.

Sources: Google Sheets’ FX rates and revenue.

Here is the data.

CountryRevenue in euros
Germany€3.1M
France€2.2M
United Kingdom€1.9M

Connect Google Sheets

  • Shared as ‘anyone with the link’
  • No service account or OAuth
  • Sync only when columns change

More in Databases & spreadsheets

Connect your data.

Start for Free