Hi there,
I use gravity forms and Zapier for an induction process. User completed a gravity form and captures details such as first and last name. When submitted this updates a spreadsheet row in a Google Sheet.
What I’d like to do, is similiar, but have the Zap check the gravity forms First Name and Last name fields against a pre populated Google Sheet with First and Last names plus other info. If the Zap matches the names fields it then changes/adds text to the cell on that row.
I’m trying to avoid having to check two spreadsheets - one for accreditation and the other for induction completions and bring the two into one combined spreadsheet.
Thanks you in advance of any help.
Chris
