|
|
|
|
|
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 |
Kids Video Logo Design -- 2
Category: Animation, Graphic Design, Illustration, Logo Design, Photoshop
Budget: $15 - $25 USD |
23 May 2025 21:57 GMT |
Multiple Mediation Analysis in SPSS
Category: Research, Research Writing, SPSS Statistics, Statistical Analysis, Statistics
Budget: $30 - $250 AUD |
23 May 2025 21:56 GMT |
PDF to Word Typing Task
Category: Copy Typing, Data Entry, Excel, PDF, Word
Budget: $15 - $25 AUD |
23 May 2025 21:55 GMT |
Remote Solar Appointment Setter (U.S. Market)
Category: Appointment Setting, Call Center, Lead Generation, Sales, Telemarketing
Budget: $2 - $8 USD |
23 May 2025 21:52 GMT |
YouTube Video Optimization & Shorts Creation -- 2
Category: Video Editing, Video Production, YouTube, YouTube Video Editing
Budget: $15 - $25 USD |
23 May 2025 21:51 GMT |
Excel Statistical Analysis Expert Needed
Category: Data Processing, Excel, SPSS Statistics, Statistical Analysis, Statistics
Budget: $10 - $30 USD |
23 May 2025 21:50 GMT |
Clothing Brand Logo Editor
Category: Graphic Design, Illustration, Logo Design, Photoshop, Photoshop Design
Budget: €8 - €30 EUR |
23 May 2025 21:44 GMT |
Minimalist Monochrome Logo Design
Category: Graphic Design, Illustration, Logo Design, Photoshop
Budget: $250 - $750 USD |
23 May 2025 21:42 GMT |
Social Media Entertainment Video Creator
Category: AI Content Creation, Content Creation, Graphic Design, Infographics, Video Editing
Budget: ₹1500 - ₹12500 INR |
23 May 2025 21:41 GMT |
AI-Powered Animated Story Video Website -- 2
Category: 3D Animation, Animation, PHP, Video Services, Web Design
Budget: ₹1500 - ₹12500 INR |
23 May 2025 21:41 GMT |
Gaming Competitor User Data Acquisition
Category: Data Entry, Data Mining, Data Processing, Web Scraping, Web Search
Budget: ₹600 - ₹1500 INR |
23 May 2025 21:40 GMT |
Realistic Pencil Portrait
Category: Caricature & Cartoons, Graphic Design, Illustration, Photoshop
Budget: $30 - $250 USD |
23 May 2025 21:39 GMT |
Car Rental App & Website Development
Category: Graphic Design, HTML, Mobile App Development, PHP, Web Design
Budget: ₹12500 - ₹37500 INR |
23 May 2025 21:38 GMT |
Automation Script Development
Category: JavaScript, PHP, Python, Software Architecture, Web Scraping
Budget: ₹12500 - ₹37500 INR |
23 May 2025 21:38 GMT |
Simple HTTPS Node.js Server Setup
Category: JavaScript, Linux, Node.js
Budget: $10 - $30 USD |
23 May 2025 21:38 GMT |
|
|
Browse All Projects
|
|
|
|
|
|
