Welcome to the Make community!
To do this, that’s usually done using the Google Sheets “Watch Changes” module —
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
For more information, see https://www.make.com/en/integrations/google-sheets, and https://www.make.com/en/help/app/google-sheets in the help centre.
However, the “Sheets Add-On” plugin is currently unavailable.
For more information, see Is the Google Sheets to Make app down for anyone else
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.