I have several AirTables (separate) that I use to track report status.
Is there any way to aggregate data from several AirTables and then sent a single email saying here are the overdue reports (Name field in AirTable)?
Or, I have to have a separate flow for each AirTable? Note that each AirTable may have more than one report overdue.
you can do this be aggregating each airtable to a CSV for example.
Then appending each CSV to the end of the previous one.
and then sending the final combined CSV, or passing it to the next set of modules.
Hi! Can you provide more detail on how to append a CSV? I have a CSV that I need to add rows to and make sure there are no duplicates but I can’t seem to figure it out.