Syncing Excel to Postgres

(1) Share

Report

Posted on by PM-28022118-0

I'm blanking on how to do this properly. I have a "List rows present in a table" to get all the rows from Excel, then a "Get rows" from a Postgresql DB. I want to do two things:

For each row in the Excel table, check if that row exists in Postgresql. If it does, update it
If it does not exist, insert the row into postgres.

How would I go about doing an "Apply to each row in Excel" > "Check if it exists in postgres" > If yes update, if no create.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I think this framework will help you keep going. Essentially in your for each loop (from excel body/values), you want to check if the row exists in Postgres by some unique ID. Then you are either updating a row or inserting a row.

I have a handful of flows like this and I know the general framework will work for you. This is common also if you are updating or inserting in Excel or Lists, etc.

Note the condition is exactly what you would use in your scenario, just an example.

Alternatively, I think you could also use "Get Row" instead of "Get Rows" and just check in the Row exists and then check if the output is empty, if true, insert else update.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

Does your PostGreSQL table have a Primary Key constraint? If yes then you can brute force it by first attempting an INSERT and then when it fails run the UPDATE. Or use IF NOT EXISTS etc.

You will also want to think about speeding this up. Instead of doing RBAR (row by agonizing row) send the entire Excel Table to PostGres and then use a Stored Procedure there to UPSERT the data.

Was this reply helpful? Yes No