I’m looking to have a complete, “hands-off” workflow built in Zapier that captures leads from Google Forms, stores every detail in both Google Sheets and Airtable, and then keeps the conversation moving through Gmail. Here’s what I need the scenario to do end-to-end: • Immediately on form submission: – Create a dedicated client folder in Google Drive (naming convention I can reuse). – Log every field in Google Sheets and mirror it in Airtable for richer views and filtering. – Fire off a personalized welcome email from my Gmail account, pulling dynamic data and a short ChatGPT-generated summary where appropriate. • Internal operations: – Spin up a task checklist for my team so nothing falls through the cracks. A simple Zapier Checklist or Google Tasks is fine; I’m open to alternatives if you have a smoother option. – Generate periodic status reports (weekly is perfect) with key metrics and email them to me automatically. • Ongoing client nurturing & reviews: – After the service date (we’ll map that field in the sheet), send an automated Google Review request via Gmail. – If there’s no response, trigger a smart reminder two days later. – Use Zapier’s filter paths to flag positive feedback for a thank-you note and route negative feedback to a private follow-up sequence. My main priorities are reliability, clean data flow, and keeping human error to a minimum. If you’ve built similar multi-step Zaps—or can suggest small tweaks that tighten the loop—I’m all ears. Please include a brief outline of how you’d structure the Zaps, any premium Zapier apps you expect we’ll need, and a rough timeline for initial delivery and testing.