How to automate bringing in info from Table B to Table A based on matching records

This is probably a basic task but I’m not finding info on how to do this.
In Table A I have application info from applicants that are submitting through a form
In Table B I have info coming in from Paypal (via Zapier) of payments from applicants (their application fee)
How do I have each record in Table A reference each record in Table B, matching the records by the Email column, so that Table A automatically brings in the $ amount in Table B?

Thanks for any tips!