I have an airtable base with two fields : name and website. Some of the orgs have website filled and some don't. I want to do the following
1. Check if the website column is empty.
2. If no, nothing should be done.
3. If yes, look for the name of the org in the 'Name' column
See if it matches with the name in an excelsheet/google sheet
Find the corresponding website from the excel
Update it back in airtable against the name
How can I proceed with this? I read about API calls. Would the update to each record be considered as 1 API call? Is there a way to find records in bulk, match and then update records in bulk? I am okay to do this using Python script as well. However would like to first know if this is possible through airtable automation , automation using make or airtable script (extension) before looking to write a Python script.