python script parse information form table on an email and add to spreadsheet

the python script must be able to parse the following information from the email: the transaction date The instrument name (AMD in this example) it is before the / if it was bought or sold The quantity the price in EUR which needs to be multiplied by the conversion charge (usually 0.8-1.2) the commission/ fees if applicable (usually 0) Fill in the trading account as 'Trading 212' This will be repeated for every transaction in the email (usually 20-30) This will then be added to a google spreadsheet