App

What Works does with Google Sheets

What can Works do with Google Sheets?

In Strategy, you get an ideal customer profile (ICP), ranked customer needs and segments, buyer personas, a market size and competitor profiles. You also get an annual plan and objectives and key results (OKRs). In Marketing, you get core messages, lead and content plans, and campaign tracking. In Sales, you get prospect lists, deal reviews, forecasts, quotas and territories.

Published Updated

Google Sheets
Works logo Works

turn data into a plan

What Works does with it

Workflows that use Google Sheets

What it can do

What Works can do in Google Sheets

4 of these 6 change something in your Google Sheets account and are marked. The rest only read.

  • Total a month's sales by group

    See one month's sales total, split by rep, category or customer, like a pivot table.

  • Catch currency and date mix-ups

    Mismatched currencies or a confusing date order flagged before you add anything up.

  • Log an expense or sale

    Changes your Google Sheets

    Add an expense or sale to the bottom of your tracker, in the right columns.

  • Set up a new tracker

    Changes your Google Sheets

    Get a new spreadsheet with your columns, a bold frozen header and readable widths, plus its link.

  • Bring a tab into your workbook

    Changes your Google Sheets

    A one-time copy of a team's tab in your master spreadsheet; later edits to the original will not update it.

  • Leave a note for a teammate

    Changes your Google Sheets

    A note on the task cell teammates see on hover, plus a file comment only if you ask.

Try it

Ask Works to…

Draft follow-ups for quiet leads

Sales

Leads with no reply since a date you pick, 14 days by default, each with a follow-up drafted.

What you type

In my [leads spreadsheet], find leads with no reply since [date, or leave blank for 14 days] and draft a short, personal follow-up for each.

What you get back A list of quiet leads, oldest first, each with a ready-to-send follow-up message you send yourself.

Report open jobs by stage

Operations

Count open jobs by stage and owner, and list the ones stuck without an update.

What you type

From my [jobs spreadsheet], count open jobs by stage and owner, and list any with no update for [number] days.

What you get back A summary of open jobs by stage and owner, with stuck jobs listed for follow-up.

Build a monthly profit and loss

Finance

Combine each department tab's income and costs into one monthly profit and loss summary.

What you type

Use the department tabs in [spreadsheet] to build a profit and loss by month for [period].

What you get back A monthly profit and loss summary by department, with currencies kept separate.

Compare monthly revenue

Finance

Revenue for each month against the month before and a year earlier, with big swings pointed out.

What you type

From my [sales spreadsheet], total revenue for each month and compare [month] with the month before and the same month last year.

What you get back A month-by-month revenue table with the change from last month and last year, and big swings flagged with the customers or items behind them.

Flag stock about to run out

Inventory Changes your Google Sheets

List items at or below their reorder level, and highlight them in your stock sheet.

What you type

Check my [stock spreadsheet] for items at or below their reorder level and highlight them so I can reorder.

What you get back A reorder list of low items with recent movement, and those items highlighted in your stock sheet.

Compare budget with actual spending

Finance

Planned against actual spend for each category, with the ones over budget flagged.

What you type

In my [budget spreadsheet], compare budget with actual spending for [period] and flag any category over budget.

What you get back A budget against actual table by category, with overspending flagged and a note on where to cut.

Connect

Connect Google Sheets once

Open the apps screen inside Works. Choose Google Sheets. Then sign in to your Google Sheets account.

Questions

What people ask

Which agents use Google Sheets?

In Strategy, the ICP Builder, Customer Researcher, Segmentation Strategist and Competitive Analyst use Google Sheets. So do the Market Sizing Analyst, Sizing Documenter, Planning Strategist, and Goals and OKR Architect. In Marketing, the Proof Researcher, Lead Plan Analyst, Tracking Builder, Content Strategist, Calendar Builder, Channel Analyst and Reallocation Advisor use it. In Sales, the Compensation and Territory Planner uses it.

Can you keep your results somewhere other than Google Sheets?

Yes, in some of these workflows. In Identify and Prioritize Segments, you can keep the ranked segments in Google Sheets or Notion. In Build Annual Plan, you can keep the plan in a shared Google Sheet or Notion. In Plan the Content Calendar, you can keep the calendar in a shared Google Sheet, Notion or your project tool.

What is Google Sheets?

Google Sheets is a tool to create and edit spreadsheets online. Google Sheets says you can share a sheet securely and work on it with others in real time. Google Sheets says you can use it from any device. In Works, the Strategy, Marketing and Sales workflows on this page use Google Sheets.

Use Google Sheets in Works

Sign up to choose your first workflow.

Sign Up