I’m looking to enrich an entry in my Airtable People database with Clay. The Airtable record starts with just a LinkedIn URL, which I send to Clay via Zapier. I can then get the full enriched record in my Clay table, and can update the original Airtable record with most info, but not the Organization field (or any other linked field for that matter). Presume I need to do a lookup etc. Any suggestions for how to do this?
For updating linked fields like Organization in Airtable with Clay-enriched data, you can use either the Update Record or Upsert Record actions. Here's how: 1. First, use the Lookup Record action in Airtable to find the Organization record you want to link to. 2. Then, use either: • Update Record: When you know the record exists and have its ID • Upsert Record: When you want to create or update based on matching valuesBoth actions support updating any field type, including linked records, as long as you provide the correct field format according to Airtable's API requirements.Make sure your Airtable account is properly connected to Clay with the necessary permissions to modify the bases you're working with. Sources: Upsert Record with Airtable Update Record with Airtable Airtable integration overview | Documentation | Clay University
You can setup a lookup and keep linking the records via api in airtable
can be done within clay
setup a lookup field in people table in airtable and then you can setup http integration to link that record to pull data from org table
Yes, you can handle linked fields in Airtable directly through Clay's integration. The Airtable integration in Clay provides several actions that can help with this: 1. Use the Lookup Record action to find existing records 2. Use Update Record to modify existing records 3. Use Upsert Record to create or update based on matching valuesThese actions support all field types in Airtable, including linked records, and can be configured directly within Clay.Make sure your Airtable account is properly connected to Clay with the necessary permissions to access and modify the bases you're working with. Source: Airtable integration overview | Documentation | Clay University
To set up and use a lookup field to pull organization data in Airtable through Clay, follow these steps: 1. In your Airtable People table, create a lookup field that will connect to your Organization table. 2. In Clay, you can use the Lookup Record action to find and match organization records. This requires: • The Base ID of your Airtable • Appropriate lookup criteria to match the organization records 3. Once you've added new company data to your organization table, you can rerun the lookup in your people table. This will pull the enriched company data into your people table, giving you a complete view of each contact's company context.Make sure your Airtable account is properly connected to Clay with the necessary permissions to access the bases you want to work with. Sources: Airtable integration overview | Documentation | Clay University Lookup Record with Airtable Enrich People (Waterfalls) [Automated Outbound] - Clay University
Thanks both. Would be great to have more details of the steps - assume I am adding an organization since it’s not in the existing airtable org table. First, presume best to match on the URL of the org, not the org name as there can be variations? And then do I create a new entry in the org table as a step, and then do the people update step?
Here's how to add a new organization and link it to people in Airtable using Clay: 1. First, use the "Create Record" action in Clay to add the new organization to your Airtable organization table: • Select your Airtable Base ID • Fill in the organization details in the additional fields 2. After adding the organization, you can use the "Upsert Record" action to update your people records: • Specify the Base ID and match criteria • Include the new organization reference in the fields to update 3. Once the new organization data is in your organization table, simply rerun the lookup in your people table. This will pull the enriched company data into your people table, giving you a complete view of each contact's company context. Sources: Airtable integration overview | Documentation | Clay University Create Record with Airtable Upsert Record with Airtable Enrich People (Waterfalls) [Automated Inbound] - Clay University
(Tried to follow the clay guide linked but just goes to an Airtable API guide which is impenetrable…)
I understand your frustration. Let me help clarify the process using Clay's Airtable integration: 1. To create a new organization record in your Airtable organization table: • Use Clay's "Create Record with Airtable" action • You'll need your Airtable Base ID • Fill in the organization details in the provided fields 2. To link this organization to people records: • Use the "Lookup Record with Airtable" action to find and match records • Then use "Create Record" or "Update Record" actions to establish the connectionIf you need more detailed guidance, I recommend checking Clay's documentation at docs.clay.com for step-by-step instructions. Would you like me to explain any specific part of this process in more detail? Sources: Create Record with Airtable Airtable x Clay integration | Clay.com
Hi Stephen J.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Hi Stephen, thanks for reaching out! Stephen - Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1736194500&signature=c5c3a0274ebd841a0e22e96631f310e4cbcd1b2cbb02175371d0c762a8b89a6b&req=dSEgF85%2FmohWX%2FMW1HO4zYTywS39D5MT2BKsam%2FhVPsDpQ%3D%3D%0A
Hi Tanvi - here you go: https://app.clay.com/workspaces/393040/tables/t_si5rqrkcpWcT/views/gv_yUWsZ7ujneZM
.png){kind=logo}
