Load new records, update changed rows, export CSVs. Every one is ready to run, and you can adjust it in plain language.
Put valid API data in the shared table and list entries needing correction.
Your Google Sheets table gains valid entries from new JSON responses, with rejected entries listed for review.
Prepare API tables for review with missing values clearly marked.
Your teammate gets a shared spreadsheet and matching CSV, with missing values called out instead of buried in raw JSON.