|
|
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 |
Verify Titles and Organizations
Category: Data Entry, Excel, Research, Web Scraping, Web Search Budget: $10 - $30 USD |
04-Jun-2025 04:04 GMT |
Business Info Website Development
Category: CSS, HTML, Laravel, PHP, Web Design Budget: ₹12500 - ₹37500 INR |
04-Jun-2025 04:03 GMT |
Tamil Interview Transcription
Category: Audio Services, Transcription Budget: ₹600 - ₹1500 INR |
04-Jun-2025 04:03 GMT |
Medical Influencer Promotion
Category: Facebook Marketing, Internet Marketing, Pinterest, Social Media Marketing, Twitter Budget: $10 - $30 USD |
04-Jun-2025 04:02 GMT |
3D Animated Summer Course Ad
Category: 3D Animation, After Effects, Animation, Graphic Design, Video Services Budget: $30 - $250 USD |
04-Jun-2025 04:01 GMT |
Sistema web tipo Simples Dental (agenda + odontograma + financeiro) com licença vitalícia
Category: Graphic Design, HTML, Logo Design, PHP, Web Design Budget: $30 - $250 USD |
04-Jun-2025 03:59 GMT |
Mobile Display Fix for Tribute Wall
Category: CSS, HTML, HTML5, JavaScript, Web Design Budget: $30 - $250 USD |
04-Jun-2025 03:59 GMT |
AI Bitcoin Signal Model Development
Category: Algorithm, Java, Mathematics, Python, Software Architecture Budget: $30 - $250 USD |
04-Jun-2025 03:59 GMT |
Chinese Interpreter for Business Meeting in Delhi
Category: Simplified Chinese Translator, Traditional Chinese (Taiwan) Budget: $250 - $750 USD |
04-Jun-2025 03:58 GMT |
Realistic Lambo Bull & LS Logo
Category: Fashion Design, Graphic Design, Illustration, Logo Design, Photoshop Budget: $30 - $250 USD |
04-Jun-2025 03:58 GMT |
Bot de telegram
Category: Programming, Python Budget: $30 - $250 USD |
04-Jun-2025 03:58 GMT |
Hyperviser memory reader (ring -1)
Category: C++, Programming, Software Architecture Budget: $30 - $250 USD |
04-Jun-2025 03:58 GMT |
AWS EC2 Problems: CraftCMS & Temp Folders
Category: Amazon Web Services, Linux, MySQL, PHP, System Admin Budget: ₹1500 - ₹12500 INR |
04-Jun-2025 03:58 GMT |
Mobile Exterior Car Wash
Category: 3D Modelling, 3D Rendering, 3ds Max, Building Architecture, Car Washing Budget: ₹600 - ₹1500 INR |
04-Jun-2025 03:56 GMT |
Meal Plans Editing for Weight Loss
Category: Business Plans, Content Writing, Copywriting, Editing, Proofreading Budget: ₹12500 - ₹37500 INR |
04-Jun-2025 03:56 GMT |
|
Browse All Projects
|
|
|
|
|