Match incoming JSON records to existing rows, add valid new records, and update changed ones.
Refresh the team's shared spreadsheet with each morning's API data.
Your shared sheet stays current with daily JSON records. Your email shows new and changed row counts and links to entries needing attention.
Keep the shared table current and show what changed in each import.
Your shared spreadsheet stays current with the latest JSON feed. Get a matching CSV and a report of what changed.
Update the team's running table and flag entries that need correction.
Your Google Sheets table gains valid entries from new JSON responses, with rejected entries listed for review.