|
|
|
|
|
Project title: |
Automate & Rebrand Google/Excel Pricing Feed with 15% Mark-Up
|
|
Posted by: |
External project from PeoplePerHour
|
|
Started: |
13-May-2025 11:00 GMT |
|
Description: |
Project Overview
We maintain a live pricing feed in an online Excel/Google Sheets file and need a seamless solution to:
Detect Changes immediately when the source file updates.
Copy & Rebrand into our own spreadsheet (logos, headers, formatting).
Apply a 15% Mark-Up to all price cells (configurable).
Keep Everything in Sync—new rows, removed items, renamed columns—every time.
What You’ll Deliver
Automated Watcher: A trigger or cron-based solution (Google Apps Script, Power Automate, Python, etc.) that fires on file-change or on a schedule.
Branded Copy: A live copy of the source file in our workspace, complete with our branding and formatting.
Data Transformation: +15% mark-up applied to every price cell, with numeric precision and configurability.
Robust Sync Logic: Handles additions, removals, renamed columns, and intermittent API errors.
Notifications & Error-Handling: Alerts via email or Slack only if a sync fails.
Documentation & Handover: Clear setup guide covering deployment, parameter tweaks, and ongoing maintenance.
What You’ll Deliver
Automated Watcher: A trigger or cron-based solution (Google Apps Script, Power Automate, Python, etc.) that fires on file-change or on a schedule.
Branded Copy: A live copy of the source file in our workspace, complete with our branding and formatting.
Data Transformation: +15% mark-up applied to every price cell, with numeric precision and configurability.
Robust Sync Logic: Handles additions, removals, renamed columns, and intermittent API errors.
Notifications & Error-Handling: Alerts via email or Slack only if a sync fails.
Documentation & Handover: Clear setup guide covering deployment, parameter tweaks, and ongoing maintenance.
Skills & Experience
Solid experience with Google Apps Script or Microsoft Power Automate or Python (using Google Drive/Office 365 APIs)
Proven track record of building reliable, change-driven workflows for Excel Online/Google Sheets
Expertise in data transformation, error handling, and API-based automation
Strong communicator in English, with proactive troubleshooting and clear documentation
Timeline & Budget
Start: Within 3 business days of award
Delivery: Fully deployed and tested within 1–2 weeks
Budget: Please quote your hourly rate (or fixed price) and an estimated total |
|
Project ID:
|
3432454 |
|
Project category: |
|
|
Project budget: |
|
|
|
|
|
|
| Project |
Started |
|
MYHCA - Make Your Hands Clean Again .... a bit of fun!
|
01-Nov-2025
14:51 GMT |
|
Tech pack.
|
01-Nov-2025
14:49 GMT |
|
Pine script for TradingView
|
01-Nov-2025
13:24 GMT |
|
I want a poster created
|
01-Nov-2025
12:46 GMT |
|
Responsive HTML Email Developer for Gmail & Outlook
|
01-Nov-2025
12:46 GMT |
|
Increase TikTok Following
|
01-Nov-2025
12:34 GMT |
|
DevOps Engineer Needed: Self-Host Supabase on Ubuntu VPS
|
01-Nov-2025
12:30 GMT |
|
Technical User Manual Creation
|
01-Nov-2025
11:10 GMT |
Bilingual Tech CV Revamp
Category: Artificial Intelligence, Editing, Graphic Design, Language Tutoring, Proofreading, Technical Writing, Web Development, Word Processing
Budget: $10 - $30 USD |
01-Nov-2025
11:04 GMT |
Telugu Tech Tutor Needed
Category: Artificial Intelligence, Blockchain, Data Science, Generative AI, Internet Of Things (IoT), Machine Learning (ML), Natural Language Processing, Quantum Computing
Budget: ₹600 - ₹1500 INR |
01-Nov-2025
11:04 GMT |
Premium Photo Retouching Needed
Category: Adobe Lightroom, Photoshop, Background Removal, Image Processing, Photo Retouching, Photoshop Design
Budget: $250 - $750 USD |
01-Nov-2025
11:04 GMT |
Estudio acústico simplificado para generador electrógeno según normativa específica
Category: Cartography & Maps, Sound Engineering
Budget: €40 - €80 EUR |
01-Nov-2025
11:04 GMT |
Odoo Module Tweaks & Fixes
Category: ERP, Git, Odoo, PHP, Python, Software Architecture, Software Development, XML
Budget: ₹400 - ₹750 INR |
01-Nov-2025
11:04 GMT |
Wardrobe Essentials Style Advisor
Category: Fashion Consulting, Fashion Design, Fashion Modeling, Fashion Writing, Textile Design
Budget: $2 - $8 USD |
01-Nov-2025
11:02 GMT |
Business Partner / Investment Opportunity in Distribution Business - 01/11/2025 06:46 EDT
Category: Business Analysis, Business Development, Business Management, Business Strategy, Project Management
Budget: $10 - $30 USD |
01-Nov-2025
11:02 GMT |
|
|
Browse All Projects
|
|
|
|
|
|
