PIHU 1.7 — START FROM SCRATCH NKB Works · about 15 minutes · works from a mobile PART 1 — PUT PIHU ONLINE (Netlify) 1. Open your aipihu project on Netlify, Deploys 2. Upload aipihu-website.zip (drop it, or tap to choose the file). If it won't take the zip, unzip it and upload the folder. 3. Open https://aipihu.netlify.app/app/ on your phone in Chrome. 4. Tap Install (or Chrome menu ⋮ > Add to Home screen). Pihu is now an app on your phone. PART 2 — CREATE YOUR GOOGLE SHEET (one sheet for everything) Tip: in Chrome tap menu ⋮ and tick "Desktop site" for these steps. 1. Open https://sheets.new and name the sheet "Pihu". 2. Menu: Extensions > Apps Script. 3. Delete everything in the editor. Paste ALL of Code.gs. Tap Save. 4. At the top, choose the function setupFresh and tap Run. Google asks for permission: Review permissions > your account > Advanced > Go to project > Allow. Your sheet now has empty tabs: Config, Tasks, Bills, Payments, Orders, Stock, Deliveries, FollowUps, Log. 5. Project Settings (gear icon) > Script Properties > Add property: PIHU_TOKEN = a secret code you choose, e.g. pihu-sachin-2026 6. Deploy > New deployment > gear > Web app Execute as: Me Who has access: Anyone Deploy > copy the Web app URL (it ends with /exec). PART 3 — CONNECT PIHU TO THE SHEET 1. Open Pihu. Tap "Connect your Google Sheet". 2. Paste the /exec link and your PIHU_TOKEN code. Tap Connect. 3. You should see: "Connected. Live data." That's it. Bills and payments use the same sheet automatically. PART 4 — ADD YOUR DATA (in the sheet, keep the header row) Config: BusinessName = your business name. Bills (your own payments): Name, Amount, Frequency (Monthly / Quarterly / Yearly / Once), NextDue (date), PayTo (UPI ID only for people/shops that take UPI), Keyword (word that appears in the bank alert email, e.g. LIC). Orders: ID, Customer, Issue, Status (Blocked / Pending / Change / Short / OK), Amount. Stock: Item, Qty, Unit, ReorderLevel, Supplier, SupplierPhone (like 919800000000). Deliveries: Ref, Detail, Status (Delayed / Failed / OK). FollowUps: Name, Detail, Status (Overdue / Today / Soon). Tasks and Payments fill themselves when you use Pihu. Every approval is written in Log. Never type card numbers, account numbers or PINs anywhere. PART 5 — GIVE PIHU A BRAIN (optional, recommended) Without this, Pihu uses built-in answers (briefing, bills, tasks, reorders, priorities). For any question in any language: 1. Get a free key at https://aistudio.google.com/apikey (Google Gemini). 2. Apps Script > Project Settings > Script Properties > add: AI_PROVIDER = gemini AI_KEY = your key 3. In Pihu: Settings > AI brain > "Through my Google Sheet" > Save and test. Your key stays inside Google, never on the phone. Other options: groq, openrouter (free), openai, anthropic (paid), custom. PART 6 — AUTO-LOG PAYMENTS FROM BANK EMAILS (optional) Apps Script > choose setupGmailScan > Run > allow Gmail. Every hour Pihu reads only bank/UPI debit alert emails and logs them in Payments. Bills with a matching Keyword are marked paid. Turn off any time with stopGmailScan. PART 7 — TURN ON REAL SMS CODES (owner, once) Until you do this, sign-in runs in TEST MODE: no SMS is sent and the code is always 123456 (the app says so on screen). 1. Open https://console.firebase.google.com > Add project > name it aipihu > Create. 2. Build > Authentication > Get started > Sign-in method > Phone > Enable > Save. 3. Authentication > Settings > Authorized domains > Add domain: aipihu.netlify.app (and your own domain later). 4. Project settings (gear) > Your apps > Web () > Register app. Copy the firebaseConfig values. 5. Open app/config.js inside the website zip and replace window.PIHU_FIREBASE = null; with: window.PIHU_FIREBASE = { apiKey: "...", authDomain: "...", projectId: "...", appId: "..." }; 6. Upload the zip to Netlify again. Real SMS codes now go to every new user. Note: Google may ask you to switch the Firebase project to the pay-as-you-go plan for SMS, and each SMS has a small charge. Set a budget alert in Google Cloud. Phone numbers stay in your Firebase project. WHEN YOU CHANGE Code.gs LATER Deploy > Manage deployments > pencil > Version: New version > Deploy. The link stays the same. TRY SAYING "What needs me today?" "Pay my LIC premium" / "LIC ka premium bhar do" "Turn these notes into tasks: call CA, renew insurance" "Show my bills" · "Open business" · "Switch to Hindi" SAFETY Pihu never sends, pays or deletes on its own. Payments open your UPI app and you enter your PIN there. Messages open WhatsApp and you press Send.