Adding a Client

Adding a new client does a few things:

  1. Makes that client available in dropdown menus for copying + browsing templates

  2. Creates a Drive subfolder for that client, to which any new template copies will be added

  3. Creates a Client Workbook copy for that client


You can add new clients from either the 'Project Management' menu, or from the link within the 'Copy Template' form.

If you're no longer working with a client, you can deactivate them at any time from the 'Client List' at the bottom of the sidebar.  This will not delete their files, but it will remove them from your Add-on dropdown menus.

Important to note: you will still need to connect your Client Workbook to the PM Tracker the first time you open it, by 'Allowing access' from the Getting Started tab.  


Sheets Add-on Setup

Buy nowLearn more
  • READ THIS FIRST 😎
  • Why use the Add-on?

Installing the Add-on

  • Install the Add-on from the G Suite Marketplace
  • Setting your License Key
  • Getting Support

Configuring your Agency Setup

  • Installation: Set your Drive Folder, Agency Name + Email
  • Importing your Existing PM Tracker
  • Copying a New Project Management Tracker
  • Adding Teammates as Add-on Users

Adding Clients + Tasks

  • Adding a Client
  • Configuring Client Subfolders
  • Copying a Project Plan
  • Adding a One-off Task
  • De-activating + Re-activating Clients

Copying + Running Templates

  • Two Types of Sheets Templates: Basic and Automated
  • Making Copies of Templates
  • Module 1.5 - Analytics Audit [NEW]
  • Module 2.1 - Website Quality Audit
  • Module 2.6 - Internal Linking Optimization
  • Module 3.2 - Keyword Research [NEW Pages]
  • Module 5.2 Local SEO Monthly Reporting
  • Bonus - The Traffic Projection Tool
  • Adding a Custom Template

Important PM concepts

  • Project management intro
  • Mapping your processes
  • Agency roles and responsibilities
  • Current org structure
  • Task - Deliverable - Actions
  • Manage Team Members
  • Using Google Drive for organization

Deep dive into the trackers

  • The Central tracker
  • The Content tracker
  • The Link tracker
  • The Client tracker

Creating project plans

  • The "Base" project plan
  • Project planning from scratch
  • Project planning for a NEW website
  • Niche project planning
  • Updating project plans
  • Integrating project plans