1001 Freelance Projects
Latest Projects from
Freelance Marketplaces
View Project
View this project in detail
(Note: you will be redirected to external marketplace)
Project title:
Automated Data Processing Portal
Posted by:
External project from PeoplePerHour
Started:
13-Mar-2025 20:55 GMT
Description:
Developer Job Specification: Automated Data Processing Portal for Warm & Inflyte
Overview:

We are looking for an experienced backend developer (preferably with API integration and automation experience) to build a custom platform/portal that automates our current manual data processing workflow between Warm Radio Airplay Tracking and Inflyte DJ Feedback.

We currently download:
this from Warm Which is plays on radio:
https://www.dropbox.com/scl/fi/hwyb5rwx6bwyxfvmptkiz/WARM-Report-for-Mau-P-All-Songs-2024-12-13_2025-03-13.xlsx?rlkey=yf2a9tqooyi4fgvk2t4c6xejk&e=1&dl=0

and
this from Inflyte which is DJ Feedback:
https://www.dropbox.com/scl/fi/xi3d5fc3jkf4txtyiopjc/Inflyte_stats_189484-4.docx?rlkey=4oiagwg19beuo9lcmjtyk13lr&e=1&dl=0

Currently, we download data from both platforms manually, reformat it in Excel, and update a Google Sheet weekly.

Example:
https://www.dropbox.com/scl/fi/q1uc6iqcf3jqa2xuwxs3k/Mau-P-The-Less-I-know-The-Better-Radio-Club-Report-wc-3_3-NERVOUS.xlsx?rlkey=234f890e9799b4pv7n1z3llic&e=1&dl=0

We need a streamlined automated solution to handle this process.

