About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

  • 19 January 2023
  • 4 replies
  • 46 views
U
Userlevel 1
Badge

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:

 

icon

Best answer by unodewaal 19 January 2023, 04:47

View original
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
Userlevel 7
Badge +14

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 | Premier Certified Zapier Expert | #1 Zapier Community Contributor
U
Userlevel 1
Badge

@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
Userlevel 7
Badge +14

@unodewaal 

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

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
U
Userlevel 1
Badge

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 & Conditions