Make.com specialist — build 3 pre-designed scenarios (Midtrans + Google Sheets)

Замовник: AI | Опубліковано: 23.04.2026
Бюджет: 750 $

I run a restaurant in Bali, Indonesia and need a Make.com specialist to deploy 3 pre-designed automation scenarios for our daily finance reconciliation. IMPORTANT | WE ALREADY HAVE - Make.com Pro account (active) - 3 Make.com scenario blueprints in JSON format (ready to import) - Google Sheets reconciliation template (pre-built with 800+ formulas) - Full written specification for each scenario - Midtrans API credentials (production) - HTML email template for daily reports So this is NOT a build-from-scratch project. You import the blueprints, configure authentication, test, activate and document. Most of the hard thinking is done. WHAT YOU WILL DO 1. Import 3 blueprint JSON files into Make.com 2. Configure authentication: Midtrans API, Google Sheets, Gmail 3. Connect each scenario to the correct Google Sheet tabs 4. Test each scenario end-to-end with real data 5. Activate scenarios on their schedules 6. Configure error notifications 7. Record a 10-minute walkthrough video (Loom or similar) 8. Provide 7 days of post-launch support for bugs/questions THE 3 SCENARIOS Scenario A — Midtrans Deposit Sync Pulls payment transactions from Midtrans API into Google Sheets every 6 hours. Scenario B — POS Bills Sync Pulls daily bills from our POS system (ESB) via API or scheduled CSV import. Runs overnight. Scenario C — Daily Cash Snapshot Email Sends a formatted HTML email to leadership every morning at 08:00 WITA with cash balances, deposits outstanding and exceptions. REQUIREMENTS - Proven Make.com experience (share 1-2 scenarios you've built) - Comfortable with REST APIs, JSON, OAuth, Bearer tokens - Experience with Google Sheets automation (Search Row, Add Row, Update Row modules) - Good written English - Available for async communication (WhatsApp or Slack) during build - Can start within 48 hours of hiring TIMELINE AND BUDGET - Duration: 2-3 days of actual work - Budget: USD 250-500 fixed price - Milestones: 50% on Scenario A completion, 50% on final activation + walkthrough video - Start: Within 48 hours of award TO APPLY, INCLUDE IN YOUR BID 1. How many Make.com scenarios have you built in the last 12 months? 2. Have you worked with payment gateways like Midtrans, Stripe, Xendit, or similar? If yes, which ones? 3. Your estimated time to complete this work (hours) 4. Link to 1-2 Make.com scenarios you've built (Loom video, screenshots, or portfolio) 5. Your timezone and daily availability Bids that don't answer these questions will not be considered. Generic copy-paste bids will be ignored. WHAT HAPPENS AFTER YOU ARE AWARDED I will share via secure channel: - All 3 blueprint JSON files - Google Sheets edit access - Make.com team invite (Admin role) - Midtrans API credentials (via password manager, not plain text) - Full technical reference PDF (14 pages) with module-level specifications - My WhatsApp for async questions Looking forward to your bid.