You are helping me build the following AI agent workflow. ## Goal Log E-commerce Orders In Google Sheets: Receives e-commerce orders via webhook and appends them to a monthly tab in Google Sheets with status tracking. ## Specification - What it does: You automatically receive e-commerce orders directly into a dedicated monthly tab in your Google Sheets with built-in status tracking. This workflow captures incoming order data via webhook and appends the details to the correct sheet without manual entry. You can then monitor fulfillment progress across different months using the integrated status updates. - Trigger: Triggered by an event (Event ยท on new order webhook) - Autonomy: Fully hands-off - Expected setup effort: about an afternoon - Tools/services involved: - n8n: Workflow orchestration platform - Google Sheets: Storing and tracking order data in monthly tabs - HTTP Request: Receiving Shopify webhook payloads ## Known pitfalls, handle each one explicitly in your implementation 1. Dynamic sheet creation can fail silently if permissions are incorrect so verify the service account has edit access to the root spreadsheet before deploying. 2. Large datasets can slow down sheet operations so archive old monthly tabs or move them to Google Drive folders periodically to maintain performance. ## Reference implementation https://n8n.io/workflows/8244 (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/log-e-commerce-orders-in-google-sheets/ via usecasesforagents.com