Updating Airtable from Google Sheet without exceeding record limit

  • 23 November 2021
  • 1 reply

I have a multi sheet Airtable Base and it contains multiple columns, one of which is zip code.   I have a table in Google sheets which has zip code, city, state, and country.

We manually add records to our base, and we would like to be able to ‘reach’ into the gsheet and pull back the city, state, and country into the base.    I have tried many avenues, but to no avail, other than having a sheet in my base with that information listed.   That puts me past the allowed number of records in airtable.   Does anyone have a solution and/or suggestion?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Magnuson 

Try these Zap Steps...

  1. Trigger: Airtable - New Record (in View where Filters are set to indicate a Record w/o the updated Zip related data points)
  2. Action: GSheets - Lookup Row
  3. Action: Airtable - Update Record (map Record ID from step 1)