Welcome to the community, @Magnuson_Center_for!
If your Google Sheet is just a list of cities, states, and zip codes, you could potentially bring all of that information into its own table into Airtable. Then, you could link your contact zip codes to the other table in Airtable, and lookup the city & state.
However, the gigantic problem here is that there are almost 50,000 zip codes in the United States, and Airtable limits you to a maximum of 50,000 records in an ENTIRE base (in a Pro workspace).
There are many people here whom you can hire to help you with this process, including myself if you want to go down the low-code/no-code path.