we rescue pets

🐾 Taglinks Process Guide (1 of 2)

Backlog relaunch sequence & Ambassador programme. Click any node for detail.

PHASE 1 — FETCH SUBSCRIBER DATA Paste phone numbersColumn A of Backlog tab Fetch from TaglinksMenu → Backlog: Fetch Row populatedName, tag, renewal — "Ready" PHASE 2 — SEND WELCOME-BACK (MESSAGE 1) Select "Ready" rowsHighlight up to 20 at a time Send Welcome-BackMenu → Relaunch: Send Email with WA buttonsCol I = "Sent" · Col J = date Message 1 content (pre-filled in WhatsApp) "Hi [Name] 👋 You know the QR pet tag. Meet the Lost Pets app… Free for everyone until 1 September 🌱 — Welcome Back! [signup link]" ⏱ Wait 7 days PHASE 3 — FOLLOW-UP (MESSAGE 2) Send Follow-upsMenu → Relaunch: Follow-ups Script checks Col JOnly rows 7+ days since Msg 1 Email with WA buttonsCol I = "Followed Up" · Col K = date Message 2 content — rolling deadline (7 days from send date) "Hi [Name] 👋 Just a quick follow-up about the Taglinks relaunch… If we don't hear from you by [date+7], we'll quietly deregister your profile. Free until 1 September 🌱 — Tap here to get started: [signup link]" ⏱ Wait 7 days PHASE 4 — DEREGISTER CHECK Flag DeregistrationsMenu → Flag Dereg (7+ days) Script checks Col K7+ days since follow-up Summary email + listCol I = "Deregister" Subscribers who install the app → offered ambassador role → enter Ambassador flow Backlog tab → Renewals tab via "Move Selected" for ongoing annual renewal tracking Click any node for detail · Dashed arrows show data flow between steps

All three phases are manual — you run each menu item. The script handles the timing checks, message assembly, and status updates automatically.

AMBASSADOR ONBOARDING Sign agreementChoose Option A or B Add to Ambassadors tabCols A–G · Option A or B in G Generate linkPre-filled Form URL + Yola redirect NEW SUBSCRIBER SIGNS UP Google Form submittedVia werescuepets.co.za/[name] onFormSubmit firesAuto — no action needed Two emails sentPaul + ambassador notified DELIVERY BRANCH PUDO chosenCol K = "Awaiting Payment" Local delivery chosenAmbassador distributes tag Send payment linkMenu → Send PUDO Payment Link Mark PUDO as PaidMenu → Mark Selected PUDO Paid COMMISSION TRACKING (OPTION B) Referral countedAuto on form submit Renewal marked PaidR18 added to comm owing Quarterly payoutMenu → Process Commission TIER MILESTONES (OPTION A) Every 3 referralsScript fires tier check auto Congratulations emailAmbassador + Paul notified Monthly ambassador report: Menu → Send Monthly Ambassador Report Shows each ambassador's referrals · free years · commission owing · status Click any node for detail