Copper and aluminium inventory reporting
Google Apps Script automation for collecting LME and SHFE copper and aluminium inventory data and generating scheduled reports.
The project
The inventory tracking workflow collects copper and aluminium warehouse information from LME and SHFE data sources. The aim was to make repeated collection and reporting part of a scheduled process.
My contribution
I designed the automation using Google Apps Script. It collects the relevant inventory information and applies reporting logic to prepare updates from the source data.
Why the workflow matters
A recurring report has several steps: collect the information, organise the fields, apply the required calculations and prepare an output someone can review. Defining those steps clearly makes it easier to automate the process and investigate missing or unexpected data.
Planning a reporting automation
For a similar project, share the sources you use, an example report and the update frequency you need. We can then discuss access, data quality, scheduling and the output format before estimating the work.
Discuss a similar project
Explore my reporting automation services or send a project enquiry with your requirements and preferred timeline.
Need a Commodity Intelligence Tool?
I can build automated market signal systems for any asset class or exchange.
Get in Touch →