I am a new user and here is what I would like to have happen:
I have a contact list-when I add or change a contact, I want to obtain the city and state, based on zip code, from a google sheet sheet which contains all this desired information, and update the record in airtable with the city and state. Everything I find wants me to trigger from changes in google sheets and update google sheets. Does anyone know how I can lookup info from one(airtable) by looking for a match in the other (google sheets) and write back to fields into airtable?