I am new to make.com
I am trying to bring Sheets data into Airtable. Both Airtable and Sheets have a calculated field (labeled “key”) that is unique to each row of data. That field is identical in both apps.
The goal is to compare the Sheets Key field for each record to the Airtable Key field to see if it exists. If it does, then update the Airtable row, otherwise add new Airtable record.
Here is my scenario.
The Sheets Search Row module has no filter, so all row in the sheet are passed to next module, Airtable Search.
Here is the output of one bundle from Sheets
The search module is comparing the data in the Airtable {key} field to the Sheets key field. I suspect this is where I am screwing up, but I have tried everything under the sun for this filter.
The output of Airtable search looks like this for one bundle:
I think (???) that the “number of bundles = 0” in the output means that there was no match?
But the key field in Airtable and Sheets do have the same data in them. Cannot figure out what I am doing wrong.
ADDITIONAL THOUGHTS
I am assuming (and this may be incorrect) that Airtable Search module is searching the entire table in that field (key) for a match. Is that correct?