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
Brand & Recruitment Content Creation
Category : Branding, Content Creation, Content Writing, Copywriting, Creative Writing, Photography, Video Production, Video Services Budget : $250 - $750 USD
18 Mar 2026 17:03 GMT
Update existing living room
Category : 3D Modelling, 3D Rendering, 3D Visualization, Architectural Rendering, Architectural Visualization, Furniture Design, Graphic Design, Home Design, Interior Design, Lighting Design Budget : $30 - $250 USD
18 Mar 2026 17:01 GMT
Long-Term WordPress Technical Maintenance Specialist
Category : Technical Support, Web Hosting, Web Security, WordPress Budget : €250 - €750 EUR
18 Mar 2026 17:00 GMT
Fix WordPress Shipper Integration
Category : API Integration, HTML, PHP, Web Development, WooCommerce, WordPress Budget : €8 - €30 EUR
18 Mar 2026 17:00 GMT
Waterproof Mattress Pad Hero Image
Category : 3D Animation, 3D Modelling, 3D Rendering, Graphic Design, Photography, Photoshop, Product Photography, Visual Design Budget : $10 - $30 USD
18 Mar 2026 17:00 GMT
Heat Exchanger Failure Assessment Report
Category : Documentation, Legal Consultation, Technical Writing Budget : $250 - $750 USD
18 Mar 2026 16:59 GMT
Dynamic Legal Firm Website & Content Creation
Category : Content Writing, HTML, JavaScript, PHP, SEO, UI / User Interface, Web Design, WordPress Budget : ₹1500 - ₹12500 INR
18 Mar 2026 16:59 GMT
Καταχώρηση προϊόντων και βελτίωση WordPress site
Category : CSS, HTML, PHP, Web Design, WordPress Budget : €750 - €1500 EUR
18 Mar 2026 16:59 GMT
Standard Transformers Cookie Cutters
Category : 3D CAD, 3D Design, 3D Modelling, 3D Printing, CAD / CAM, Graphic Design, Logo Design, Product Design Budget : $10 - $30 USD
18 Mar 2026 16:58 GMT
Building Sign Mockup and Photo edit
Category : Photoshop, Building Design, Design, Graphic Design, Illustration, Photo Editing, Photoshop Design, Typography, Visual Design Budget : $30 - $250 USD
18 Mar 2026 16:56 GMT
Wearable Grooming Guide CAD Prototype -- 2
Category : 3D CAD, 3D Design, 3D Modelling, 3D Print Design, 3D Printing, 3D Rendering, 3D Visualization, Fusion 360, Mechanical Engineering, Solidworks Budget : $250 - $750 USD
18 Mar 2026 16:56 GMT
Ad for magazine - 18/03/2026 12:55 EDT
Category : Advertisement Design, Advertising, Canva, Content Creation, Graphic Design, Social Media Management Budget : $30 - $250 CAD
18 Mar 2026 16:55 GMT
Google Sheets Stock Entry
Category : Data Analysis, Data Entry, Data Management, Excel, Google Sheets, Inventory Management, Visual Basic Budget : ₹600 - ₹1500 INR
18 Mar 2026 16:54 GMT
Startup Full-Stack Hiring Advisor
Category : Agile Development, Full Stack Development, Interviewing, Project Management, Software Development, Software Engineering, Startup Consulting, Technical Writing Budget : £18 - £36 GBP
18 Mar 2026 16:54 GMT
Wearable Grooming Guide CAD Prototype
Category : 3D CAD, 3D Design, 3D Modelling, 3D Print Design, 3D Printing, 3D Rendering, 3D Visualization, Fusion 360, Mechanical Engineering, Solidworks Budget : $250 - $750 USD
18 Mar 2026 16:52 GMT
Browse All Projects