Use the Guardian Media Group API and schedule a daily automated task to do below steps:

1. Extract information about Justin Trudeau for sysdate-1
2. Save the result as a file in the local folder
3. Read the file and import it into the database using “Bulk Insert”
4. Do require a cleansing process on the data
5. Create a log file to check if any issue happened during the process