Help fixing inconsistent results from automation

How To
1

I have an automation set up in Make that monitors a specific One Drive folder and then does a bunch of things with the new file. I’m including each step below. The problem is, the results are inconsistent and I’m not having any luck figuring out what’s going on because sometimes it works and sometimes it doesn’t, but not always in the same way. I’m including the types of errors I’m getting below the outline of the automation.

Automation Goal: Produce a summary of a report and add the summary into a Notion database.

  1. Onedrive watches folder to see any new reports are added. (done based on Created Time)
  2. Onedrive module downloads the file
  3. OpenAI module uploads the file
  4. OpenAI module adds file to a vector store
  5. OpenAI module instructs an assistant which is pointed at that vector store to look for that file and create the summary.
  6. OpenAI module deletes the file from the vector store.
  7. Notion module makes an API call to let it know we’re going to upload a file
  8. HTTP module uploads the file
  9. Notion module creates a database item using the date the file was added and the file name
  10. Notion module adds the summary that OpenAI created to the newly created database item and uploads the file to Notion

When I add a single file to the folder and then manually run the automation, it works perfectly. The problem occurs when I add multiple files. When I add multiple files I’ve had all of these results:

  1. Works perfectly.
  2. Each database page is created correctly in Notion (name, date, and file attached are correct), but the summary generated on the second or third iteration will be based off of the first iteration’s file (which should have been deleted from the vector database). Note that when this happens, the summary is not identical to the summary that was added to the first iteration, it will be different text, but about the same document.
  3. The first and third iteration worked perfectly, but the second iteration somehow took pieces of multiple documents that were added and the summary has information from each.

If anyone has any tips on how to proceed or where the issue might lie, I would love some help. The thing that is most confusing to me is that the error is not always the same.