Match incoming JSON records to existing rows, add valid new records, and update changed ones.
Update the operations table and flag records needing review.
Your shared sheet stays current with daily JSON records. Your email shows new and changed row counts and links to entries needing attention.
Update the shared spreadsheet from the daily API feed and export CSV.
Your shared spreadsheet stays current with the latest JSON feed. Get a matching CSV and a report of what changed.
Add valid JSON entries to the running table and list rejected ones.
Your Google Sheets table gains valid entries from new JSON responses, with rejected entries listed for review.