[Airtable] Update record if it already exsists

Questions
1

I need to update a database of leads based on input from my email system.

When a lead is updated, it sends a webhook which Make catches - perfect.

Now I want to send this information to Airtable using “Upsert a Record” which should ‘create or update exsisting record’.

Since I have multiple touchpoints, very often an exsisting lead will simply change status, i.e. from “contacted” to “interested”

When I update an exsisting lead’s status in the email system, a new record is generated with the exact same information aside from ‘status’, rather than updating the exsisting one.

Question: How do I check if a @email already exsists in Airtable and if it DOES, update a cell in that record, and if it DOES NOT, create a new record with that information?

image
image992×415 33.5 KB

2

Anybody knows about this or can point me to where I can read about it?

3

Sure. Start with the docs thread. The ultimate Make Documentation Topic

You’ll need to use a router and filters to check the results of your searches on the email.

4

Hi @Oliver1

You can use the Airtable module “Search Records” to accomplish this. For more details, refer to the below link:
https://www.make.com/en/help/apps/database/airtable#search-records-964541

MSquare Support