You are helping me build the following AI agent workflow. ## Goal Track Pipedrive Deals in Google Sheets: Pulls active deals from Pipedrive, maps stage IDs to readable labels. ## Specification - What it does: You get your active Pipedrive deals automatically listed in Google Sheets with readable stage names instead of confusing IDs. This keeps your sales pipeline visible and up to date without manual data entry. - Trigger: Run manually (Manual ยท on demand) - Autonomy: Fully hands-off - Expected setup effort: about an afternoon - Tools/services involved: - Pipedrive: Fetch deals and stage IDs - Google Sheets: Log deal data for reporting - Code: Map stage IDs to names and format columns ## Known pitfalls, handle each one explicitly in your implementation 1. Stage IDs may change if your Pipedrive admin updates pipeline settings so store the mapping dynamically or check for ID mismatches before appending. 2. Missing stage_id fields can cause crashes so add a default fallback label like 'Unknown Stage' for any deals lacking this data. ## Reference implementation https://n8n.io/workflows/7740 (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/track-pipedrive-deals-in-google-sheets/ via usecasesforagents.com