Zapier lookup between Google Sheets driving me crazy

[JackHero77]

I’m stuck on what seems like it should be straightforward but I can’t figure it out.

Here’s my workflow:

1. Someone fills a form on our website with first_name, email_address, and postal_code
2. Zapier creates a new row in my main Google Sheet with these columns: first_name, email_address, postal_code, team
3. I have a reference Google Sheet with postal_code and team columns
4. This is where I’m lost - I need Zapier to find the postal code from the form in my reference sheet, grab the matching team value, and put it in the team column of my main sheet

The lookup part in step 4 has me totally confused. Once I get this working I can push the data back to our CRM and finish the automation.

Any ideas how to make this work? Really appreciate any help!

[TomDream42]

Had this exact headache last month! Add a Filter step after your lookup - catch it when the team field comes back empty from your reference sheet. Also check your postal codes for extra spaces. That’s what broke mine for weeks.

[Pete_Magic]

In a situation like this, clarity in your Zapier setup is crucial. After the trigger captures the form submissions, add the ‘Lookup Spreadsheet Row’ action to retrieve data from your reference sheet. Configure the lookup to match the postal_code from the form with the corresponding column in your reference sheet. This step will pull the associated team value directly. Ensure that the formatting of your postal codes aligns perfectly in both sheets, as any minor inconsistencies could lead to failures during the lookup process.

[benmoore]

I recently faced a similar challenge and found that using the Lookup Spreadsheet Row action in Zapier simplified the process significantly. After your form trigger, you should add the Lookup Spreadsheet Row step to point to your reference sheet. Make sure to specify the postal_code as the lookup column and input the postal code from the form as the lookup value. This will allow you to retrieve the corresponding team value, which you can then include when you create a new row in your main sheet. Additionally, ensure that your postal code formatting in the reference sheet is consistent, as discrepancies can cause issues. To handle potential mismatches, consider incorporating a default value in case of no match found.