|
|
|
|
|
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 |
Business Development and Digital Presence for Sustainable Farming
Category: Facebook Marketing, Graphic Design, Logo Design, Social Media Marketing, Web Design
Budget: $500 - $1000 USD |
10-Jun-2025
12:17 GMT |
Fix React Native App Build issue
Category: Android, IOS Development, Mobile App Development, React Native, Swift
Budget: $10 - $30 USD |
10-Jun-2025
09:57 GMT |
bisnis marketing
Category: Business Development, Customer Retention Marketing, Entrepreneurship, Internet Marketing, Web Design
Budget: ₹100 - ₹400 INR |
10-Jun-2025
09:55 GMT |
recruit Chinese people in Malaysia as assistants
Category: Admin Support, English (UK) Translator, Odd Jobs
Budget: $250 - $750 USD |
10-Jun-2025
09:54 GMT |
Teams app plugin for users, join teams meeting calls, use third party recording from within the plugin relay the audio to azure speech service backend in real time transcribe, translate and convert to vernacular languages speech to text, text to text, for
Category: Audio Services, Microsoft Access, Microsoft Azure
Budget: ₹12500 - ₹37500 INR |
10-Jun-2025
09:54 GMT |
CONFIDENTIAL -- 2
Category: Atlassian Jira, Data Warehousing, GitLab, Snowflake, SQL
Budget: ₹12500 - ₹37500 INR |
10-Jun-2025
09:54 GMT |
3D CAD to CAM Conversion
Category: 3D Modelling, 3D Rendering, CAD / CAM, Fusion 360, Mechanical Engineering
Budget: £20 - £250 GBP |
10-Jun-2025
09:53 GMT |
English Teaching Landing Page + telegram bot setup
Category: Graphic Design, HTML, JavaScript, PHP, Web Design
Budget: €250 - €750 EUR |
10-Jun-2025
09:53 GMT |
Traditional Wedding Photography Specialist
Category: Graphic Design, Illustration, Photo Editing, Photography, Photoshop
Budget: ₹1500 - ₹12500 INR |
10-Jun-2025
09:53 GMT |
Customer Management Online System Development
Category: AJAX, HTML, JavaScript, MySQL, PHP
Budget: $250 - $750 USD |
10-Jun-2025
09:52 GMT |
Properly hashtag.attractive content use
Category: Article Writing, Content Writing, Copywriting, Ghostwriting, Social Media Marketing
Budget: ₹1500 - ₹12500 INR |
10-Jun-2025
09:52 GMT |
Romantic Short Poem
Category: Creative Writing, EBooks, Fiction, Ghostwriting
Budget: ₹12500 - ₹37500 INR |
10-Jun-2025
09:52 GMT |
SEO Backlink Campaign -- 3
Category: Internet Marketing, Link Building, Marketing, Search Engine Marketing (SEM), SEO
Budget: €30 - €250 EUR |
10-Jun-2025
09:51 GMT |
Professional Video Ad Creation
Category: 3D Animation, After Effects, Animation, Video Editing, Video Services
Budget: ₹1500 - ₹12500 INR |
10-Jun-2025
09:51 GMT |
Modern, Vibrant Personal Logo
Category: Graphic Design, Illustration, Logo Design, Photoshop, Photoshop Design
Budget: $30 - $250 USD |
10-Jun-2025
09:50 GMT |
|
|
Browse All Projects
|
|
|
|
|
|
