So we would have a google sheet which is a list of volunteers that have completed the agreement form, we would use the whenever a new row is created trigger, but is there a way for it to look at the row and match the volunteers name when it is making changes to the row in the linked CRM? Or will it just make changes to the newest row regardless of if the volunteers name in the CRM matches

Whenever we get a new application the rows will change in both sheet and CRM and sometimes there will be more people in the CRM than in the sheet since not all people in the CRM will complete the agreement to fully become a volunteer

Make an explanation if that helps https://imgur.com/Ue9NDjM