I want to transfer .csv to PostgreSQL table

Questions
1

trigger detect file change in google drive then how to insert it into PostgreSQL table whit condition checks [if existed in some tables = drop] otherwise insert

thank you very much

2

The process is straightforward:

  1. First, load the CSV file (e.g., using the “Read File” or “Extract From File” node in your workflow).
  2. After loading the file, each row in the CSV becomes an individual data item.
  3. Next, fetch the necessary values from the database that you will use for comparison.
  4. Use an “IF” node to check the conditions, and then insert the required data accordingly.

Keep in mind that the Postgres Node also offers an “Insert or Update” functionality. In some cases, this might be sufficient for your needs.

After utilizing the “Extract From File” node, you will end up with multiple items — one for each row in the CSV. This means that subsequent nodes will process these items simultaneously (parallel execution). If your CSV contains many rows, it can be more efficient to use a Loop Node. With this approach, you can set an appropriate batch size to control how many items are processed at a time.

3

I’m building a fully automated AI agent for cold email outreach, but there are so many paths and choices, and not enough direct tutorials. I’ve got to gather pieces of knowledge bit by bit and put them together.

Your insights give me a clearer puzzle—big thanks for that. I’m also building an AI voice agent to automatically call businesses I scrape into a .csv, so this is my starting point: marketing first.

I’ve set up n8n on EC2 and integrated PostgreSQL 17—way faster than SQLite. But when it comes to the “how-to”, there’s way less documentation than I expected. Maybe it’s still a “make a lot of money” kind of space.

Once I get this working, the next step is an AI chatbot (vector DB in Pinecone, I think), integrated into my Next.js site. I’m considering embedding it via cdnjs, but let me know if there’s a better way.

Hopefully, I’m still in the blue ocean phase.

4

thank you very much sir
can we use ai agent and its instruction to do this?
I’m trying but seem very slow each row analyze

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.