we’re using an Amazon AppFlow to copy across the ‘responses’ from a form to a csv file.
it’s working as a proof of concept, in that we manually run the flow, and all response data is saved to the specified S3 bucket in a new, unique folder as a new,unique csv file.
obviously this ends up creating more folders and files than we need.
I’m interested to see if anyone has a best practice solution that would:
- trigger the appflow to run when the form is completed - maybe using a webhook?
- add the new submission to the one csv file as a new line or that might mean overwrite it I expect,
I’m sure someone will know the answer, your suggestions much appreciated!