Predecessors

I’d suggest trying to use Record Templates instead if possible, would make the predecessor creation much simpler! https://support.airtable.com/docs/using-record-templates-in-airtable

We set it up within the template itself:

And when applying the template (either by right clicking or via an automation), it gets created for us automatically:

Setting this up with automations alone is doable, but also going to be pretty difficult.  The main problem we have to solve is that we need to link the newly created Task records to each other as predecessors, and so we’d need to:

1. Full create all the Task records
2. For each of these Task records, find its predecessor from the newly created list and link them

And so to handle this I think we’d need:

1. A helper table that groups each set of Tasks that are being created so that we can look in this group for their predecessor
2. A second automation that will trigger when the Tasks all get created from the first automation
   1. We can’t add this functionality into the first automation as Repeating Groups run in parallel, and so there’s no way to be sure that Task 1 is created before Task 2, and so there’s no way to link them, does that make sense?

You could also try doing it via a Script too, but Record Templates would really be the most straightforward way to get this done I think!

Please use scripts.
Set it to use two passes: one to read the template table and create records in the destination table, then link the predecessors in the same order as the template. Should be straightforward for chatgpt.