Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Airtable Find Record from Google Sheets not working

  • January 19, 2023
  • 4 replies
  • 68 views
U
Forum|alt.badge.img

I have a Google Sheet with record data, and a similar sheet in Airtable.

Airtable has data gets updated data from the Google Sheet.

My steps are:

On updated Gsheet record, find corresponding record in Airtable, Update Airtable Record.

I’m currently struggling with the FIND corresponding record in Airtable.

I can’t find the record, even though I KNOW it’s there - I get the Google Sheet field, then do a normal search (Ctrl+F) in Airtable and find the record.

The Airtable Record lookup finds other fields, except this one field. I thought it might be because it’s a Concatenated Field in Airtable, butI have tested other scenarios (shorter concats) and it comes out fine.

 

Some screenshots:

Search in Excel - I use Col$D

 

 

My search in Airtable:

 

 

 

And then I do a test search

The field I’m trying to find in Airtable is “Victory Point Wines Pinot Noir 2021 Margaret River”

This is in Airtable:

 

Best answer by unodewaal

@Troy Tessalone I just added the screenshots and then figured it out.

 

My concat field had 4 items it was concatenating. One of the middle fields was blank, causing it to add an additional space which for some reason was dropped in copy/pasting to Airtable, but it was picked up as a field.

I’ve removed the concat that could be blank and it found the field.

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

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34001 replies
  • January 19, 2023

Hi @unodewaal 

Good question.

Best if you can provide detailed screenshots of how your Zap steps are configured in order for us to have enough context, thanks.

Also, provide a specific example for us. (screenshots too)

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
U
Forum|alt.badge.img
  • unodewaalBeginner
  • Author
  • Beginner
  • 2 replies
  • Answer
  • January 19, 2023

@Troy Tessalone I just added the screenshots and then figured it out.

 

My concat field had 4 items it was concatenating. One of the middle fields was blank, causing it to add an additional space which for some reason was dropped in copy/pasting to Airtable, but it was picked up as a field.

I’ve removed the concat that could be blank and it found the field.

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34001 replies
  • January 19, 2023

@unodewaal 

You could also add a TRIM() function around the concatenated fields in the Airtable Formula field to remove whitespace.

 

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
U
Forum|alt.badge.img
  • unodewaalBeginner
  • Author
  • Beginner
  • 2 replies
  • January 19, 2023

Thanks @Troy Tessalone that’s useful - in my case it was adding the space in the middle of the wine name - but useful for future reference! Also thanks for the quick reply.

Terms & ConditionsAccessibility statement