|
|
|
|
|
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 |
Shopify Site Revamp
Category: Graphic Design, HTML, Shopify, Shopify Templates, Web Design
Budget: $250 - $750 USD |
01-Jun-2025
10:04 GMT |
Upgrade & Extension of Hotel Management Software
Category: .NET, C#, Programming, PHP, Software Architecture, VB.NET
Budget: $250 - $750 USD |
01-Jun-2025
10:04 GMT |
Logo Creation and PowerPoint Redesign
Category: Graphic Design, Illustration, Logo Design, Photoshop, Powerpoint
Budget: $30 - $250 AUD |
01-Jun-2025
10:04 GMT |
Ready-Made Uber-Like App Development
Category: Graphic Design, IPhone, Mobile App Development, User Interface / IA, Web Design
Budget: $250 - $750 USD |
01-Jun-2025
10:03 GMT |
Global Car Rental Affiliate Sales
Category: Leads, Marketing, Sales, Sales Account Management, Telemarketing
Budget: $750 - $1500 USD |
01-Jun-2025
10:03 GMT |
Node.js E-commerce Web App
Category: API Development, Backend Development, JavaScript, MySQL, Node.js
Budget: ₹1500 - ₹12500 INR |
01-Jun-2025
10:02 GMT |
Travel & Lifestyle Content Creator
Category: Article Writing, Ghostwriting, SEO
Budget: ₹600 - ₹1500 INR |
01-Jun-2025
10:02 GMT |
Binary Options Trading Bot in Python – Non-Repaint Signals, 85% Win Rate
Category: Machine Learning (ML), Python, Software Architecture
Budget: $30 - $250 USD |
01-Jun-2025
10:02 GMT |
Creative Personal Website Development
Category: Graphic Design, HTML, PHP, Web Design, WordPress
Budget: $8 - $15 USD |
01-Jun-2025
10:01 GMT |
Collect 7 Years of Investor Documents for 25 Public Companies (Fixed ₹4,000 Project)
Category: Data Entry, Excel, Financial Markets, Internet Research, Web Search
Budget: ₹1500 - ₹12500 INR |
01-Jun-2025
10:00 GMT |
Integrate Anti-Malware for WordPress
Category: CSS, PHP, Web Security, WordPress
Budget: €8 - €30 EUR |
01-Jun-2025
09:58 GMT |
Raster to Vector Conversion
Category: Graphic Design, Illustration, Logo Design, Photoshop
Budget: $2 - $8 AUD |
01-Jun-2025
09:58 GMT |
Copy Typing Handwritten Notes
Category: Copy Typing, Excel, PDF, Word
Budget: ₹12500 - ₹37500 INR |
01-Jun-2025
09:55 GMT |
Natural NSFW Photo Enhancement
Category: Adobe Lightroom, Photo Editing, Photography, Photoshop, Photoshop Design
Budget: $10 - $30 USD |
01-Jun-2025
09:54 GMT |
Graphic Design for Packaging
Category: Brochure Design, Corporate Identity, Covers & Packaging, Graphic Design, Illustration
Budget: $25 - $50 USD |
01-Jun-2025
09:53 GMT |
|
|
Browse All Projects
|
|
|
|
|
|
