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
WordPress Setup and Modify
Category : HTML, PHP, Web Design, Web Development, WordPress, WordPress Design, WordPress Plugin Budget : $30 - $250 USD
04-Aug-2025 10:04 GMT
Experienced Excel VBA Developer Needed for Stable Add-in with Multi-Select Dropdown (Workbook-Specific)
Category : Data Processing, Excel, Excel Macros, Office 365, Performance Tuning, Troubleshooting, Visual Basic, Visual Basic For Apps Budget : £20 - £250 GBP
04-Aug-2025 10:03 GMT
Flash to Mobile Game Conversion
Category : 2D Game Art, Android, Game Design, Game Development, Godot, IOS Development, IPhone, Mobile App Development, Unity, Unity 3D Budget : $10 - $100 USD
04-Aug-2025 10:03 GMT
Virtual Assistant for Photo Editing
Category : Adobe Creative Cloud, Photoshop, Graphic Design, Photo Editing, Photography, Project Management, Time Management, Virtual Assistant Budget : $2 - $8 USD
04-Aug-2025 10:03 GMT
Instagram Branding & Growth Specialist
Category : Branding, Content Creation, Content Strategy, Facebook Marketing, Instagram Marketing, Internet Marketing, Social Media Management, Social Media Marketing, Twitter, Visual Design Budget : ₹12500 - ₹37500 INR
04-Aug-2025 10:03 GMT
Twitter Account Manager – Digital Marketing Agency
Category : Brand Management, Content Marketing, Digital Marketing, Influencer Marketing, Marketing Strategy, Social Media Management, Social Media Marketing, Twitter Marketing Budget : ₹1500 - ₹12500 INR
04-Aug-2025 10:02 GMT
WordPress/WooCommerce Master to fix high TTFB & LCP issues
Category : Debugging, JavaScript, MySQL, PHP, Web Development, Website Optimization, WooCommerce, WordPress Budget : $10 - $50 AUD
04-Aug-2025 10:01 GMT
Pixel Art Game Asset Creation
Category : 2D Animation, 2D Game Art, Game Art, Game Design, Graphic Design, Illustration, Pixel Art Budget : €10 - €500 EUR
04-Aug-2025 10:01 GMT
Stock Price Trend Analysis
Category : Data Analysis, Data Management, Data Visualization, Financial Analysis Budget : $30 - $250 USD
04-Aug-2025 10:01 GMT
Classic Elegant Logo Design
Category : Adobe Illustrator, Photoshop, Branding, Creative Design, Graphic Design, Illustration, Logo Design Budget : ₹750 - ₹1250 INR
04-Aug-2025 10:00 GMT
Comprehensive Website Redesign
Category : Content Management System (CMS), Graphic Design, HTML, PHP, User Experience Research, Visual Design, Web Design, Web Development, Website Accessibility Budget : ₹12500 - ₹37500 INR
04-Aug-2025 10:00 GMT
Looker Studio Dashboard UI/UX Design
Category : Google Data Studio, Photoshop, UI / User Interface, User Interface / IA, UX / User Experience, Web Design Budget : $10 - $30 USD
04-Aug-2025 10:00 GMT
Build Ayurveda Clinic Website with Integrations
Category : Graphic Design, HTML, Payment Gateway Integration, PHP, Social Media Marketing, Web Design, Web Development Budget : ₹1500 - ₹12500 INR
04-Aug-2025 10:00 GMT
Woocommerce Website Fixes and Updates
Category : Backend Development, CSS, HTML, PHP, Web Development, Web Security, Web Design, WooCommerce, WordPress Budget : ₹12500 - ₹37500 INR
04-Aug-2025 09:59 GMT
Angular Firebase Laravel User Management
Category : Angular, CSS, HTML, Laravel, Node.js, PHP, RESTful Budget : €250 - €750 EUR
04-Aug-2025 09:59 GMT
Browse All Projects