Importing and Enriching Data in Airtable for Seamless Workflow Integration | Clay

Importing and Enriching Data in Airtable for Seamless Workflow Integration

Hi team, I'm trying to run a workflow around airtable and am struggling to do the import back. So basically I'm importing data from clay into airtable where my team can do a manual enrichment and then I need to wait some time and create a trigger to import back several fields into clay before I add to my email campaign. I can't seem to figure out how to do this correctly with enrich your data from airtable function.

✅1

43 comments

Dominick C.
·
·
https://app.clay.com/workspaces/206908/tables/t_g3HDszP2shcJ/views/gv_FV2e9vhTVAcc
Dominick C.
·
·
I can't see the columns in airtable that I would want to pull in
Clay Team
APP
·
·
Hey, thanks for reaching out, sorry for the delay! Taking a look
Clay Team
APP
·
·
I noticed a different thread where you were able to map out Airtable already, correct? So to follow up on this one...
Dominick C.
·
·
I wasn't actually
Dominick C.
·
·
so I was able to get it working with writing to airtable from clay, but now I need to go back the other way and can't figure it out
Dominick C.
·
·
https://www.loom.com/share/f4243c0846b440bcb3e39b4abca70d2a
Dominick C.
·
·
here's a loom I created
Dominick C.
·
·
Here's the table
Dominick C.
·
·
https://app.clay.com/workspaces/206908/tables/t_g3HDszP2shcJ/views/gv_FV2e9vhTVAcc
Dominick C.
·
·
Thanks for your help!
Clay Team
APP
·
·
I would use the lookup to find any updates and append the existing rows, but unfortunately, that's not currently automated... You would need to manually re-run to fetch the updates.Here's a loom I just recorded with some thoughts: https://www.loom.com/share/037fa307084244529af1f236786fcb73
Clay Team
APP
·
·
^Airtable's Lookup integration that is
Dominick C.
·
·
Thanks for this, Arturo
Dominick C.
·
·
Haven't done a ton with webhooks. Let me toy around with it. Is there a good resource on how to use webhooks and make and clay/airtable with some examples? I'm just starting to get into this world and learning about what and how to build these. Seeing it in practice would help a lot I think
Dominick C.
·
·
So, for the airtable lookup record, I can see that there is a matching record, but I'm not sure how I can then write fields from that record back into clay. Could you help me map that out?
Dominick C.
·
·
Juan P. fyi, thread has been picked up here
Clay Team
APP
·
·
Sure! Here's a video showing a few automations you can set up in Clay (webhook example in the first few minutes of this video): https://youtu.be/yw5paDolwTQ?feature=shared
Clay Team
APP
·
·
It's not very in depth either, but there may be similar suggested videos in YT that could cover the gap. Overall, it depends on the platform you use and what options they have available
Clay Team
APP
·
·
About the second question.... Here's a quick video on how to extract nested values from enrichments or imports- https://www.loom.com/share/32ae94f5fee34a82b9fa739b53741d00?sid=f67d4463-1cac-477b-a82a-f2e0fe072cb6
Dominick C.
·
·
So I can't seem to find the nested values from the airtable lookup function
Dominick C.
·
·
https://www.loom.com/share/0854d88cfd2d457687ede3bce623e541
Clay Team
APP
·
·
Sorry for the late reply, Dominick!! I did see them in your video though, there were subfields/menus that you could further expand to extract the values.
Clay Team
APP
·
·
Quick screenshot about it
2fb793db-a83a-45c7-92cc-ea445469f415.png(39 kB)
Dominick C.
·
·
Ahhhhh, there it is!
Dominick C.
·
·
thank you
Dominick C.
·
·
Is there a way to make a column wait a certain number of minutes before running when it's up in a workflow? That might solve my problem if I put like an hour time delay on writing back into clay
Dominick C.
·
·
Also, for some reason it's not pulling in all the fields. Any idea why that might happen?
Dominick C.
·
·
Maybe it's only pulling in text field types? Is there a workaround here?
Dominick C.
·
·
hmm, even some of the fields it's not pulling in are just long text fields. So, not sure what's happening there.
Dominick C.
·
·
I have about 90 fields and it's pulling in 22 and there doesn't seem to be a rhime or reason for it with field type
Clay Team
APP
·
·
To confirm, those leads from the lookup results do have these 90 or so fields? Happy to check with the team if there's an issue.Also, we don't currently have a way to schedule/delay runs, it was brought up and there's a ticket for that feature but no ETA yet. Hopefully soon!
Dominick C.
·
·
so, the lookups do not have them
Dominick C.
·
·
it's only showing 22 fields
Dominick C.
·
·
Here's a loom to share- https://www.loom.com/share/9c7597133cca420f9c022d050e1cf4b7
Dominick C.
·
·
okay, so I just tested it by making single line text field that's new and trying to import that, which didn't work either. So, it doesn't appear to be linkedin to field type
Dominick C.
·
·
Arturo O. any luck here?
Clay Team
APP
·
·
Sorry if my question wasn't worded properly. I was referring to those records you looked up when you go to your Airtable, do they have those 90 fields or so? For example, does Ankit Garg (from the screenshot above) have all those fields inside Airtable?
Dominick C.
·
·
standby
Dominick C.
·
·
boom, that did it
Dominick C.
·
·
okay, so it won't return a blank field
Dominick C.
·
·
Thank you very much for your help, that was a battle
Clay Team
APP
·
·
Yep, makes sense! It's probably part of Airtable's api to skip those and just show populated fields. :)