Help
How to connect, what's in each table, and how to build your own sheets on top of it.
Connect · What's in each column · Refresh and Google's limits · Your own formulas · Plans · Disconnect · Privacy
Connect your account
- In Google Sheets, open Extensions, then Crew Numbers for Sheets, then Open Crew Numbers.
- Pick the app you use (for example, Crew Numbers for Housecall Pro or CrewPay for Gusto) and press "Get a connection code".
- Open your app's Sheets settings. The sidebar links to it. Type the 8-character code and pick which tables this sheet may read.
- Come back to the sheet. The sidebar notices on its own and shows your business name.
- Tick the tables you want, pick the dates and the schedule, and press "Fill my sheet".
Each spreadsheet connects on its own. A bookkeeper can connect one sheet per client. Your client types the code in their app; you don't need their login. The code works for 10 minutes.
What's in each column
Each table gets its own tab, starting with "CN". Row 1 is the header. Money is in your account's currency. A blank cell means the app doesn't know that number yet (for example, no labor cost was entered). It's never a made-up zero. Dates are in your business's time zone.
Columns never move or get renamed. When your app adds a new column, it shows up at the end of the table.
CN Jobs
| Column | What it holds |
|---|---|
| Job # | The job number in your app. |
| Job | The job's title. |
| Client | Who the job was for. |
| Date | The day the work was done. |
| Part of a recurring job | Yes if this row is one visit of a repeating job. |
| Crew | Who worked on it. |
| Services | What was sold on the job. |
| Revenue | What the job brought in. |
| Labor | Wages for the time on the job, with your labor burden if you set one. |
| Materials | Parts and materials cost. |
| Profit | Revenue minus labor and materials. |
| Margin % | Profit as a share of revenue. |
| Profit is | Whether the profit is complete or an estimate. |
| Note | Why a number is missing or estimated. |
| Open in the app | A link to the job. |
CN Crew
| Column | What it holds |
|---|---|
| Crew member | The person. |
| Hours | Hours worked in the date range. |
| Jobs worked | How many jobs they were on. |
| Revenue share | Their share of the revenue from those jobs. |
| Labor cost | What their time cost. |
| Profit contributed | Their share of the profit. |
| Revenue per hour | Revenue share divided by hours. |
| Callbacks (estimate) | Return visits to the same job, as a rough count. |
| Jobs left out of profit | Jobs missing the costs needed to count them. |
| Note | Why a number is missing or estimated. |
CN Clients
| Column | What it holds |
|---|---|
| Client | The client. |
| Jobs | Jobs for them in the date range. |
| Revenue, Profit, Margin % | From those jobs. |
| Invoiced to date | Everything you've ever billed them. |
| Owes today | What they owe right now. |
| Note | Why a number is missing or estimated. |
CN Services
| Column | What it holds |
|---|---|
| Service, Category | What you sell and its group. |
| Jobs | Jobs that included it. |
| Revenue, Profit (estimate), Margin % | For that service. Profit is split across services on a job, so it's an estimate. |
CN Money Owed
| Column | What it holds |
|---|---|
| Invoice #, Client | The open invoice and who owes it. |
| Balance owed | What's still unpaid. |
| Days late, How late | Days past due, and the group (not due yet, 1–30, 31–60, 61–90, over 90). |
| Due (or issued) | The due date, or the issue date if there isn't one. |
CN Pay Lines
Only pay runs you've locked in your app. Crew Numbers and CrewPay work out pay; they don't run payroll, move money or file taxes.
| Column | What it holds |
|---|---|
| Crew member, Date | Who, and the day the work was done. |
| Type | Hourly, per job, commission, bonus or deduction. |
| Job or item | What the line is for. |
| How it's paid | The pay rule used. |
| Hours | Hours, for hourly lines. |
| Amount | What this line pays. |
| Note | Anything changed by hand. |
| Period start, Period end | The pay period. |
Refresh and Google's limits
- Refresh now fills the tables while you watch.
- Every day refreshes once a day at the hour you pick, in your business's time zone. Every hour refreshes hourly.
- Google lets an add-on run on its own at most once an hour, for a few minutes at a time. A very large table (tens of thousands of rows) can take a few hours to fill. The sidebar and the "CN Status" tab show how far it got.
- Google also caps how much an add-on can fetch each day. If you hit it, the refresh pauses and picks up again by itself.
- The schedule runs as the person who set it. If they lose access, refreshing stops until someone reconnects.
Your own formulas, notes and charts
- Each table has a named range: CN_Jobs, CN_Crew, CN_Clients, CN_Services, CN_Money_Owed, CN_Pay_Lines. Point formulas and charts at those names or at whole columns, like
'CN Jobs'!K:Kfor Profit. They grow with the table. - Examples: profit for one client,
=SUMIFS('CN Jobs'!K:K, 'CN Jobs'!C:C, "Maple St HOA"). Total pay for one person,=SUMIFS('CN Pay Lines'!G:G, 'CN Pay Lines'!A:A, "Ana Ruiz"). A 10% commission on a job, in the first empty column right of CN Jobs:=K2*0.1. - Money is stored to the cent, but comparing money exactly can miss by a tiny fraction. Wrap it in
ROUND(…, 2)before an exact match, like=ROUND(K2, 2)=100. - Add your own columns to the right of a table, or use other tabs. The add-on never writes there. If it adds a new column, it moves yours over instead of covering them.
- Don't type inside our tables or under them. If you do, the next scheduled refresh skips that table, and Refresh now asks before replacing your edits.
- "Add sample charts" in the sidebar makes a "CN Charts" tab with a few starter charts you can change.
Plans
The add-on is free to install. Refreshing needs a Crew Numbers or CrewPay plan that includes Google Sheets: any paid plan, or the Sheets only plan where your app offers it. Free trials include Sheets for the whole trial. If your plan stops including Sheets, your tables stay but stop refreshing, and the sidebar links to your app's billing page.
Disconnect
In the sidebar, "Disconnect this sheet" removes the connection and stops the schedule. Your tables stay. You can also revoke the sheet in your app's Sheets settings.
Privacy
The add-on can only see the spreadsheet you use it in, and only calls your Crew Numbers or CrewPay account. Read the privacy policy.