phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

Automated Data Processing Portal

  • Posted:
  • Proposals: 18
  • Remote
  • #4349267
  • OPPORTUNITY
  • Awarded
Lieisan B.Ayomide J.FRIEDMAN T.Mayowa F.Leah S. + 13 others have already sent a proposal.
  • 6

Description

Experience Level: Expert
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!

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • James L.

    Hi,

    I’m interested in your project and would love to understand a few details to ensure I can provide the best solution. Could you please clarify the following?

    API & Data Handling
    Do Warm and Inflyte provide public APIs? If not, do you have API keys and documentation available?
    What specific data points need to be extracted from both platforms?
    Should the final processed data follow a specific format, or can adjustments be made for efficiency?
    Are there any transformation rules needed (e.g., renaming fields, aggregations, filtering)?
    Google Sheets & Data Storage
    How is the Google Sheet currently structured (tabs, column names, historical data handling)?
    Should old data be archived or overwritten, or should each update be appended to a new sheet?
    Would a database like PostgreSQL be preferable for performance, or do you prefer keeping everything in Google Sheets?
    Automation & User Interaction
    How often should the automation run—weekly at a fixed time, or should manual triggers be allowed?
    Would you like a user interface for viewing logs and triggering updates manually, or is full automation preferred?
    How should errors be reported (e.g., email, Slack notifications, logs in a dashboard)?
    Security & Hosting
    Who will have access to the system? Should authentication (admin login) be implemented?
    Where do you prefer to host the application (AWS, Google Cloud, Heroku)?
    Is the processed data sensitive, requiring encryption or access control?
    Budget & Timeline
    What is the expected deadline for this project?
    Is there flexibility in features based on feasibility and budget?
    Do you foresee future expansions, such as integrating more platforms or adding dashboards?
    Additionally, if possible, could you share sample files of the current data before and after processing? That would help in designing an optimal workflow.

    Looking forward to your insights! Happy to discuss further and provide my suggested approach.

    Kind regards,
    James

  • Muhammad A.

    Please confirm if you have access to the APIs for both Warm and Inflyte or if authentication setup is required.
    Would you like the system to support historical data retrieval, or should it only process new entries going forward?
    Do you have any preferences for how error notifications should be handled (e.g., email, Slack, or a dashboard alert)?
    Looking forward to hearing from you soon.