I need to build a website that updates prices daily for a set of inventory.
The prices are sent via email to me by gmail. I have a program to download emails from gmail already.
What I need is a program to search through the emails and pick out the pricing for selected items and display them on a website.
The website will need to be custom built.
Every day I have to update prices for Green Apples, Red Apples, and Fuji Apples.
The emails I receive have standardized formatting, so it will read:
Fruit Services Pte Ltd, Today's pricing--
Green Apples: $5.25 /kg
Red Apples: $3.75 /kg
Fuji Apples: $7.25 /kg
I need to be able to automatically scrape those prices and post the prices on a website. The updates may come frequently, so the scraping and posting needs to be refreshed every 5 minutes.
The data should be scraped and be usable, for example if I want to calculate the average pricing of apples for the day.
I prefer programmers based in Singapore.