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
Automatización de Notificaciones Urgentes
Category : Make Up, Notion, Python Budget : $30 - $250 USD
27-Jun-2025 22:04 GMT
Lead Generation for DTC Brands Specialist
Category : Data Entry, Excel, Internet Marketing, Leads, Web Search Budget : $30 - $250 USD
27-Jun-2025 22:02 GMT
Editkan foto saya
Category : Book Artist, Graphic Design, Illustration, Logo Design, Photo Editing, Photoshop, Photoshop Design, T Shirts Budget : $10 - $30 USD
27-Jun-2025 22:00 GMT
Fillable PDF Application Form to MS words -- 2
Category : Copy Typing, Excel, PDF, PHP, Word Budget : £18 - £36 GBP
27-Jun-2025 21:59 GMT
Artistic Video Editor for Urban Brand
Category : Adobe Premiere Pro, After Effects, Animation, Cinematography, Motion Graphics, Video Editing, Video Production Budget : €60 - €100 EUR
27-Jun-2025 21:56 GMT
Odoo SaaS Reseller Solution Development -- 2
Category : CRM, ERP, Odoo Budget : $250 - $750 USD
27-Jun-2025 21:54 GMT
Albanian-English Translation for Event
Category : English (UK) Translator, English (US) Translator, English Grammar, Malay Translator, Slovakian Translator, Translation Budget : €18 - €36 EUR
27-Jun-2025 21:50 GMT
3D Car Model Adjustment
Category : 3D Animation, 3D Modelling, 3D Rendering, 3ds Max, Solidworks Budget : £250 - £750 GBP
27-Jun-2025 21:50 GMT
Handwriting Authentication Expert Needed
Category : Criminal Law, Forensic Consulting, Legal Analysis, Legal Research Budget : $30 - $250 USD
27-Jun-2025 21:49 GMT
Full-Time Graphic Designer Needed
Category : Banner Design, Graphic Design, Illustration, Logo Design, Photoshop Budget : $250 - $750 USD
27-Jun-2025 21:46 GMT
Small Website Fixes and Responsive Adjustments (HTML/CSS)
Category : Bootstrap, CSS, CSS3, HTML, JavaScript, JQuery, PHP, SEO, Web Design, Website Management Budget : $30 - $250 USD
27-Jun-2025 21:44 GMT
Certified Bengali to English Legal Translation
Category : English (UK) Translator, Legal Budget : £20 - £250 GBP
27-Jun-2025 21:43 GMT
SEO Authority Boost for Parcel Service
Category : Link Building, SEO Budget : $30 - $250 USD
27-Jun-2025 21:42 GMT
Desarrollo video animado / voice over / Subtitulo - Presentación Producto Digital Contratación
Category : After Effects, Animation, Explainer Videos, Video Ads, Video Editing, Video Services, VideoHive, VideoScribe, Voice Talent Budget : $30 - $250 USD
27-Jun-2025 21:37 GMT
CS 1.6 Server Setup with Mods
Category : JavaScript, Linux, MySQL, PHP, Software Architecture Budget : £20 - £250 GBP
27-Jun-2025 21:34 GMT
Browse All Projects