You are helping me build the following AI agent workflow.

## Goal
Daily Trello Task Tracker with Google Sheets History Log: Every day, it snapshots all Trello tasks with names, due dates, and lists into a persistent Google Sheet history log.

## Specification
- What it does: You get a complete daily snapshot of your Trello tasks, including names, due dates, and list locations, automatically saved into a persistent Google Sheet history log. This keeps a permanent record of your board's status without any manual data entry or tracking effort.
- Trigger: On a schedule (Scheduled · daily)
- Autonomy: Fully hands-off
- Expected setup effort: about an afternoon
- Tools/services involved:
  - Trello: Pulling tasks and board data
  - Google Sheets: Logging task history
  - Code: Normalizing data fields

## Known pitfalls, handle each one explicitly in your implementation
1. Google Sheets append operations can fail silently on large datasets, verify row counts after each execution to ensure data integrity.

## Reference implementation
https://n8n.io/workflows/7673 (workflow template)
Fetch and inspect this before building. If it matches my stack, adapt it;
if not, rebuild the pattern with my tools.

## Process requirements
1. Before building: ask me which of the listed tools I actually use and
   what my platform is (n8n / Make / code / other). Do not assume.
2. Adapt the pattern to my answers; do not force the reference stack.
3. Address every pitfall above; tell me how you handled each.
4. Provide a test plan I can run before letting this touch real data.
5. Ask before any step that sends messages, modifies data, or spends money.

Source: https://usecasesforagents.com/use-case/daily-trello-task-tracker-with-google-sheets-history-log/ via usecasesforagents.com