1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 07-Jun-2025 15:35 GMT
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
Diseño de landings para productos COD (con apoyo y formación incluida)
Category: Copywriting, ECommerce, Shopify, Shopify Templates
Budget: €8 - €30 EUR
07-Jun-2025
10:03 GMT
Vintage Logo Design Needed
Category: 3D Design, Graphic Design, Illustration, Logo Design, Photoshop
Budget: ₹600 - ₹1500 INR
07-Jun-2025
10:01 GMT
Content Writing Intern for Non-profit
Category: AI Content Writing, Article Writing, Blog, Ghostwriting
Budget: ₹12500 - ₹37500 INR
07-Jun-2025
10:01 GMT
Chinese Investors for Real Estate
Category: Market Research, Simplified Chinese Translator, Traditional Chinese (Hong Kong), Traditional Chinese (Taiwan), Translation
Budget: min $50 AUD
07-Jun-2025
10:01 GMT
Classic Blog Site Design website design
Category: Graphic Design, HTML, PHP, Web Design, WordPress
Budget: $15 - $25 USD
07-Jun-2025
10:01 GMT
Fantasy Short Stories Writer & Editor
Category: Creative Writing, Editing, Fiction, Ghostwriting, Short Stories
Budget: ₹12500 - ₹37500 INR
07-Jun-2025
10:01 GMT
iPhone Fashion Photographer Needed
Category: Articulate Storyline, Content Creation, Content Strategy, IPhone, Photography
Budget: ₹600 - ₹1500 INR
07-Jun-2025
10:01 GMT
Zoho Integration Expert Needed
Category: CRM, MySQL, PHP, Salesforce.com, Zoho
Budget: ₹750 - ₹1250 INR
07-Jun-2025
09:59 GMT
Dynamic Android Admin Panel App
Category: Android, Mobile App Development, MySQL
Budget: ₹1500 - ₹12500 INR
07-Jun-2025
09:59 GMT
Photography or Videography
Category: Engineering, Product Photography, Software Architecture
Budget: $15 - $25 USD
07-Jun-2025
09:57 GMT
Implement Zoho SalesIQ
Category: Artificial Intelligence, CRM, Software Architecture, Zoho
Budget: €30 - €250 EUR
07-Jun-2025
09:57 GMT
Materials Request Management System
Category: .NET, Django, JavaScript, SQL
Budget: $30 - $250 USD
07-Jun-2025
09:57 GMT
Website Visual Refinement on Wix
Category: CSS, Graphic Design, HTML, User Interface / IA, Web Design
Budget: €12 - €18 EUR
07-Jun-2025
09:54 GMT
Virtual Assistant for Automotive Industry Data Research in Singapore
Category: Data Entry, Internet Research, Market Research, Research, Virtual Assistant
Budget: $100 - $200 SGD
07-Jun-2025
09:54 GMT
PowerMTA Autoinstaller for Linux
Category: Debian, Email Marketing, Linux, System Admin, Ubuntu
Budget: $30 - $250 USD
07-Jun-2025
09:53 GMT
Browse All Projects
Projects by Skills ...
Projects for 'android'
Projects for 'ajax'
Projects for 'asp'
Projects for 'aspnet'
Projects for 'cms'
Projects for 'cpp'
Projects for 'csharp'
Projects for 'css'
Projects for 'delphi'
Projects for 'design'
Projects for 'drupal'
Projects for 'excel'
Projects for 'facebook'
Projects for 'flash'
Projects for 'html'
Projects for 'java'
Projects for 'javascript'
Projects for 'joomla'
Projects for 'iphone'
Projects for 'mysql'
Projects for 'photoshop'
Projects for 'php'
Projects for 'python'
Projects for 'ruby'
Projects for 'seo'
Projects for 'sql'
Projects for 'sysadm'
Projects for 'translate'
Projects for 'typing'
Projects for 'twitter'
Projects for 'vbnet'
Projects for 'xml'
Projects for 'wordpress'
Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android'
RSS feed for 'ajax'
RSS feed for 'asp'
RSS feed for 'aspnet'
RSS feed for 'cms'
RSS feed for 'cpp'
RSS feed for 'csharp'
RSS feed for 'css'
RSS feed for 'delphi'
RSS feed for 'design'
RSS feed for 'drupal'
RSS feed for 'excel'
RSS feed for 'facebook'
RSS feed for 'flash'
RSS feed for 'html'
RSS feed for 'java'
RSS feed for 'javascript'
RSS feed for 'joomla'
RSS feed for 'iphone'
RSS feed for 'mysql'
RSS feed for 'photoshop'
RSS feed for 'php'
RSS feed for 'python'
RSS feed for 'ruby'
RSS feed for 'seo'
RSS feed for 'sql'
RSS feed for 'sysadm'
RSS feed for 'translate'
RSS feed for 'typing'
RSS feed for 'twitter'
RSS feed for 'vbnet'
RSS feed for 'xml'
RSS feed for 'wordpress'
RSS feed for 'writing'
New!
Проекты на русском
(Projects in Russian)

Short URL:
1001fp.com
Mobile version:
m.1001freelanceprojects.com
Copyright © 2005-2024 1001 Freelance Projects