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
Automate Shopify Order Export and Integration with Internal System
Category: Google Chrome, JavaScript, PHP, Shopify, Software Architecture
Budget: $250 - $500 USD
02 Dec 2025 01:13 GMT
Solicitar cotizaciones de manera presencial en negocios de Cancún -- 30319
Category: Admin Support, Audit, Customer Service, Customer Support, General Labor, General Office, Local Job, Market Research, Marketing, Virtual Assistant
Budget: $30 - $250 USD
01 Dec 2025 23:03 GMT
Update Corporate Event Invitation
Category: Adobe Illustrator, Adobe InDesign, Photoshop, Branding, Graphic Design, Illustration, Invitation Design, Print Design, Visual Design
Budget: $30 - $250 AUD
01 Dec 2025 23:01 GMT
Solicitar cotizaciones de manera presencial en negocios de Querétaro -- 75776
Category: Admin Support, Audit, Customer Service, Customer Support, General Labor, General Office, Local Job, Market Research, Marketing, Virtual Assistant
Budget: $30 - $250 USD
01 Dec 2025 23:01 GMT
Gießen Verification Field Task
Category: Customer Service, Data Collection, Data Entry, Field Sales, Geolocation, PDF, Photo Editing, Photography, Photoshop, PHP
Budget: $30 - $40 USD
01 Dec 2025 23:00 GMT
Medir conversiones Google Ads & WhatsApp
Category: A / B Testing, Analytics, API, Google Ads, Google Adwords, Google Analytics, JavaScript, PHP
Budget: $30 - $250 USD
01 Dec 2025 22:59 GMT
Solicitar cotizaciones de manera presencial en negocios de Ciudad de México -- 64675
Category: Admin Support, Audit, Customer Service, Customer Support, General Labor, General Office, Local Job, Market Research, Marketing, Virtual Assistant
Budget: $30 - $250 USD
01 Dec 2025 22:59 GMT
AI-Savvy Employment Lawyer Sought
Category: AI (Artificial Intelligence) HW / SW, AI Consulting, AI Development, Employment Law, Legal, Legal Consultation, Legal Research, Property Law
Budget: $30 - $250 USD
01 Dec 2025 22:59 GMT
Next.js Newsletter Signup Integration
Category: API Development, Cloudflare, Frontend Development, HTML, JavaScript, Next.js, Web Development
Budget: $30 - $250 USD
01 Dec 2025 22:59 GMT
Flutter Webview App & Admin
Category: Android, Backend Development, Flutter, JavaScript, Mobile App Development, REST API, Web Development
Budget: $250 - $750 USD
01 Dec 2025 22:57 GMT
Solicitar cotizaciones de manera presencial en negocios de Lerma -- 8
Category: Admin Support, Audit, Customer Service, Customer Support, General Labor, General Office, Local Job, Market Research, Marketing, Virtual Assistant
Budget: $30 - $250 USD
01 Dec 2025 22:56 GMT
Short videos
Category: A / V Editing, After Effects, Video Ads, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services, Video Streaming, Video Tours
Budget: $30 - $250 USD
01 Dec 2025 22:56 GMT
24×36 Charcoal Portrait Gift -- 2
Category: Drawing Artist, Illustration, Matte Painting, Sketching
Budget: $250 - $750 USD
01 Dec 2025 22:54 GMT
Custody Documentation and Temporary Order for Jackson County Missouri (64056)
Category: Editing, Family Law, Legal Consultation, Legal Research, Legal Writing, Microsoft Word, PDF, Proofreading, Research Writing, Word
Budget: $100 - $250 USD
01 Dec 2025 22:53 GMT
Vectorizar Gráficos Completos de Furgoneta
Category: Adobe Illustrator, Graphic Design, Illustration, Logo Design, Photoshop, SVG, Vector Design
Budget: €30 - €250 EUR
01 Dec 2025 22:53 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-2024
1001 Freelance Projects