Rifki Rosada | Automation Systems

SP2DK & LHP2DK WhatsApp Reminder System

Built a Google Workspace reminder system that classifies SP2DK/LHP2DK deadlines, maps ownership, and prepares WhatsApp-ready follow-up from Sheets.

Google Workspace Automation Engineer Completed Jun 2026 Remote contract delivery
  • Problem

    Before delivery, SP2DK/LHP2DK monitoring depended on manual deadline checks, scattered status review, and follow-up visibility that was easy to miss as records moved across owners and sections.

  • My scope

    Mapped the follow-up operation around document type, due date, status, responsible staff/section, and reminder bucket.

  • Result

    Turned deadline monitoring into a structured reminder workflow with H-7/H-3/H-1/Overdue buckets and WhatsApp-ready follow-up.

Problem

Before delivery, SP2DK/LHP2DK monitoring depended on manual deadline checks, scattered status review, and follow-up visibility that was easy to miss as records moved across owners and sections.

Constraints

  • Operational records, staff identifiers, and communication details had to remain private
  • Reminder buckets had to reflect practical follow-up urgency: H-7, H-3, H-1, and Overdue
  • The system needed to work inside Google Sheets / Apps Script instead of adding a heavy new platform

System workflow

  • Mapped the follow-up operation around document type, due date, status, responsible staff/section, and reminder bucket.
  • Built Apps Script logic over Google Sheets to classify deadlines, map AR/status ownership, and expose the next follow-up state.
  • Created a lightweight Apps Script web-app flow for monitoring and WhatsApp-ready reminder preparation.
  • Kept public documentation sanitized by excluding sheet URLs, record identifiers, phone numbers, and internal document details.

Result

  • Converted manual deadline checking into a structured monitoring workflow with H-7, H-3, H-1, and Overdue classifications.
  • Gave operations a clearer view of follow-up status by responsible staff/section without exposing private records.
  • Prepared WhatsApp-ready reminder output so urgent follow-up can be reviewed and acted on faster.
  • Client review highlighted responsiveness, communication, practical solutions, and a satisfying result.

Client proof

The result was very satisfying. Rifki was responsive, communicative, and always came with solutions. Thank you, Rifki. Wishing you continued success.

ANONYMOUS CLIENT — SP2DK/LHP2DK reminder automation client
Translated client review

Tech stack

  • Google Apps Script
  • Google Sheets
  • Apps Script Web App
  • Google Workspace
  • WhatsApp-Ready Reminder Flow
  • Deadline Classification
  • Status / Ownership Mapping
  • Operations Automation

Related delivery proof across internal tools, automation, Android + AI, and supporting product systems.

Automation Systems

Client delivery

Inbound Order & Lead Ops Automation

Automation Engineer2-week delivery sprint

Eliminated an estimated 60–80 hours/month of manual data entry across multi-branch operations. Booking + reporting now flow automatically into a single source of truth.

  • Problem

    Inbound orders, bookings, and chat updates were copied manually into spreadsheets across multiple branches, producing inconsistent records, delayed follow-up, and zero operational visibility for management.

  • My scope

    Implemented web-order-to-sheet automation with validation and normalization.

  • Result

    Eliminated an estimated 60–80 hours/month of manual data entry across multi-branch operations. Booking + reporting now flow automatically into a single source of truth.

  • n8n
  • Google Apps Script
  • Google Sheets
Read case study

Automation Systems

Client delivery

AI Content Research & Script Automation

AI Automation EngineerCompleted May 2026

Converted manual content research into a repeatable AI-assisted script pipeline with Docs output and Sheets approval tracking.

  • Problem

    Before delivery, each script cycle required manual scanning for current topics, reference validation, source summarization, short-form script drafting, Doc creation, and review-status tracking.

  • My scope

    Mapped the end-to-end content operation: topic discovery, reference collection, summary generation, script drafting, Docs export, and Sheets-based status review.

  • Result

    Converted manual content research into a repeatable AI-assisted script pipeline with Docs output and Sheets approval tracking.

  • OpenAI
  • Google Apps Script
  • Google Docs
Read case study

Client Systems

Client delivery

Enterprise CRM - Sales Pipeline & Performance System

Lead Full-Stack Engineer6-week delivery sprint

Cut the weekly pipeline review cycle from ~2 days of spreadsheet reconciliation to ~15 minutes — single source of truth across sales, ops, and management.

  • Problem

    Pipeline updates and performance reporting were split across 3 separate spreadsheets, making weekly reviews take days and ownership hard to trust.

  • My scope

    Mapped sales stages, reporting rules, and operator roles before touching schema or UI.

  • Result

    Cut the weekly pipeline review cycle from ~2 days of spreadsheet reconciliation to ~15 minutes — single source of truth across sales, ops, and management.

  • Laravel
  • Next.js
  • PostgreSQL
Read case study

Planning a similar build?

Share the workflow, delivery risk, and timeline. I will reply with the best starting scope.

Share your scope Email project brief