we rescue pets

🐾 Taglinks Process Guide (2 of 2)

Sheet structure & column guide · Trigger timing · Menu reference. Click any node for detail.

ONE GOOGLE SPREADSHEET — BOTH SCRIPTS LIVE HERE Renewals tab A First Name B Cell Phone C Tag ID D Renewal Date E Amount Due F Reminder Sent G Reminder Date H Status I Paid Date J Referred By ← ambassador link Backlog tab A Cell Phone (paste here) B First Name C Last Name D Tag ID E Pet Name F Renewal Date G Amount Due H Fetched Date I Status (Ready/Sent/Followed Up/Dereg) J Sent Date K Follow-up Date J drives follow-up · K drives deregister Submissions tab A Timestamp (auto) B First Name C Last Name D WhatsApp E Email F Suburb G Pet Name H Pet Type I Delivery Method J Ambassador ← pre-filled URL param K PUDO Status L PUDO Paid Date M Notes Add K, L, M headers manually after form linked Ambassadors tab A Name B WhatsApp C Email D Personalised URL E Form URL F Date Joined G Reward Option ← A or B (critical) H Total Referrals (auto) I Free Years Earned (auto — Option A) J Commission Owing (auto — Option B) K Commission Paid (manual) L Status Name in A must match Renewals J exactly Two Apps Script files Renewals.gs — renewal + backlog + relaunch Ambassador.gs — form, PUDO, commission Google Form (external) Linked to Submissions tab · pre-filled ?entry=Name ⚠ Critical naming rule Ambassador name must be identical in: Ambassadors A · Renewals J · Form URL param Both scripts share the same spreadsheet. Extensions → Apps Script → two files. Run installFormTrigger() once · Run installTriggers() once · Done. Click any tab for column detail
AUTOMATED TRIGGERS — RUN WITHOUT YOU Every Monday 07:00 Weekly renewal check Sends reminder email Daily 08:00 Overdue check 14+ days since reminder 5th of month 09:00 Monthly summary Revenue + status report On form submit (instant) Notifies Paul · notifies ambassador · updates Ambassadors sheet · fires tier check MANUAL MENU ACTIONS — YOU RUN THESE 🐾 Renewals menu ✅ Mark as Paid 🔍 Run renewal check ⏰ Run overdue check 📥 Backlog: Fetch 📨 Backlog: Send reminders ➡️ Backlog: Move to Renewals 🐾 Relaunch menu 🚀 Send Welcome-Back 🔁 Send Follow-ups (7+ days) 🚫 Flag Deregistrations 📊 Monthly summary 🔄 Import from Taglinks 🐾 Ambassador menu 🔄 Refresh totals 📊 Monthly report 💳 Mark PUDO Paid 📨 Send PUDO payment link ✅ Flag PUDO requests 💰 Process quarterly commission ONE-TIME SETUP — RUN ONCE ONLY installTriggers() Sets Monday, daily, monthly auto-triggers installFormTrigger() Links form submit to ambassador script SEPTEMBER — CONVERSION MOMENT Free period ends · R72 renewal opens Weekly reminder fires for all subscribers due · Option B ambassadors earn R30 per new subscriber Renewals marked Paid in sheet → R18 auto-credited to referring Option B ambassador Q4 payment run (15 October): Menu → Process Quarterly Commission → statements sent to all Option B ambassadors Option A ambassadors: free years auto-counted · milestone emails fire automatically at every 3rd referral Click any item for detail