In this article:

How to Track Changes in Google Sheets (Easiest Way in 2024)

Can You Track Changes in Google Sheets?

Changes in Google Sheets can be tracked using "Version History" to review and revert to previous versions of the sheet, while "Cell History" can be used to access a detailed edit history of specific cells. The platform also provides "Notification Rules" for setting up email alerts for any modifications to facilitate real-time monitoring and collaboration.

How to Track Changes in Google Sheets Using Version History

Follow the steps below to track changes in Google Sheets using the ‘Version History’ feature. 

1. Open the Desired Google Sheet for Tracking

Begin by opening the specific Google Sheet where you want to track changes.

track changes in google sheets

2. Navigate to 'File' > 'Version History' > 'See Version History'

Click on `File` in the top menu, then select `Version history`, and choose `See version history` to access the history panel.

google sheets track changes

3. Review and Compare Past Spreadsheet Versions

In the version history panel, review the list of previous versions. Click on any version to see the changes that were made at that time.

how to track changes in google sheets

How to Track Changes in Google Sheets Using Cell History

Follow the steps below to track changes in Google Sheets using the ‘cell history’ feature. 

1. Click on the Cell to Check Its Edit History

Select the cell you want to investigate for past edits.

track changes google sheets

2. Right-Click and Select 'Show Edit History' for Details

Right-click on the chosen cell and select `Show edit history.`

can you track changes in google sheets

A detailed log of all changes made to that cell will appear.

How to Set Up Notification Rules to track Changes in Google Sheets

Follow the steps below to set up notification rules to track changes in Google Sheets. 

1. Open the Google Sheet for Notification Setup

Access the Google Sheets document for which you want to set up change notifications.

2. Go to 'Tools' > 'Notification Rules' to Configure Alerts

Select `Tools` from the menu bar and then choose `Notification settings` to open the notification settings. You can either choose 'Edit notifications' or 'Comment notifications.'

3. Create and Save Your Preferred Notification Settings

If you choose to edit notifications, you can select the type of notifications you want (e.g., any changes, daily summary) and select how you want to receive them (email right away or a daily summary). Click 'Save.'

If you choose, 'Comment Notifications,' you can set notifications for all comments, comments for you, or none. Click 'OK.'

We hope that you now have a better understanding of how to track changes in Google Sheets using different methods. If you enjoyed this article, you might also like our article on how to subtract multiple cells on Google Sheets or our article on how to center across a selection in Google Sheets.

Automate everything you track in spreadsheets with Lido
Learn more

Automate manual tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started