Claude Prompt for n8n Workflows
Create an automated Slack-to-Google Sheets integration pipeline for publishing using Zapier.
More prompts for n8n Workflows.
Build an n8n workflow that automatically backs up critical business data from multiple SaaS tools to cloud storage on a scheduled basis.
Build an n8n workflow that receives invoices via email, extracts key data using AI, validates amounts, and logs them to your accounting system.
Build a multi-step Make (Integromat) workflow that automates employee offboarding and access revocation for a virtual-reality company.
Build a multi-step Power Automate workflow that automates invoice generation and payment tracking for a space-tech company.
Build a multi-step Make (Integromat) workflow that automates social media content scheduling and analytics collection for a consulting company.
Design a Lead Scoring automation blueprint on Make (Integromat) tailored for Gen Z professionals in telemedicine.
You are a seasoned integration architect specializing in API integrations. Your work has helped hundreds of developers achieve measurable results. Build a production-ready integration between Slack and Google Sheets for a publishing business using Zapier. **Target user:** CMOs **Automation goal:** launch a new product ## Integration Architecture - Source system: Slack (data origin) - Destination system: Google Sheets (data target) - Data flow direction and frequency - Middleware layer: Zapier orchestration - Estimated data volume per run ## Authentication Setup - Slack authentication method and required scopes/permissions - Google Sheets authentication method and required scopes/permissions - Credential storage best practices in Zapier - Token refresh handling for OAuth2 connections ## Trigger Configuration - Exact trigger event in Slack (new record, updated field, webhook, schedule) - Polling interval or webhook setup instructions - Filter conditions to avoid processing irrelevant events - Deduplication strategy to prevent duplicate processing ## Data Mapping and Transformation - Source field to destination field mapping table - Data type conversions required (dates, currencies, IDs) - Lookup operations for reference data enrichment - Default values for missing or null fields - Custom expressions or formulas for calculated fields ## Workflow Steps 1. Trigger: Receive event from Slack 2. Validate: Check required fields are present 3. Enrich: Look up additional data if needed 4. Transform: Map and convert fields to Google Sheets format 5. Execute: Create/update record in Google Sheets 6. Confirm: Verify the operation succeeded 7. Log: Record the transaction for audit trail ## Error Scenarios and Recovery - Slack API downtime handling - Google Sheets rate limit mitigation - Partial failure recovery (some records succeed, others fail) - Dead letter queue for permanently failed records - Manual retry procedure for operations staff ## Monitoring Dashboard - Key metrics to display: success rate, latency, volume - Alert thresholds for anomalies - Weekly summary report template Structure as a playbook with: Overview, Prerequisites, Step-by-step Plays, Metrics to Track, and Troubleshooting Guide.