Unable to access the non-financials page
If you are unable to access the non-financials page to connect or update a Google Sheet in Fathom then you’ll want to check:
Needed permissions in Fathom
Those with ‘Advisor/Editor’ or ‘Admin’ level roles in Fathom have the necessary permissions to access the non-financials page by default.
If you are a ‘Client/Viewer’ level user, then you must have the ‘Update Non-financials’ permission turned on in ‘Advanced User Permissions’ to be able to access the non-financials page. To make the initial connection between a Google Sheet and Fathom, you must have the ‘Select KPIs’ permission turned on as well.
Non-financial results in a consolidated group
The non-financials page will not be accessible within a consolidated group. This is because the KPI results for a consolidated group are summed from the underlying companies’ KPI results.
Cannot find Google Sheet to select for import
When making the connection between a Google Sheet and Fathom, you’ll be asked to select a Google Sheet to connect. If you’re unable to find or select a Google Sheet, then you’ll want to go through the appropriate troubleshooting steps depending on if you’re attempting to:
Connecting to a Fathom template
When you choose to connect to a Fathom template, Fathom will create a Google Sheet for you. This Google Sheet will not automatically open in a new tab.
Instead, you can access the created Google Sheet through the following steps:
❗Note: If you create several Google Sheets from Fathom templates for the same company, they will all have the same name (i.e. Company Name Custom Financial KPI Results). To help differentiate between them, you can rename the sheets in Google. Subsequent updates will update the sheet name in Fathom.
Connecting your own Google Sheet
If you are connecting your own Google Sheet to Fathom and are unable to find the desired sheet in the selector, then check the following:
💡Pro Tip: When selecting to 'Connect to Google Sheet' and 'Use your own sheet', in the menu that opens to select the Google Sheet, you can click on the 'A>Z' icon in the top right corner. This will allow you to filter the Google Sheets by the most recently modified or most recently modified by you to help you find a specific sheet more quickly.
Needed permissions in Google
The following permissions in Google will allow you to connect a Google Sheet to Fathom and update the data.
As long as you have access to view or read the data in the Google Sheet, you will be able to connect it to Fathom.
💡Pro Tip: If you’re able to access the non-financials page, but are unable to connect a Google Sheet, then you likely do not have the ‘Select KPIs’ permission turned on in Fathom.
Save the file as a Google Sheet
If you have the appropriate permissions in Google and you’ve connected to the correct Google account, then the document may not be saved as a Google Sheet in Google.
For example, when you upload an Excel spreadsheet to Google, it is automatically saved as an Excel or .xlsx file and not a Google Sheet. After it has been uploaded to Google, the file will need to be re-saved as a Google Sheet.
To ensure the file is saved as a Google Sheet, open the file in Google,
A Google Sheet copy of the file will be added and saved to your Google Drive. You should then be able to select the file in the file selector.
Cannot edit non-financial data
Any non-financial data imported from Google Sheets cannot be edited within Fathom, it can only be edited in Google Sheets and then updated in Fathom.
This is because the Google Sheet is considered the ultimate source of truth and Fathom only pulls in data from Google Sheets, it does not send data back into Google Sheets. Therefore, to ensure the imported data matches with the Google Sheet, changes to the imported results can only be made from within the Google Sheet and then synced with Fathom.
If you’re trying to make changes to data imported from Google Sheets, then you will need to go to the Google Sheet containing the non-financial KPI results. To do this from within Fathom:
❗Note: If you have manually added data in Fathom for periods not sourced from the Google Sheet, then that manually entered data will be overwritten with the data from the Google Sheet for those periods.
Data in Fathom is not matching data in Google Sheets
If the data displayed in the non-financials page for KPIs sourced from Google Sheets does not match the data in Google Sheets, then go through the following troubleshooting workflow:
Updating data from Google Sheets
If automatic updates are turned on for the Google Sheet, then the data will be synced with Fathom once every 24 hours. If changes have been made to the non-financial data in Google Sheets recently, then you can sync the Google Sheet with Fathom to bring over the changes.
When non-financial KPIs are brought into Fathom via a connected Google Sheet, you are asked to choose the amount of decimal places to display for each non-financial KPI. By default, 0 decimal places will be chosen.
If the data for a KPI in Fathom is showing a lot of 0's and/or 1's when there is data in the Google Sheet file, then it is likely that the incorrect amount of decimal places has been selected for display.
If you have connected multiple Google Sheets with the same KPI, then the data for the KPI will only be sourced from the original connection.
Example: You connected Google Sheet A with a ‘New Hires’ KPI to your company in Fathom. You then connected Google Sheet B to the same company. Google Sheet B contains a ‘New Hires’ row as well with the exact same name as the KPI in Google Sheet A. Fathom will ignore the second connection, so the data for the ‘New Hires’ KPI will come from Google Sheet A.
To have the data come from Google Sheet B, you have two options:
Option 1 - If the duplicate KPI is not used in any Formula KPIs
The data will now be sourced from the second Google Sheet.
Option 2 - If the duplicate KPI is used in Formula KPI
If the KPI you deleted was used in any Formula KPIs, you would need to re-create those Formula KPIs. To avoid re-creating the Formula KPIs, then instead of deleting the KPI, you could:
❗Note: You will need to have permissions to connect a Google Sheet in both Fathom and Google for Option 2.
Data from Google Sheets is not updating
If the non-financial data sourced from a Google Sheet is not updating in Fathom, then check the following:
Triggering an Update
If automatic updates are turned on for the Google Sheet, then the data will be synced with Fathom once every 24 hours. Automatic updates are not on by default.
If changes have been made to the non-financial data in Google Sheets recently, then a manual sync is needed to bring the changes over.
If a sync has failed, then an error message will appear. Select ‘View details’ for more information.
If the message is unclear or you're unsure how to fix the issue described in the message, then reach out to our support team using the in-app messenger or email us at firstname.lastname@example.org.
Periods in the Google Sheet
Non-financial data will only be updated for columns in a Google Sheet that have a period title. If you have entered non-financial data, but have not added the date for the non-financial data, then the data will not update in Fathom.
Data removed in the Google Sheet will not be removed in Fathom
If the data for an entire period is removed in a connected Google Sheet, then when the Google Sheet is next synced with Fathom, the data will not be removed from Fathom. Instead, the data will be treated similarly to manually entered data. This means that you will be able to edit and remove the data manually in Fathom.
If you add back any data for the period in the Google Sheet and sync the sheet with Fathom, then all of the "manually" entered data in Fathom for that period will be overwritten for the KPIs linked to that particular Google Sheet. Cells left blank for that period in the Google Sheet but with manually entered data in Fathom will become empty cells in Fathom.
Still experiencing issues?
Reach out to our support team using the in-app messenger or email us at email@example.com.
Additional knowledge & common questions