full-stack developer who builds SaaS with Supabase/Next.js and integrates third-party APIs via OAuth

Posted 3 weeks ago

Worldwide

Summary

Supabase backend + ServiceM8 & Xero OAuth integration for SaaS MVP I’m building a revenue intelligence SaaS for Australian trade businesses. The frontend is already built. I need a backend in Supabase that connects to ServiceM8 and Xero via OAuth and calculates job-level gross profit. What I need built — nothing more: 1. Supabase schema (4 tables) • users — id, email, business_name, phone, plan, created_at • connections — id, user_id, platform, access_token, refresh_token, expires_at • jobs — id, user_id, job_name, revenue, labour_cost, materials_cost, gp_percent, completed_at • insights — id, user_id, week_starting, best_job_type, worst_job_type, avg_gp, report_text, sent_at Row Level Security enabled. Users see only their own data. 2. ServiceM8 OAuth flow • OAuth 2.0 authorization — user clicks Connect, approves, token stored in Supabase • Token refresh handled automatically • Pull from: /job.json, /jobmaterial.json, /jobactivity.json • Calculate GP%: (revenue - labour - materials) / revenue × 100 • Daily sync via Supabase Edge Function cron 3. Xero OAuth flow • Same OAuth 2.0 pattern • Pull from: invoices, accounts • Cross-reference with ServiceM8 data to validate GP% 4. Monday WhatsApp trigger • Supabase Edge Function runs every Monday 7am AEST • Queries last 7 days of jobs per user • Calculates best job by GP%, worst job, weekly average GP% • Sends via Twilio WhatsApp API (I provide credentials) • Stores result in insights table 5. Auth • Supabase magic link (email only, no passwords) What I do NOT want: • No custom admin dashboard • No payment integration • No mobile app • No Docker or complex deployment • No unit tests for MVP Deliverables: 1. Supabase schema live with RLS and seed data 2. ServiceM8 OAuth working end-to-end 3. Xero OAuth working end-to-end 4. Daily sync edge function confirmed working 5. Monday WhatsApp confirmed with test send 6. Plain English README Payment is milestone-based — you get paid when each piece is verified working. To apply, answer both: 1. Have you built OAuth integrations with Xero, QuickBooks, or any accounting API before? Briefly describe it. 2. What’s one thing in this brief you’d want to clarify before starting? Proposals that don’t answer both questions will not be considered.

  • $1,200.00

    Fixed-price
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
PostgreSQL
API Integration
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:3 weeks ago
  • Hires:
    1
  • Interviewing:
    0
  • Invites sent:
    2
  • Unanswered invites:
    0
About the client
Member since Feb 23, 2021
  • AUS
    Sydney4:23 PM
  • $800 total spent
    1 hire, 1 active

Explore similar jobs on Upwork

Software DeveloperHourly‐ Posted 7 months ago
ASP.NET MVC
Django
Python
AngularJS
JavaScript
jQuery
WordPress
Google Chrome Extension
React
CRM Development
Microsoft Dynamics 365
Microsoft Dynamics CRM
Microsoft Dynamics Development
Microsoft PowerApps
Single Sign-On
Three.js
JavaScript
WordPress
AR Plugin
WooCommerce
3D Modeling

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo