Google Sheets Data Feed & Analysis

I need a Google Sheets workbook that can take recurring data feeds, organise the raw information automatically, and deliver clear analytical insights—ideally in a single, self-updating dashboard. You will receive the source files (or connection details) once we start; for now, assume the data arrives in regular batches that should slot straight into the sheet without manual clean-up.

The job covers:

• Structuring the sheet so new rows flow into the correct tables and named ranges.
• Adding formulas, pivot tables, or App Script where useful to automate calculations and keep everything up to date.
• Building an analysis section that surfaces key metrics and trends at a glance—charts, conditional formatting, anything that helps me spot what matters quickly.
• Documenting what you build so I can add or adjust fields later without breaking the system.

Your work is done when the file accepts a fresh data drop, recalculates instantly, and the summary view refreshes without errors. If you have questions about the data format or preferred visualisations, ask early; I’m happy to clarify.