- Cloud based scraping system runs at a designated time each morning, collecting property for sale counts from various sources, for every county in England.
- Automated script detects that new data is present in the scraping system and imports this data into a shared Google Sheet.
- Using a mix of formulas and macros, the data is analysed and a tweet constructed, using basic rules. These tweets are added to a separate sheet.
- A second automation script detects that there are changes / updates to sheet in question and automatically posts these updates as tweets.
The result is an automated twitter feed, providing followers with up to date aggregated performance data along with a steady traffic stream.