How to update database with scraped data

I have a table with these columns:

Person_Name, Email, Latest_Post_Title

Every day I scrape new records that include

Email, Latest_Post_Title

If a scraped email matches an existing one in my table, I want to update the

Latest_Post_Title

for that row with the scraped

Latest_Post_Title

If a scraped email doesn’t match an existing one in my table, I want to create a new row for it.

I’ve been experimenting with a Full Outer Join, but I question if that’s the best way to do this. (There are actually more columns than described in my simplified example.)

I would appreciate any ideas. Cheers, Richard