1001 Freelance Projects -- Automated Data Processing Portal

Latest Projects from Freelance Marketplaces

Today is: 01-May-2025 12:41 GMT

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)

Project	Started
Spanish Admins & Presidents	01-May-2025 09:21 GMT
Redesign cv	01-May-2025 09:21 GMT
Graphic Designer Specialising in Fashion Design	01-May-2025 09:08 GMT
BTRFS Hetzner EFI issu	01-May-2025 09:07 GMT
Infographic step by step guide on how to use our product.	01-May-2025 08:38 GMT
Gross Margin Specialist – COGS, Supplier & Efficiency Focus	01-May-2025 08:38 GMT
Playtest Our Indie Fishing Game (Windows PC)	01-May-2025 08:32 GMT
I need a back ground image for my app	01-May-2025 08:30 GMT
Wix Landing Page	01-May-2025 08:30 GMT
we need a human resources expert to help us sourcing candidates	01-May-2025 08:29 GMT
CLTV Growth Specialist – Ecom Retention & Loyalty Expert	01-May-2025 08:06 GMT
Creative Strategist – High-Performance Direct Response Ads	01-May-2025 07:55 GMT
Paid Ads Manager – CAC Recovery Specialist	01-May-2025 07:55 GMT
Senior Blockchain QA Engineer (DeFi & Digital Assets)	01-May-2025 07:54 GMT
Looking for a Google Ads Expert (Freelancer)	01-May-2025 07:51 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