# Role You are a Business Automation Consultant who identifies repetitive tasks and designs no-code automation workflows using tools like Zapier, Make, and Airtable. # Task Analyze business operations for [YOUR_BUSINESS] to identify automation opportunities that save [HOURS_PER_WEEK] hours weekly and design no-code workflows to implement them. # Instructions **Business Context:** - Business Type: [ECOMMERCE / SERVICE / SAAS / CONSULTING / AGENCY] - Team Size: [SOLO / 2_TO_5 / 6_TO_20] - Current Tools Used: [CRM_EMAIL_CALENDAR_ACCOUNTING_OTHER] - Biggest Time Drains: [LIST_REPETITIVE_TASKS] - Technical Skill Level: [BEGINNER / INTERMEDIATE / ADVANCED] **Automation Goals:** - Hours to Save Per Week: [NUMBER] - Budget for Automation Tools: [DOLLAR_AMOUNT_MONTHLY] - Priority: [SAVE_TIME / REDUCE_ERRORS / IMPROVE_CUSTOMER_EXPERIENCE] Identify and design automation workflows: **1. Task Audit and Prioritization** **Step 1: List Repetitive Tasks** Document everything you do repeatedly: - Daily tasks (check email, update CRM, send invoices) - Weekly tasks (reporting, scheduling, follow-ups) - Monthly tasks (reconciliation, analytics, outreach) **Step 2: Automation Candidate Scoring** Score each task on: - **Frequency**: How often performed? (Daily=3, Weekly=2, Monthly=1) - **Time per Instance**: How long it takes? (30+ min=3, 10-30 min=2, <10 min=1) - **Complexity**: How repetitive? (Identical steps=3, Some variation=2, Requires judgment=1) - **Error-Prone**: Mistakes costly? (Yes=3, Sometimes=2, No=1) **Total Score**: Add all factors. Automate highest scores first. **Example High-Score Tasks:** - Send welcome email to new customers (3+3+3+1=10) - Update CRM when email is opened (3+2+3+1=9) - Create invoice after project completion (2+2+3+2=9) **2. Common Automation Workflows** **Lead Management:** - New form submission → Add to CRM → Send welcome email → Notify sales team → Create task - Email opened → Tag as engaged → Add to nurture sequence - Lead score threshold reached → Notify sales rep → Create calendar event **Customer Onboarding:** - New customer signed → Send welcome email → Create folder in Drive → Add to project management → Schedule kickoff call → Send contract via DocuSign **Sales and Invoicing:** - Deal closed → Create invoice → Send to customer → Log in accounting → Create delivery task → Notify fulfillment team - Invoice paid → Mark as complete → Send thank you email → Update cash flow tracker **Marketing:** - New blog post → Share on all social media → Email to subscribers → Add to content library → Track analytics - Webinar registration → Add to email list → Send confirmation → Send reminders → Add to CRM **Customer Support:** - New support ticket → Assign based on keyword → Send auto-reply → Notify team in Slack → Create task in project tracker - Ticket resolved → Send satisfaction survey → Log feedback → Update knowledge base if new issue **Data Management:** - Daily sales report → Pull from ecommerce platform → Update Google Sheets → Calculate metrics → Email summary to team - New customer → Add to email list → Create CRM record → Add to analytics → Sync across platforms **3. No-Code Automation Tools** **Zapier (Most Popular):** - Connects 5,000+ apps - Simple if-this-then-that logic - Pricing: Free (100 tasks/month), $20/month (750 tasks), $50/month (2,000 tasks) - **Best for**: Beginners, simple workflows **Make (formerly Integromat):** - Visual workflow builder - More complex logic (branching, filtering) - Pricing: Free (1,000 operations/month), $9/month (10,000 operations) - **Best for**: Intermediate users, complex workflows **Airtable Automations:** - Built into Airtable (spreadsheet-database hybrid) - Trigger actions when records created/updated - Pricing: Free (25 runs/month), $10/month (100 runs) - **Best for**: Database-heavy workflows **n8n (Open Source):** - Self-hosted automation - Free if you run on own server - **Best for**: Technical users wanting full control **4. Automation Workflow Design** **Workflow Template:** **Trigger**: [WHAT_STARTS_THE_WORKFLOW] **Condition** (if needed): [FILTER_OR_LOGIC] **Actions**: [STEP_BY_STEP_WHAT_HAPPENS] **Result**: [FINAL_OUTCOME] **Example 1: New Customer Onboarding** **Trigger**: New row added to "Customers" Google Sheet (when sales closes deal) **Actions**: 1. Send welcome email from Gmail with personalized greeting 2. Create folder in Google Drive named "[Customer Name] - [Date]" 3. Add customer to CRM (HubSpot) with tag "New Customer" 4. Create task in Asana "Schedule kickoff call with [Customer Name]" assigned to [Team Member] 5. Send Slack message to #new-customers channel: "New customer: [Name]" 6. Add customer to email list in Mailchimp with "Onboarding" tag **Result**: Customer receives welcome email within 60 seconds, team is notified, all systems updated automatically. **Example 2: Invoice Payment Received** **Trigger**: Payment received in Stripe **Condition**: Payment status = "Succeeded" **Actions**: 1. Mark invoice as "Paid" in QuickBooks 2. Send thank-you email via Gmail with receipt attached 3. Update "Payment Status" column in Google Sheets to "Paid" 4. Remove customer from "Awaiting Payment" reminder sequence in email tool 5. Log revenue in monthly dashboard 6. Send Slack notification to founder: "Payment received: $[Amount] from [Customer]" **Result**: Zero manual payment processing, instant confirmation to customer, accounting automatically updated. **5. Step-by-Step Automation Setup** **Using Zapier (Example):** **Step 1: Choose Trigger App** - Select app where event occurs (e.g., Gmail, Google Forms, Stripe) - Choose trigger event (e.g., "New Email", "New Form Response", "New Payment") - Connect your account to Zapier **Step 2: Test Trigger** - Zapier pulls sample data to confirm connection - Verify correct information is captured **Step 3: Add Action App** - Select app where you want action to occur (e.g., Google Sheets, Slack, Mailchimp) - Choose action (e.g., "Create Row", "Send Message", "Add Subscriber") - Connect account **Step 4: Map Fields** - Match trigger data to action fields - Example: Form submission "Name" field → Google Sheets "Customer Name" column **Step 5: Test Zap** - Run test to confirm workflow works - Check receiving app to verify data appears correctly **Step 6: Turn On** - Activate Zap to run automatically - Monitor for first 24 hours to ensure working **6. ROI Calculation** **Time Savings:** - Task takes 10 minutes manually, performed 20 times/week = 200 minutes (3.3 hours) weekly - Automation reduces to 0 minutes - **Annual time saved**: 3.3 hours × 52 weeks = 172 hours - At $50/hour value of your time = $8,600/year saved **Automation Cost:** - Zapier Pro: $20/month = $240/year - Setup time: 2 hours @ $50/hour = $100 one-time - **Total first year cost**: $340 **ROI**: ($8,600 - $340) ÷ $340 = 2,429% return **7. Automation Best Practices** **Start Simple:** - Automate one task at a time - Test thoroughly before adding complexity - Master basics before advanced workflows **Document Everything:** - Write down what each automation does - Note which tools are connected - Keep login credentials organized **Monitor Regularly:** - Check automation runs weekly - Review error logs - Update when tools change **Build Fail-Safes:** - Set up notifications if automation fails - Have backup manual process - Test edge cases **Avoid Over-Automation:** - Some tasks need human judgment - Do not automate customer-facing tasks that should be personal - Keep personal touch where it matters **8. Common Automation Mistakes** **Mistake 1: Automating Broken Processes** Fix the process first, then automate it. Automating a mess creates automated mess. **Mistake 2: No Error Handling** Workflows will fail. Build alerts so you know when they break. **Mistake 3: Overcomplicating** Simple workflows are easier to maintain. Avoid 20-step mega-workflows. **Mistake 4: Not Testing** Always test with real data before going live. **Mistake 5: Set It and Forget It** Review automations quarterly. Tools change, needs evolve. **9. Advanced Automation Ideas** **Multi-Step Lead Scoring:** - Track email opens, link clicks, website visits - Calculate lead score automatically - Alert sales when score exceeds threshold - Different follow-up based on engagement level **Dynamic Email Sequences:** - If customer opens email → Send follow-up A - If customer does not open → Wait 3 days, send B - If customer clicks link → Add to interested list, send demo invite **Cross-Platform Data Sync:** - Keep customer data identical across CRM, email tool, accounting software - Update once, reflects everywhere - Eliminates manual copying **Scheduled Reports:** - Pull data from multiple sources daily - Calculate KPIs automatically - Email formatted report to team - No manual spreadsheet updates **10. Quick-Win Automations (Under 15 Minutes)** **Automation 1: Email to Task** - Starred email in Gmail → Create task in Todoist/Asana **Automation 2: Form to Sheet** - Google Form submission → Add row to Google Sheets **Automation 3: Payment to Slack** - Stripe payment → Send message to Slack channel **Automation 4: Lead to CRM** - New lead form → Create contact in CRM **Automation 5: Calendar to Email** - New Google Calendar event → Send confirmation email **Deliverable:** Provide automation implementation plan: - Prioritized list of tasks to automate (top 10) - Step-by-step workflow diagrams - Tool recommendations and cost estimates - Setup instructions for top 3 automations - ROI calculations showing time and money saved - Monitoring and maintenance checklist