30% off your first 3 months

Get the deal
Google Sheets logo
APP GUIDE
In your browser

How to use DuckyHelper in Google Sheets

In Google Sheets the hard part is usually one cell: a formula that breaks, a number that looks wrong, a column nobody filled in. Ask about the sheet on your screen and DuckyHelper explains it right on the cells, or works it out on the blackboard. You can also hand it the column to fill in (in the Mac app); a weekly update that keeps itself current is not in the app yet.

Works on Mac, Windows and LinuxDoing jobs is in the Mac app
01
ASK
Works now

Find out why a cell says #N/A

YOU SAY
“Why does this cell say #N/A when the SKU is right there?”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Click the cell with the error so its formula shows in the formula bar.
  2. 02Ask out loud. DuckyHelper reads the formula and the values in that row on your screen.
  3. 03It circles the error, underlines the cell that causes it and says what doesn't match.
  4. 04Fix it yourself in a few seconds, or ask how to write the lookup so a stray dash doesn't break it.

You getThe error explained on the cell that causes it, and the one change that fixes it.

Orders · November - Sheets
docs.google.com
fx =VLOOKUP(B4, Prices!A:B, 2, FALSE)OrderSKUQtyPrice1001A1002$12.001002B2201$30.001003A-1043#N/A1004C3105$8.50
Row 4's SKU is A-104 with a dash, but your price list says A104. Match them and it finds the price.
Demo · example pageClip · 6 sStill
02
ASK
Works now

Work out where a funnel loses people

YOU SAY
“Where are we losing people in this funnel, and what is fixing it worth?”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Have the sheet with your funnel numbers on screen: visits, sign-ups and paid.
  2. 02Ask out loud. DuckyHelper reads the numbers and opens the blackboard.
  3. 03It draws the funnel and works out the rate at each step as it talks, then marks the step losing the most people.
  4. 04It finishes with what a better rate at that step would mean, so you know what a fix is worth.

You getThe leakiest step and the payoff of fixing it, worked out where you can follow every number.

BlackboardWhere the sign-ups drop off

Lift sign-ups to 30% and paid goes from 120 to 150, with no new visitors.

Demo · example pageClip · 13 sStill
03
JOB
On Mac

Fill in a column, then share the sheet

YOU SAY
“Work out each rep's commission in column E, then share the sheet with Priya”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Open the sheet and say what to fill in and the rule for it.
  2. 02DuckyHelper works in the sheet with its own cursor, cell by cell, while you keep using yours.
  3. 03It adds up the column at the end, so you can check the total at a glance.
  4. 04It shares the sheet with Priya with the access you named, and the run is recorded.

You stay in controlIt does the job without stopping to ask. A Stop control stays on the window the whole time, Take control hands it back to you, and the task is recorded so you can watch it again.

You getColumn E filled in for every rep, a total to check, and the sheet shared only after you said so.

On Mac
Done
Commission in column Ein Google SheetsWorked for 10s ›Worked out commission for 5 reps and shared the sheet with Priya.
What should I do next?
Demo · example data · Mac app
04
ALWAYS ON
Not in the app yet

Keep a weekly summary tab up to date

YOU SAY
“Every Friday at 4, copy this week's daily totals into the Summary tab and highlight the slowest day”
Press fn (Ctrl+Shift+Space on Windows and Linux) and say it out loud.
What happens
  1. 01Say it once with the sheet open. It does this week's copy right away so you can check it.
  2. 02It learns the sheet's own actions the first time, so each Friday's run is quick.
  3. 03Turn it on from the card it offers. It runs every Friday at 4 PM from then on.
  4. 04Every run shows up in the history with what it copied.

Not in the app yetAlways-on jobs are not in the app yet: this shows how one would run. Today you can ask for the same job once, in the Mac app.

You getA Summary tab that is current every Friday without you copying a single cell.

Make this automatic?Schedule
Friday summary
WhenEvery Friday at 4:00 PM
DoesCopy this week's daily totals into the Summary tab
ThenHighlight the slowest day in yellow
Demo · example data · not in the app yetClip · 7 sStill
FROM THE APP

The done card and its ring

The done card from the app itself, after a spreadsheet job in Numbers: what it did, how long it worked, and the ring turning green.

The app's done card after a spreadsheet job ("Totals in column D · in Numbers · Worked for 7s") and the side rail's ring turning green. In the Mac app.

The done card and its ring
TIPS

Getting more out of it in Google Sheets.

  • 01

    Click the cell first. The formula bar is the best clue DuckyHelper has, and it reads only what is on the screen.

  • 02

    Say the rule, not the formula: "commission is sales times the rate" is enough for a job.

  • 03

    On a big sheet, freeze the header row so the column names stay in view while you ask about rows far down.

  • 04

    Ask it to check the work: "add up column E and compare it with the total at the bottom".

  • 05

    Moving numbers into a report? The Google Docs guide picks up from there.

FAQ

Questions about Google Sheets.

Can it write formulas for me?

Ask and it explains the formula to use and why, on the cells it applies to. In the Mac app it can type it in with its own cursor, cell by cell, while you watch.

Do I need to connect my Google account?

No. It reads the sheet that is on your screen while the pill is open. Jobs (in the Mac app) use Sheets in your browser, signed in as you, and it's built not to type your passwords or card numbers.

Will it share or email my sheet on its own?

It shares a sheet or sends something when you ask it to, without stopping to ask, for now. A Stop control stays on the window the whole time, Take control hands it back to you, and every task is recorded so you can watch it again. Keep an eye on tasks that involve messages or money.

Does it work with Excel files too?

Yes. It works in whatever is on your screen, so an Excel file in Excel or opened in Sheets is fine. The Excel guide has examples there.

Questions and jobs

Do anything

Ask it a question or hand it a job, in any app.

Doing jobs for you is in the Mac app. Asking works on Mac, Windows and Linux.