Compare Airtable table to excel sheet and update / add excel sheet rows

How To
,
1

Hi Everyone,

I’ve got what I think is a fairly simple automation to make, but I’m having trouble.

I have an Airtable base, and a working connection to it using a “Watch records” module.
I have an excel spreadsheet that lives in Onedrive. I have a working connection to it using an “Update worksheet rows” Module, and an “Add rows module.”

Each record in Airtable has a unique ID number field (in addition to it’s auto generated ID) and a Modified time field.
The Excel file is exactly the same header row as the Airtable table.

I need the excel file to be updated whenever a record is added or changed in Airtable.

For example, if the modified time is changed and in Airtable, and the contents of the ID field exist in both places, the rest of the excel row should be updated to match the field changes from the Airtable record.

If a new record is added to the Airtable, then that row should be added to the excel file.

I’m brand new to the Make platform, and having trouble understanding what modules and settings are needed to make this work.

I also would like to build a separate automation that moves data from two of the excel sheet cells into airtable by matching the unique ID number from the excel sheet to the unique ID number in the Airtable table, then copying the related data from excel to Airtable.
Similar to what I describe above, but in reverse and only moving two cells of information back into Airtable from excel, not all the data.

I’ve tried some options but am getting a “[400] The argument is invalid or missing or has an incorrect format error” I’m certain I’m missing some key information on how to do this properly.
I also don’t understand the “Row ID” and what is needed there to do this, or the “Mapped” toggle button in the add worksheet row module settings, obviously I don’t want to just modify one row.

Any guidance would be greatly appreciated.

Thanks!

2

Hello @Maury_Jensen,
You can always follow the row number(1,2,3) and column name(A-Z) in Excel. Another thing is that a cell is a combination of rows and columns.

While in the Airtable it’s always field name and row ID (record id). Finding Airtable IDs | Airtable Support

Now you need to keep in mind that you always go with rows and columns while handling data in Excel and understand how record IDs and fields work on Airtable.

About specific to your error “[400] The argument is invalid or missing or has an incorrect format error” → can you please share a screenshot or some more details about it?

:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best Answers as Solutions :white_check_mark: and give :+1: If you need expert help or have questions? Contact or comment below! :point_down: