Hire: Make expert for WA+SMS fallback w/ Google Sheets logging $100

Hire a Pro
1

TL;DR
I need a simple, reliable Make.com scenario: Google Sheets → WhatsApp (Meta API) → SMS fallback (SMSPortal) → write results back to the sheet. I’ll paste the ReviewGrower link into the sheet myself. Budget-conscious, quick delivery. Paid test $55, then full delivery fixed price.

Stack

  • Make.com

  • Google Sheets

  • WhatsApp Cloud API (Meta Graph API v20+)

  • SMSPortal (REST API)

Flow

  1. Watch/Search rows in Google Sheets where status="pending" and phone_e164 present.

  2. WhatsApp first: HTTP call to /{phone_number_id}/messages with template send (params: {name}, {practice}, {rg_link}).

  3. On WA success (2xx) → write back: status="wa_sent", wa_message_id, last_sent_at, attempts+1.

  4. On WA fail (4xx/5xx) → fallback to SMS via SMSPortal.

  5. On SMS success → write back: status="sms_sent", sms_message_id, last_sent_at, attempts+1.

  6. On both fail → status="failed", last_error, attempts+1.

  7. Idempotency: never re-send if status is wa_sent or sms_sent.

Sheet columns (example; keep semantics)

  • timestamp_created | name | practice | phone_e164 | wa_template | wa_lang_code | rg_link | status | wa_message_id | sms_message_id | last_error | last_sent_at | attempts

WhatsApp template example (HTTP → Request content)

{
  "messaging_product": "whatsapp",
  "to": "{{phone_e164}}",
  "type": "template",
  "template": {
    "name": "{{wa_template}}",
    "language": { "code": "{{wa_lang_code}}" },
    "components": [
      {
        "type": "body",
        "parameters": [
          { "type": "text", "text": "{{name}}" },
          { "type": "text", "text": "{{practice}}" },
          { "type": "text", "text": "{{rg_link}}" }
        ]
      }
    ]
  }
}

Reliability & handling

  • 4xx on WA → treat as hard fail → go to SMS.

  • 5xx on WA → retry once (short delay), then SMS.

  • 5xx on SMS → retry once; else mark failed.

  • Small delay/rate-limit friendly.

  • Secrets via Make connections/variables (no hard-coding).

Deliverables

  1. Working Make scenario (share/import)

  2. Clear comments in modules + short PNG diagram of flow

  3. 5–10 min Loom walkthrough (how to swap tokens, sheet IDs)

  4. Acceptance tests pass (see below)

Acceptance tests (must pass)

  • A: WA success → wa_sent + wa_message_id written

  • B: WA 4xx simulated → SMS success → sms_sent + sms_message_id written

  • C: Both fail simulated → failed + last_error written

  • D: Re-run on already sent row → no duplicate send

Budget & milestones

  • Paid test: $55 — WA send + writeback + failure path writing failed.

  • Full delivery: $120–$200 fixed (WA + SMS fallback + idempotency + error handling + Loom).

What to include in your reply

  • 2–3 lines on similar Make builds (WA Cloud API + HTTP + Sheets + fallback)

  • A redacted sample of your WA template JSON body

  • One sentence on how you prevent duplicates in Make

  • Your fixed price within the range and timeframe

Logistics

  • Timezone: SAST (UTC+2)

  • I’ll provide: temporary Page Access Token, Phone Number ID, and SMSPortal API key.

Thanks! Looking for fast, dependable delivery at a lean cost.

3

Hello @Craig_Murray , welcome to make.com community, I have worked and have experience with Make.com and l will love to collaborate with you on this you can schedule a call Here and you can checkout my upwork profile Here, for my pastworks and certifications

4

Hi, I have experience with this on make, and I am available to help.

Let me know how we can connect.

5

Hey @Craig_Murray , I can help you build a reliable Make.com flow that sends messages via WhatsApp first, falls back to SMS through SMSPortal, and updates Google Sheets with the results. I’ll include full error handling, idempotency, and status tracking so nothing gets resent or missed.

Schedule a call with me here so we can discuss this over a call.

1 Like
6

Hey Greatness, can you please provide me with your email address and I can send you my requirements and more info on what I am looking for and what I need to achieve?
I’ll also send you a screenshot of the scenario I have built.
Let me know if this works for you.
Thanks
Craig

7

Hi @Craig_Murray,

If you still need help with the scenario, we can connect and get it done as soon as possible.
Feel free to check out my Fiverr Services and connect with me on LinkedIn
Let’s collaborate!