Rather than updating the record in the script, add some output from the script like `output.set('chosenLink', chosenLink)` and then add a separate Update Record step. This will allow you to test more easily and see that the `chosenLink` output is wha...
Also see https://community.airtable.com/t5/automations/how-to-get-one-record-from-quot-find-records-quot-step/td-p/62161 for using a scripting step to return just a single value.
While Airtable Automation's Update Record action doesn't seem to mind if you put a list of length 1 in, for example a number field, instead of just the number, it is pretty easy to add a script step to just return a single value from the Find Records...
I would love to do this as well. You can create a file, or a data url, in JS, but there is no way to add it as an attachment currently. Could you share how you send your file to a publicly-accessible host as a stopgap?
I'm successfully generating a CSV in a script block, and adding the result to a multi-line text field, as well as outputting it as text to the block `output`. But I'd prefer to attach it as a file, or better yet, have it download automatically. The l...