## 1. Workflow Diagnosis The current workflow is slow because every customer message forces the owner to restart the same process manually: open Gmail, read the issue, search Shopify, decide the policy, reply, update Google Sheets, and remember whether a follow-up is needed. The biggest problem is not just “too many emails”; it is that there is no ticket system, no status labels, no decision rules, and no shared view of what is pending. The main bottlenecks are: **Owner is the bottleneck for everything.** The owner is currently doing triage, order checking, refund decisions, customer replies, follow-ups, and spreadsheet updates. The virtual assistant cannot help much because there is no clear decision framework. **Order checking is repeated manually.** Every refund or return request requires opening Shopify, searching by name/email/order number, checking order status, fulfillment status, shipping/tracking, product purchased, purchase date, and previous refund history. **Refund decisions are inconsistent.** Without rules, one customer may receive a refund quickly while another similar case waits or receives a different answer. This creates customer dissatisfaction and risk. **Follow-ups are memory-based.** If the owner forgets to check “waiting for customer photos,” “waiting for fulfillment update,” or “replacement shipped,” the case gets buried. **Repeated questions waste time.** Skincare stores usually receive repeated questions about ingredients, usage, shipping times, damaged products, wrong items, irritation, returns, and refund eligibility. Without templates, every reply is written from scratch. **No clear handoff between VA, owner, and fulfillment assistant.** The VA does not know which cases they can handle alone, which need owner approval, and which need the fulfillment assistant. **Quality risk is high.** Skincare products involve sensitive issues: allergic reactions, damaged products, opened products, hygiene concerns, ingredient questions, and possible complaints. AI or VA replies should not make medical claims or promise refunds outside policy. --- # 2. Improved Workflow The redesigned workflow should use Gmail as the communication inbox, Shopify as the order source of truth, Google Sheets as the support tracker, and Google Drive as the SOP/template library. ## New workflow overview Customer email comes into Gmail. The VA checks the inbox twice daily, labels the email, logs it in Google Sheets, checks Shopify, drafts a response, and either sends it if it is low-risk or sends it to the owner for approval if it involves refunds, exceptions, complaints, allergic reactions, or high-value orders. The fulfillment assistant only receives cases that require physical action such as replacement shipment, missing item check, wrong item correction, or return inspection. Every open case has a status, owner, next action, and follow-up date in Google Sheets. ## Step-by-step redesigned process ### Step 1: Customer email arrives in Gmail **Owner:** Gmail inbox **Input:** Customer message **Output:** Email receives one or more Gmail labels Create Gmail labels: * `Support / New` * `Support / Product Question` * `Support / Shipping Question` * `Support / Refund Request` * `Support / Return Request` * `Support / Damaged or Wrong Item` * `Support / Needs Shopify Check` * `Support / Waiting Customer` * `Support / Waiting Fulfillment` * `Support / Owner Approval` * `Support / Closed` * `Support / Escalated` The VA reviews new messages at fixed times, for example 10:00 and 16:00. Urgent messages can be checked more often only if necessary. --- ### Step 2: VA triages the email **Owner:** Virtual assistant **Input:** Customer email **Output:** Category, priority, and initial Sheet record The VA decides the request type: | Request Type | Example | Default Owner | | ----------------------- | ------------------------------ | -------------------------------------- | | Product question | “Is this safe for oily skin?” | VA | | Shipping question | “Where is my order?” | VA | | Damaged item | “The bottle leaked.” | VA + fulfillment | | Wrong/missing item | “I received the wrong cream.” | VA + fulfillment | | Refund request | “I want my money back.” | VA drafts, owner approves | | Return request | “Can I return this?” | VA drafts, owner approves if exception | | Skin reaction complaint | “This caused irritation.” | Owner approval | | Angry customer | Threatening review/chargeback | Owner approval | | VIP/high-value order | Large order or repeat customer | Owner approval | The VA then creates or updates a row in the Customer Support Tracker. --- ### Step 3: VA checks Shopify **Owner:** Virtual assistant **Input:** Customer email, order number, customer name, email address **Output:** Verified order details The VA checks: * Customer name * Customer email * Order number * Order date * Product purchased * Order value * Fulfillment status * Tracking status * Delivery date * Previous refund/replacement history * Discount code used * Notes on customer account * Whether the request is inside or outside the refund/return window The VA does not make final refund decisions unless the case matches a pre-approved rule. --- ### Step 4: VA applies decision rules **Owner:** VA for simple cases; owner for approval cases **Input:** Customer issue + Shopify order details **Output:** Reply path, refund path, replacement path, or escalation Recommended decision matrix: | Case | Required Evidence | Default Action | Approval Needed? | | ----------------------------------------- | ---------------------------------------------- | --------------------------------------------------------------- | -------------------------------- | | Product question before purchase | None | Send template answer | No | | Shipping delay, tracking active | Tracking link | Send shipping update | No | | Delivered but customer says not received | Tracking screenshot/check | Ask customer to check address/neighbors; escalate if unresolved | Yes if refund/replacement | | Damaged/leaked item | Photo of product/package | Offer replacement or partial refund based on policy | Yes | | Wrong item sent | Photo of received item | Send correct item/replacement | Owner approval recommended | | Missing item | Packing check + order details | Send missing item or refund missing item | Owner approval recommended | | Customer changed mind, unopened item | Order date + return eligibility | Send return instructions | Owner approval if outside policy | | Opened skincare item, no defect | Order date + policy | Usually not returnable unless owner exception | Yes | | Skin irritation/allergic reaction | Details + product used + batch/photo if needed | Apologize, advise stopping use, no medical claims, escalate | Yes | | Repeat refund requester | History check | Escalate | Yes | | Chargeback/legal threat/bad review threat | Message evidence | Escalate immediately | Yes | --- ### Step 5: VA drafts or sends response **Owner:** VA **Input:** Template + Shopify information + decision rule **Output:** Customer reply The VA may send directly only for low-risk cases: * Basic product questions * Basic shipping status * Asking for missing order number * Asking for photos * Return instructions already approved by policy * “We received your request” acknowledgment The VA must request owner approval before sending: * Any refund promise * Any replacement promise above a set threshold * Any exception to policy * Any health/skin reaction response * Any complaint involving anger, chargeback, public review, or legal threat * Any order above the owner-defined amount, for example $75 or $100 --- ### Step 6: Fulfillment handoff if physical action is needed **Owner:** VA initiates; fulfillment assistant executes **Input:** Replacement/missing/wrong item case **Output:** Replacement packed, shipped, tracking updated Handoff format to fulfillment assistant: **Action Needed:** Send replacement / check packing / confirm missing item / inspect return **Customer:** Name + order number **Product:** Product name and variant **Issue:** Short summary **Evidence:** Photo link or email note **Deadline:** Date/time **Customer Promise:** What the customer was told **Update Needed:** Tracking number, shipment confirmation, or issue result The fulfillment assistant updates the Sheet and notifies the VA when done. --- ### Step 7: Follow-up is scheduled **Owner:** VA **Input:** Case status **Output:** Follow-up date in Google Sheets Every open case must have a `Next Follow-Up Date`. Examples: | Situation | Follow-Up Timing | | --------------------------------- | -------------------------------- | | Waiting for customer photos | 2 business days | | Waiting for customer order number | 2 business days | | Replacement shipped | 3–5 business days after shipping | | Return instructions sent | 5 business days | | Waiting for fulfillment check | Same day or next business day | | Refund approved but not processed | Next business day | | Angry customer escalated | Same day | --- ### Step 8: Case is closed **Owner:** VA, with owner approval where needed **Input:** Final reply sent and action completed **Output:** Gmail labeled closed, Sheet marked closed A case can be closed only when: * Customer received a final answer, or * Refund/replacement/return action is complete, or * Customer did not respond after two follow-ups, or * Owner manually marks the case closed The VA applies Gmail label `Support / Closed` and updates the Sheet. --- # 3. Standard Operating Procedure ## SOP Name Customer Support, Refund, and Return Handling SOP ## Purpose To make customer replies faster, refund decisions more consistent, follow-ups more reliable, and customer support easier to delegate to the virtual assistant while keeping sensitive decisions under owner approval. ## Required Tools * Gmail * Shopify * Google Sheets * Google Drive * Customer support templates * Refund/return policy document * Product FAQ document * Customer Support Tracker Sheet ## Required Inputs Every support case should collect: * Customer name * Customer email * Order number * Product name * Order date * Request type * Issue description * Photos or proof, if relevant * Delivery/tracking status * Refund/return eligibility * Previous support/refund history * Desired customer outcome ## Google Sheet: Customer Support Tracker Columns Create a Google Sheet with these columns: | Column | Purpose | | ------------------- | ---------------------------------------------------------------------------------------------- | | Ticket ID | Simple ID such as CS-0001 | | Date Received | When email arrived | | Customer Name | From email or Shopify | | Customer Email | Customer contact | | Order Number | Shopify order number | | Product | Product involved | | Request Type | Product question, refund, return, shipping, damaged, wrong item | | Priority | Low, Normal, High, Urgent | | Status | New, In Review, Waiting Customer, Waiting Fulfillment, Owner Approval, Action Complete, Closed | | Gmail Link | Link to email thread if possible | | Shopify Order Link | Link to Shopify order | | Issue Summary | One-sentence summary | | Evidence Received | Yes/No | | Decision | Reply, refund, replacement, return, escalate | | Approval Needed | Yes/No | | Approved By | Owner name/date | | Next Action | What must happen next | | Next Follow-Up Date | Date VA must check | | Final Resolution | Closed outcome | | Notes | Internal notes | Use dropdowns for `Request Type`, `Priority`, `Status`, `Decision`, and `Approval Needed`. Use conditional formatting: * Red if `Next Follow-Up Date` is past due and status is not closed * Yellow if status is `Owner Approval` * Blue if status is `Waiting Customer` * Purple if status is `Waiting Fulfillment` * Green if status is `Closed` --- ## SOP Steps ### Step 1: Open Gmail support inbox The VA checks Gmail at the scheduled support times. Start with unread emails and any emails labeled `Support / New`. ### Step 2: Identify the request type Read the customer message and assign one main category: * Product question * Shipping question * Refund request * Return request * Damaged item * Wrong item * Missing item * Skin reaction * Complaint/escalation Apply the correct Gmail label. ### Step 3: Check whether this is an existing case Search the Customer Support Tracker by customer email, name, or order number. If a case already exists, update the existing row. Do not create duplicate tickets. ### Step 4: Create or update the Sheet row Enter the customer details, request type, issue summary, priority, next action, and follow-up date. ### Step 5: Check Shopify Search Shopify by order number, email, or customer name. Verify the order details before replying. Never tell a customer that a refund, return, or replacement is approved before checking Shopify. ### Step 6: Apply the decision matrix Use the refund/return decision rules. If the case is low-risk and does not require approval, the VA may send the correct template. If approval is required, the VA drafts the reply and marks the Sheet as `Owner Approval`. ### Step 7: Draft the customer response Use the approved templates. Personalize only the customer name, order/product details, tracking details, deadline, and next action. Do not add medical claims, legal promises, or refund promises unless approved. ### Step 8: Owner approval The owner reviews cases marked `Owner Approval`. The owner must approve: * Refunds * Return exceptions * Replacement promises * Skin reaction complaints * Angry customers * High-value orders * Repeat refund customers * Any case outside the standard policy The owner records the decision in the Sheet. ### Step 9: Send reply The VA sends the final reply after approval if required. Update the Sheet status: * `Waiting Customer` if customer must send photos/details * `Waiting Fulfillment` if fulfillment assistant must act * `Action Complete` if refund/replacement was processed * `Closed` if no further action is needed ### Step 10: Follow up Every open case must have a follow-up date. The VA checks overdue follow-ups daily. ### Step 11: Close case Close the case only after the final action is complete and the final customer message has been sent. Apply Gmail label `Support / Closed`. --- ## Quality Standards Every support reply must be: * Sent using the correct customer name * Matched to the correct order number * Based on verified Shopify information * Clear about the next step * Polite but not over-promising * Free from medical claims * Free from unapproved refund promises * Logged in the Google Sheet * Assigned a follow-up date if not closed ## Escalation Rules Escalate to the owner immediately when: * Customer asks for refund * Customer reports irritation, allergy, burning, rash, or reaction * Customer threatens chargeback or bad review * Customer is angry or abusive * Order value is high * Customer has previous refunds * Product may have quality or safety issue * Case is outside normal policy * VA is unsure ## Completion Criteria A case is complete when: * Correct reply has been sent * Any approved refund/replacement/return is processed * Fulfillment action is confirmed if needed * Follow-up is no longer required * Sheet is updated * Gmail is labeled closed --- # 4. AI And Automation Opportunities ## Quick Wins **Gmail labels and filters.** Create labels for refund, return, shipping, damaged item, and owner approval. Use Gmail filters for common keywords such as “refund,” “return,” “damaged,” “leaking,” “wrong item,” “missing,” “where is my order,” and “allergic.” **Gmail templates.** Save approved replies as Gmail templates. This alone can reduce reply time dramatically. **Google Sheet dropdowns.** Use dropdown status labels so the VA does not type inconsistent statuses. **Conditional formatting for overdue follow-ups.** Highlight overdue follow-ups automatically. **Google Drive SOP folder.** Store all templates, refund rules, product FAQ, and escalation rules in one folder. **AI-assisted email summary.** The VA can paste a customer email into AI and ask for a short summary, but the VA must verify details manually. Recommended AI prompt: > Summarize this customer support email in one sentence. Identify the request type, urgency, missing information, and whether owner approval may be needed. Do not make a refund decision. Do not include medical advice. --- ## Medium-Effort Improvements **Support tracker dashboard.** Add a second tab in Google Sheets that counts open cases by status, overdue follow-ups, refund requests, and average response time. **Template library with decision rules.** Create a Google Doc for each common scenario: shipping delay, damaged item, wrong item, missing item, return request, refund request, skin reaction, and follow-up. **Daily support review routine.** VA checks the inbox twice daily, owner checks approval queue once daily, fulfillment assistant checks action queue once daily. **Pre-filled response drafts.** VA uses AI to draft replies based on approved templates. The VA must edit and verify before sending. AI drafting prompt: > Draft a customer support reply using the approved policy below. Keep the tone warm, clear, and professional. Do not promise a refund, return, or replacement unless the policy clearly allows it. Do not make medical claims. Include the next step and expected timeline. **Standard Shopify check routine.** Instead of the owner checking everything, the VA completes the Shopify verification checklist and only sends the owner a short approval summary. Owner approval summary format: > Customer: > Order: > Product: > Issue: > Evidence received: > Shopify status: > Policy rule: > VA recommendation: > Approval needed: refund / replacement / return / exception --- ## Advanced Improvements **No-code Gmail-to-Sheet automation.** If the budget later allows, use a no-code automation tool to create a Sheet row when a Gmail message receives the `Support / New` label. This should not auto-reply to customers. **Shopify support app.** Later, the store may consider a low-cost helpdesk or Shopify-compatible support tool. But for now, the Gmail + Sheets system is enough. **Customer self-service FAQ.** Build a Google Doc or simple FAQ page with approved answers about shipping, returns, product use, and damaged items. This reduces repeated questions. **AI knowledge base.** Create an internal FAQ document that the VA can use with AI to draft answers. The AI should only answer from approved internal information. ## What Must Stay Under Human Review Human approval should remain required for: * Refund approvals * Return exceptions * Replacement approvals above a threshold * Skin reaction or health-related complaints * Legal threats * Chargebacks * Angry customers * Public review threats * Repeat refund customers * Policy exceptions * High-value orders --- # 5. Roles And Handoff Rules ## Owner The owner owns the overall workflow and approves sensitive decisions. Responsibilities: * Create and maintain refund/return policy * Approve refunds, exceptions, and escalations * Review quality weekly * Update templates * Decide final outcome for difficult cases * Monitor KPIs ## Virtual Assistant The VA executes the daily support process. Responsibilities: * Check Gmail support inbox * Label emails * Log cases in Google Sheets * Check Shopify order details * Draft replies * Send approved low-risk replies * Ask customers for missing information * Track follow-ups * Escalate cases to owner * Close completed cases ## Fulfillment Assistant The fulfillment assistant handles physical order actions. Responsibilities: * Check packing or fulfillment errors * Confirm damaged/wrong/missing item cases * Prepare replacements * Provide tracking updates * Confirm return receipt if relevant * Update the VA when action is complete ## Handoff Rules A handoff is valid only if it includes: * Customer name * Order number * Product name * Issue summary * Required action * Deadline * Evidence link if available * Customer promise already made * Person responsible * Next update required No task should be handed off verbally only. Every handoff must be recorded in Google Sheets. --- # 6. Checklists And Templates ## Customer Email Intake Checklist Before replying, the VA checks: * Customer name identified * Customer email matches Shopify order * Order number found * Product identified * Request type selected * Issue summarized in one sentence * Shopify order checked * Evidence requested or received * Policy rule checked * Approval requirement checked * Follow-up date added * Correct template selected --- ## Shopify Order Check Checklist Check: * Order number * Customer email * Order date * Product and variant * Quantity * Payment status * Fulfillment status * Tracking number * Delivery status * Discount used * Previous customer notes * Previous refunds/replacements * Shipping address issue * Whether request is inside policy window --- ## Refund Approval Checklist Owner approves only after checking: * Is the order real and paid? * Is the request inside the policy window? * Is the product unopened, damaged, wrong, missing, or defective? * Has the customer provided photos if needed? * Is this customer a repeat refund requester? * Is this a product quality issue that needs tracking? * Is a replacement better than a refund? * Is a partial refund appropriate? * Has the VA drafted the reply correctly? * Is the promise clear and not excessive? --- ## Status Labels Use these in Google Sheets: | Status | Meaning | | ------------------- | ------------------------------------------ | | New | Email received, not processed | | In Review | VA is checking details | | Waiting Customer | Customer must provide information | | Waiting Fulfillment | Fulfillment assistant must act | | Owner Approval | Owner must approve before reply/action | | Action Complete | Refund/replacement/return action completed | | Closed | No further action needed | | Escalated | Sensitive or high-risk case | --- ## Priority Labels | Priority | Definition | | -------- | ----------------------------------------------------------------------------- | | Low | General product question, no order issue | | Normal | Standard shipping or return question | | High | Refund, damaged product, wrong item, missing item | | Urgent | Skin reaction, angry customer, chargeback, legal threat, public review threat | --- ## Customer Message Templates ### Acknowledgment Template Subject: Re: Your Order Request Hi [Customer Name], Thank you for reaching out. I’m sorry for the trouble, and I’ll help look into this for you. To check this properly, could you please send your order number or the email address used at checkout? Once I have that, I’ll review the order details and get back to you with the next step. Thank you, [Name] --- ### Shipping Update Template Hi [Customer Name], Thanks for your message. I checked your order [Order Number], and the current shipping status is: [Tracking Status] You can track it here: [Tracking Link] If the tracking does not update within [X business days], please reply to this email and we’ll check it again for you. Thank you, [Name] --- ### Damaged Item Photo Request Template Hi [Customer Name], I’m sorry your item arrived this way. We’ll help review this for you. Could you please send: 1. A photo of the damaged product 2. A photo of the outer package 3. A photo of the shipping label if possible Once we receive the photos, we’ll review the issue and confirm the next step. Thank you, [Name] --- ### Wrong Item Template Hi [Customer Name], I’m sorry for the mix-up with your order. Could you please send a photo of the item you received, including the product label if possible? We’ll compare it with your order [Order Number] and confirm the next step. Thank you for your patience, [Name] --- ### Missing Item Template Hi [Customer Name], I’m sorry an item may be missing from your order. I’ll check the order details and packing information for order [Order Number]. Could you please confirm which item was missing from the package? Once confirmed, we’ll update you with the next step. Thank you, [Name] --- ### Return Request Template Hi [Customer Name], Thank you for contacting us. I checked your order [Order Number]. To review the return request, could you please confirm whether the product is unopened and unused? Once we have that information, we’ll confirm whether the item is eligible under our return policy and send the next steps. Thank you, [Name] --- ### Refund Request Received Template Hi [Customer Name], Thank you for reaching out. I’m sorry to hear there was an issue with your order. I’ve received your refund request for order [Order Number]. We’re reviewing the order details and will confirm the next step after checking the policy and order status. Thank you for your patience, [Name] --- ### Skin Reaction Escalation Template Hi [Customer Name], I’m very sorry to hear about your experience. Please stop using the product for now. We’ll review this carefully and escalate it to the owner for further handling. Could you please send your order number, the product name, when you started using it, and any relevant photos of the product or packaging? Thank you, [Name] Important internal note: Do not diagnose, give medical advice, or claim the product caused or did not cause the reaction. --- ### Follow-Up Template Hi [Customer Name], I’m following up on your previous message about [Issue]. We’re still happy to help. Could you please send [missing information/photos/order number] so we can continue reviewing this for you? Thank you, [Name] --- ### Case Closing Template Hi [Customer Name], I’m glad we were able to help with this. We’ll close this support request for now, but you can reply to this email if you need anything else about the same order. Thank you, [Name] --- ## Quality-Control Prompt For VA Before sending a reply, the VA should check: > Did I use the correct customer name, order number, and product? > Did I verify the order in Shopify? > Did I avoid promising refunds or replacements without approval? > Did I avoid medical claims? > Did I clearly tell the customer the next step? > Did I update the Sheet status and follow-up date? --- # 7. KPI Dashboard Create a second tab in Google Sheets called `Dashboard`. Track these metrics weekly: ## Speed Metrics | KPI | Target | | ----------------------------------- | -------------------------------------- | | First response time | Under 24 business hours | | Average resolution time | Under 3 business days for normal cases | | Refund decision time | Under 2 business days | | Owner approval waiting time | Under 24 business hours | | Fulfillment handoff completion time | Same day or next business day | ## Quality Metrics | KPI | Target | | ----------------------------------- | ------------------ | | % cases with complete Shopify check | 100% | | % open cases with follow-up date | 100% | | % cases reopened | Under 10% | | Wrong refund/replacement decisions | 0 | | Customer complaints after reply | Decreasing monthly | ## Follow-Up Metrics | KPI | Target | | ---------------------------------------------------- | --------------- | | Overdue follow-ups | 0–2 max | | Waiting customer cases older than 5 business days | Reviewed weekly | | Waiting fulfillment cases older than 2 business days | Escalated | ## Workload Metrics | KPI | Purpose | | --------------------------------- | ---------------------------------------- | | Emails received per day | Understand volume | | Cases by type | See repeated problems | | Refund requests per week | Monitor refund pressure | | Damaged/wrong/missing item rate | Identify fulfillment or packaging issues | | VA-handled vs owner-handled cases | Measure delegation | ## Customer Satisfaction Metrics Simple low-budget method: add a manual `Customer Sentiment` column in the Sheet. Options: * Positive * Neutral * Negative * Angry * Resolved happily The VA can mark this after the final customer reply. --- # 8. Risk Control | Risk | What Can Go Wrong | Safeguard | | --------------------------- | -------------------------------------------- | --------------------------------------------------------------------- | | Wrong refund approval | VA refunds outside policy | Owner approval required for all refunds | | AI gives wrong answer | AI invents policy or makes medical claim | AI drafts only; human reviews before sending | | Missed follow-up | Customer waits too long | Sheet follow-up date + daily overdue check | | Duplicate tickets | Same customer emails twice | Search Sheet before creating new row | | Privacy issue | Customer data copied into unsafe tools | Do not paste full addresses, payment details, or private data into AI | | Inconsistent replies | VA writes from scratch | Use approved Gmail templates | | Unclear ownership | Everyone assumes someone else is handling it | Every row must have owner + next action | | Fulfillment mistake | Replacement sent incorrectly | Handoff checklist required | | Health complaint mishandled | Store gives unsafe advice | Escalate skin reactions to owner; no medical claims | | Angry customer worsens | Delayed or robotic reply | Urgent label + same-day owner review | | Spreadsheet not updated | Gmail and Sheet disagree | Case cannot close until Sheet and Gmail both updated | | Over-automation | Customer receives wrong auto-reply | Do not auto-send refund/return replies | --- # 9. 30-Day Rollout Plan ## Week 1: Build the foundation Create the Google Drive folder structure: * `Customer Support SOP` * `Refund & Return Policy` * `Gmail Templates` * `Product FAQ` * `Escalation Rules` * `Weekly KPI Reports` Create Gmail labels. Build the Customer Support Tracker in Google Sheets. Add dropdowns and conditional formatting. Write the first version of refund/return rules. Create the basic response templates. By the end of Week 1, the VA should be able to log cases, label emails, check Shopify, and know when to escalate. --- ## Week 2: Test the manual workflow Run all support emails through the new system manually. The VA handles: * Triage * Sheet logging * Shopify checks * Basic replies * Follow-up tracking The owner handles: * Refund approvals * Return exceptions * Sensitive complaints * Quality review At the end of the week, review 10–20 completed cases and check: * Was the status correct? * Was the follow-up date used? * Were any replies unclear? * Did any cases get stuck? * Did the VA escalate correctly? Update the SOP based on real cases. --- ## Week 3: Add simple automation and AI support Set up Gmail filters for common keywords. Add Gmail templates. Add more conditional formatting in Sheets. Create AI prompts for summarizing customer emails and drafting replies from approved templates. Do not auto-send AI replies. Create a daily routine: * VA checks new emails twice daily * VA checks overdue follow-ups once daily * Owner checks approval queue once daily * Fulfillment assistant checks action queue once daily By the end of Week 3, the system should reduce owner involvement in basic cases. --- ## Week 4: Improve and measure Start tracking KPIs weekly. Review: * First response time * Open cases * Overdue follow-ups * Refund requests * Common support questions * Fulfillment error patterns * VA escalation accuracy Update templates for the most repeated issues. Add new FAQ answers. Tighten refund rules if too many cases require owner approval. Remove unclear steps from the SOP. By the end of Week 4, the workflow should be stable enough for the VA to run most daily support with owner approval only for sensitive decisions. --- # 10. Executive Summary The new operating system changes customer support from owner-dependent manual work into a simple, trackable support workflow using the tools the store already has: Gmail, Shopify, Google Sheets, and Google Drive. Gmail becomes the customer communication center. Shopify remains the source of truth for orders. Google Sheets becomes the control board for status, ownership, follow-ups, approvals, and KPI tracking. Google Drive stores the SOP, templates, refund rules, and product FAQ. The virtual assistant becomes responsible for daily triage, order checking, customer replies, follow-ups, and tracker updates. The owner only approves sensitive decisions such as refunds, exceptions, skin reaction complaints, angry customers, and high-value cases. The fulfillment assistant only receives clear handoffs for physical actions like replacements, missing items, wrong items, and returns. This system should produce faster replies, fewer missed follow-ups, more consistent refund decisions, less owner workload, and better customer experience without requiring expensive software or custom coding.