Project Requirements
1. Core Functionality
• API Integration (https://www.dropbox.com/scl/fi/nyfhnldl6g3qn0jhiowc8/Inflyte-Customer-API-v1.5.pdf?rlkey=k52sdcygmt3uiv2u7fy6cj968&e=1&dl=0)
◦ Connect to Warm API (Radio Airplay Tracking) - https://www.warmmusic.net/
◦ Connect to Inflyte API (DJ Feedback) - https://inflyteapp.com/
◦ Extract relevant data from both sources
• Data Processing & Transformation
◦ Normalise, clean, and format the extracted data to match our required structure
◦ Merge both data sources appropriately
• Google Sheets Integration
◦ Append new weekly data to an existing Google Sheet
◦ Move previous week's data to the bottom of the sheet
◦ Ensure easy manual editing when required

2. Additional Features (Nice-to-Have)
• Automated Weekly Scheduler
◦ Set up an automatic weekly data update
◦ Option for manual trigger (button inside a simple web UI)
• Basic User Interface (Optional but preferred)
◦ Secure login for internal team
◦ Dashboard to view processed data logs & allow manual refresh
• Error Handling & Logging
◦ Notify us via email/Slack if the automation fails

Tech Stack Preference (Flexible)
• Backend: Python (Flask/Django) or Node.js (Express)
• Database: Google Sheets API (or PostgreSQL if needed)
• Hosting: AWS Lambda, Google Cloud Functions, or Heroku
• Frontend (Optional): React/Next.js (for basic UI)

Ideal Candidate Skills
• Experience working with API integrations (RESTful APIs, JSON)
• Proficiency in Python or Node.js for automation
• Google Sheets API knowledge
• Cloud hosting experience (AWS/GCP/Heroku)
• Strong problem-solving and debugging skills



How to Apply
To be considered, please send a proposal including:
• Relevant past experience with API automation & Google Sheets
• Your suggested approach for building the system
• Any portfolio/examples of similar work

Looking forward to working with a skilled developer who can streamline our process and save us valuable time!
Project ID:
3426032
Project category:
Project budget:
View this project in detail
(Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
C++ Sensor Fusion Developer
Category: Algorithm, C, Programming, C++, Computer Vision, Data Processing, Embedded Systems, Linux, Software Architecture
Budget: ₹37500 - ₹75000 INR
26 Apr 2026 04:02 GMT
Remote Ad Ops Assistant Needed
Category: Advertising, Compliance, Customer Service, Data Entry, Digital Marketing, Internet Research, Project Management, Social Media Management, Time Management, Virtual Assistant
Budget: $30 - $250 USD
26 Apr 2026 04:02 GMT
Mystical Horror Thumbnail Design
Category: Adobe Creative Cloud, Adobe Illustrator, Photoshop, After Effects, Animation, Graphic Design, Illustration, Motion Graphics
Budget: ₹600 - ₹1500 INR
26 Apr 2026 03:57 GMT
Modern Premium Logo for Eventoza
Category: Adobe Creative Suite, Adobe Illustrator, Branding, Graphic Design, Illustration, Logo Design, Photoshop, Visual Design
Budget: ₹600 - ₹1500 INR
26 Apr 2026 03:56 GMT
Python Project Development Support
Category: C, Programming, Debugging, Java, Python, Software Architecture, Software Development, Software Engineering
Budget: ₹1250 - ₹2500 INR
26 Apr 2026 03:53 GMT
Terjemahan Lengkap ke Bahasa Indonesia
Category: Content Writing, Copywriting, Data Entry, Indonesian Translator, Language Tutoring, Proofreading, Technical Writing, Translation
Budget: $15 - $25 USD
26 Apr 2026 03:52 GMT
Polish 70-Second Facebook Ad
Category: Social Video Marketing, Video Editing, Video Services
Budget: $10 - $30 USD
26 Apr 2026 03:50 GMT
Movie Breakdown Channel Branding
Category: Advertising, Branding, Content Marketing, Creative Writing, Digital Marketing, Graphic Art, Graphic Design, Social Media Marketing, Video Editing
Budget: ₹600 - ₹1500 INR
26 Apr 2026 03:49 GMT
TruePeopleSearch Python Scraper
Category: Automation, Data Analysis, Data Extraction, Data Processing, PHP, Python, Selenium, Software Architecture, Web Scraping
Budget: $250 - $750 USD
26 Apr 2026 03:47 GMT
Action Detective Shonen Manga Artist
Category: 2D Drawing, Illustration, Manga
Budget: $750 - $1500 USD
26 Apr 2026 03:44 GMT
Multi-Source Energy System Prototype Development
Category: Bill Of Materials (BOM) Optimization, Electrical Engineering, Electronics, PCB Layout, Product Design, Troubleshooting, Video Production
Budget: $10 - $1000 USD
26 Apr 2026 03:44 GMT
Fantasy/Sci-Fi 3D Animation
Category: 3D Animation, 3D Art, 3D Design, 3D Graphic Design, 3D Modelling, 3D Rendering, 3D Visualization, Animation, Blender, Maya
Budget: $250 - $750 USD
26 Apr 2026 03:43 GMT
Develop a Grid Layout News Theme
Category: CSS, HTML, JavaScript, PHP, UI / User Interface, Web Design, Web Development, WordPress, WordPress Design
Budget: ₹1500 - ₹12500 INR
26 Apr 2026 03:42 GMT
High-Resolution Conversion from PNG
Category: Photoshop, Graphic Design, Illustration, Image Processing, Logo Design, Photo Editing, Print Design
Budget: ₹600 - ₹1500 INR
26 Apr 2026 03:41 GMT
Remote Customer Support Assistant (Ecommerce – Shopify, Email, Instagram & Facebook)
Category: Customer Service, Email Handling, Facebook Marketing, Instagram Marketing, Internet Marketing, Product Descriptions, Shopify, Social Media Management
Budget: $8 - $15 AUD
26 Apr 2026 03:39 GMT
Browse All Projects
Projects by Skills ...
android
ajax
asp
aspnet
cms
cpp
csharp
css
delphi
design
drupal
excel
facebook
flash
html
java
javascript
joomla
iphone
mysql
photoshop
php
python
ruby
seo
sql
sysadm
translate
typing
twitter
vbnet
xml
wordpress
writing
New!
Проекты на русском
(Projects in Russian)

Copyright © 2005-2025
1001 Freelance Projects