Grant Tracking Toolkit Setup Guide

Welcome!

Thank you for attending the grant management presentation. This toolkit includes a customizable Grant Tracking Spreadsheet and an interactive Dashboard designed to help your organization track grant opportunities, deadlines, submissions, awards, and reporting requirements.

Follow the steps below to create your own working copies and connect them together.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Step 1: Create Your Own Copy of the Grant Tracking Spreadsheet

  1. Open the Grant Tracking Spreadsheet.
  2. Click Make a Copy when prompted.
  3. Save the copy to your own Google Drive.
  4. Rename the file as desired (example: ABC Nonprofit Grant Tracker).

✅ You now have your own editable spreadsheet.

You must complete Step 1 before creating the dashboard copy. The dashboard needs to connect to your spreadsheet copy during setup.
 
 
 
 
 

Step 2: Create Your Own Copy of the Dashboard

  1. Open the Looker Studio Dashboard Template using the provided link.
  2. Click the three dots (⋮) in the upper-right corner of the report and select Make a copy. This creates your own editable version of the dashboard in your Google account.

✅ When you make a copy of the dashboard, it is still pointing to the original demonstration spreadsheet. To make the dashboard display your own grants, you must connect it to your copy of the Grant Tracking Spreadsheet.

 

Step 3: Link the Dashboard to Your Spreadsheet

During the dashboard copy process:

  1. A pop-up box will open.
  2. In the pop-up box, choose New Data Source (or Create Data Source). 
  3. Below the dropdown menu, choose Create data source at the bottom.
  4. Select Google Sheets from the Connectors menu.
 
 
 
 
 
 
 
 
 
 
  1. Your renamed Grant Tracking Spreadsheet should be at the top of the list.
  2. Select the renamed spreadsheet. A new window will appear to the right asking you to select the specific worksheet where the dashboard is getting data.
  3. Select the worksheet for the current grant year (for example, 2027). In future years, you can reconnect the dashboard to a new annual worksheet within the same spreadsheet.
  4. Click the blue Connect button in the upper right-hand corner.
 

NOTE: After connecting the data source, verify that the Requested Amount and Awarded Amount fields are formatted as Currency in Looker Studio. These fields occasionally revert to Number during the copy process.

  1. Click the blue Add to Report button in the upper right-hand corner.

✅ Your dashboard is now connected to your spreadsheet. The dashboard may take a few moments to load data the first time. If your charts appear blank, refresh the report.

 

Step 4: Verify the Connection

Test the setup:

  1. Open your Grant Tracking Spreadsheet.
  2. Add a sample grant record.
  3. Save the entry.
  4. Return to the dashboard.
  5. Refresh the report.

The charts, tables, and metrics should update automatically.

✅ Your reporting dashboard is working correctly.

How the Connection Works

Think of the spreadsheet as the engine and the dashboard as the dashboard panel in a car.

Spreadsheet

  • Enter grant opportunities
  • Update statuses
  • Record award amounts
  • Track deadlines

Dashboard

  • Creates charts
  • Calculates totals
  • Displays upcoming deadlines
  • Shows grant pipeline activity

You only enter data into the spreadsheet. The dashboard updates automatically.

Customizing the Toolkit

You can:

  • Add additional grant categories
  • Create custom status values
  • Add program areas or departments. Be sure to reconnect the spreadsheet to the report to update the available fields.
  • Track grant reporting deadlines
  • Add board-designated priorities
  • Customize dashboard visualizations

All changes occur within your copy and will not affect other users.

Troubleshooting

Dashboard Shows No Data

  • Confirm the dashboard is connected to your copied spreadsheet.
  • Verify that data exists in the spreadsheet.
  • Refresh the report.

Permission Errors

  • Ensure you are logged into the Google account where your copies were saved.
  • Confirm you made your own copies rather than using the original templates.

Data Not Updating

  • Refresh the dashboard.
  • Check that fields or column headers have not been deleted or renamed.