Airtable - Pabbly - MS Excel
Status: Open · Asked by Atlas Admin on · 0 views
I am new to Pabbly to investigate if it is possible to:
Update an exiting MS Excel file with data from Airtable (both with new records added to a specific table and modified existing records)
Schedule the MS file to be updated daily from Airtable
I have been able to connect Airtable, but I am unsure how to make the new/updated information show in the MS Excel file.
We use the MS Excel file for populating MailMerge files in MS Word.
Hello,
Greetings!
Yes, your use case is absolutely possible. You can create a workflow where, whenever a record is created or updated, a new row will be added to your Excel worksheet.
and if a record is modified in airtable, will it adjust the details that have changed automatically?
If a record is updated or modified in Airtable, it will not update the existing data in MS Excel. Instead, the updated record will be added as a new row. Currently, updating existing data in MS Excel worksheet is not possible.
However, this is possible in Google Sheets. Please check out the video shared below: