this is my first project of its kind, so here is what I did :

- fetched and extracted data from the company's website API using python (it was complex data )

- scheduling the python script on google cloud to extract, transform and load the data into google bigquery (using Cloud functions and cloud scheduler)

- developed a responsive email HTML

- created a second python script to send emails which I will schedule later to run (using SMTP)

- created a third python script to get data from previous bigquery tables , i'll use the data to make the email send under some conditions and customize the email according to that data

- developed plotly reports in the third python script and I appended them to the HTML email so the email looks like a nice responsive email that fits their brand and has reports

- scheduled the second and the third email again on google cloud so it sends emails regularly when a condition is met with some reports and stuff

this project took me around 7 days to complete, and I wonder how a data scientist/data engineer would estimate the total price for this project, thank you in advance!