Optimize Upwork Searches with Google Sheets

I need someone to make an excel spreadsheet of mine dynamic. I have a list of events and 2026 calendar however when I change the list of events, it doesn't change where the event is plotted on the calendar.

HOUSEHOLD OPEN ITEMS & TASK CONTROL SYSTEM

(Single Source of Truth)

1️⃣ MASTER OPEN ITEMS LIST (Command Center)

This is where EVERYTHING starts.
If it’s not here, it doesn’t exist.

MASTER OPEN ITEMS LOG
ID Category Task / Issue Location Owner Priority Status Due Notes
001 Maintenance Pool light not working Backyard Tony High Open 12/14 Suspect blown fuse
002 Housekeeping Deep clean pantry Main House Mary Ann Medium In Progress 12/16 Schedule crew
003 Vendor Elevator service Garage Jackson High Waiting Vendor 12/15 Called Otis
004 Admin Review AP invoices Office Jackson Medium Open Friday Weekly task

Statuses (keep tight):

Open

In Progress

Waiting Vendor

Waiting Approval

Completed

Closed

✅ Rule: Nothing is deleted — it moves to Closed.

2️⃣ DAILY TASK LIST (Execution Only)

Pulled from the Master List each morning.

DAILY EXECUTION LIST

Date: ___________

☐ Review Master Open Items
☐ Assign new tasks
☐ Follow up on waiting vendors
☐ Verify yesterday’s completions
☐ Add any new issues discovered

Today’s Focus Tasks

☐ ____________________________________

☐ ____________________________________

☐ ____________________________________

End-of-Day Check
☐ Update task statuses
☐ Move completed → Closed
☐ Add notes / blockers

3️⃣ WEEKLY HOUSEHOLD OPS LIST (Manager View)

Used for Friday review or boss updates.

WEEKLY OPERATIONS SUMMARY

Week of: ___________

Completed This Week

☐ ____________________________________

☐ ____________________________________

Still Open / At Risk

☐ ____________________________________

☐ ____________________________________

Waiting On Others

☐ Vendor: _____________________________

☐ Approval: ___________________________

Next Week Priorities

☐ ____________________________________

☐ ____________________________________

4️⃣ CATEGORY BUCKETS (So Nothing Gets Lost)

Every task must live in one bucket:

Core Categories

Maintenance / Repairs

Grounds / Exterior

Housekeeping

Vendors

Vehicles

Security

Admin / AP / Paperwork

Projects (Renovation, Design, Moves)

Events / Travel

This keeps chaos from mixing.

5️⃣ SIMPLE SYSTEM RULES (This Is What Makes It Work)

Rule 1: One master list only
Rule 2: If someone tells you something → log it immediately
Rule 3: Every task has ONE owner
Rule 4: Status must change weekly
Rule 5: Closed tasks stay archived (proof)

6️⃣ HOW TO SET THIS UP (Fast)
Option A: Google Sheets / Excel (Best)

Tab 1: Master Open Items

Tab 2: Daily Tasks

Tab 3: Weekly Ops

Tab 4: Closed Archive

Option B: Notion

Database with filters:

“Open”

“Waiting Vendor”

“This Week”

Clean dashboard view

Option C: Printed + Laminated (Backup)

Daily checklist (dry erase)

Weekly ops sheet (signed)

7️⃣ WHY THIS WORKS (Important)

Creates accountability

Protects you with documentation

Stops verbal chaos

Makes the household run without you chasing

Gives you leverage + clarity

If you want, next I can:

JOB TITLE

Manual Web Research: U.S. Jury Duty Administration (States & Counties)

JOB DESCRIPTION

I am looking for a freelancer to perform manual public-sector web research to build a comprehensive contact database for jury duty administration across the United States.

This is not lead generation, skip tracing, or scraping. Accuracy, source verification, and understanding of government structure are critical.

PROJECT OVERVIEW

Jury duty management in the U.S. is not uniform.
While District Clerks handle jury duty in many Texas counties, other states and counties use different offices, including:

State Office / Administrative Office of the Courts (OCA / AOC)

County Clerk

Jury Commissioner

Court Administrator

Clerk of Court or equivalent court-designated office

The task is to identify the actual office responsible in each jurisdiction and collect verified contact information for the person in charge.

SCOPE OF WORK (IN THIS ORDER)
1. All 50 U.S. States

For each state, determine:

How jury duty is managed (state-level, county-based, or hybrid)

Official office name

Person in charge (PIC) full name

PIC title

Email address (if publicly listed)

Phone number

Official source link (government or court website)

Brief notes if structure is unusual

2. Top 500 U.S. Counties (Population > 100,000)

For each county:

State

County name

Office managing jury duty (District Clerk, County Clerk, Jury Commissioner, Court Administrator, etc.)

Official office name

PIC full name

PIC title

Email (if publicly listed)

Phone number

Jury duty webpage link

Contact page link

Notes where applicable

3. Remaining ~2,700 Counties

Same fields and requirements as above.

Municipal courts and cities are not included at this stage.

DATA REQUIREMENTS (VERY IMPORTANT)

Manual research only. No scraping, bots, scripts, or automation.

Use official sources only:

.gov

.us

Official state or county court websites

No guessing names, titles, or emails.

If an email is not publicly listed, enter “Not listed” and provide:

Official phone number

Official webpage link

Do not default to “District Clerk” unless explicitly confirmed by an official source.

Every row must include at least one official source link.

DELIVERABLE

Google Sheets or Excel format

One row per jurisdiction

Clean, consistent formatting

Clear column headers

No duplicates

Source links included for every entry

QUALITY EXPECTATIONS

Accuracy is more important than speed

Data will be spot-checked against official sources

Revisions required for incorrect assumptions or missing sources

REQUIRED SKILLS

Web research

Government / public records research

Attention to detail

Ability to follow structured data rules

PLEASE CONFIRM IN YOUR BID

You understand jury duty administration varies by state and county

You will use manual research only

You will not guess missing information

You can provide official source links for every entry

BUDGET & TIMELINE

Please propose:

Total cost for full scope

Estimated timeline

Any recommended milestone breakdown

Final note

This is a large, detail-oriented research project. If completed accurately, there is potential for ongoing work.

Skills: Data Entry, Research, Excel, Web Search, Data Analysis, Google Sheets, Database Management, Data Collection

We have a nearly complete automation system built for a fitness business.
The system uses:

- Make.com (all flows + integrations)
- WATI for WhatsApp
- ManyChat for Instagram
- Node.js backend
- OpenAI Assistants API
- GymMaster API
- Google Sheets for storage

The system basically works, but it is not stable - there are recurring bugs, crashes, and inconsistencies that need to be fixed. We need a strong developer to take over, stabilise everything, and finish the remaining logic.

This is not a rebuild.
This is a takeover + bug fix + stabilisation project.

Your Responsibilities

You will:

- Audit all Make.com scenarios + modules
- Fix failing webhooks, filters, and Assistant calls
- Stop scenario crashes (400 errors, invalid events, story replies, etc.)
- Ensure the system always returns stable responses
- Finalise reminders + review follow-up logic in Make.com
- Sync GymMaster bookings reliably
- Improve error handling + filtering
- Migrate the Instagram flow from ManyChat → WATI
- Test everything end-to-end and deliver a stable production system

Goal: A clean, reliable automation system that never breaks.

Required Skills

You must have strong experience with:

- Make.com (advanced level) – routers, filters, webhooks, error handling
- WATI API + webhooks
- Node.js (modify existing backend logic, not rebuild)
- Debugging and repairing systems built by other developers
- API integrations & JSON troubleshooting
- Chatbot logic

Goal: complete stabilisation quickly and efficiently

To Apply - Answer These Questions

- What experience do you have with Make.com, specifically with routers, filters, and complex webhooks?

- Have you taken over systems built by other developers?

- Are you comfortable modifying a Node.js backend?

- Send examples of previous automation or integration work.

Notes

- We don't need a rebuild.
- We need someone who can debug, stabilise, and finish the system so it performs reliably under real user behaviour.

If you can take over and deliver quickly, we want to work with you.

Skills: Debugging, Node.js, Backend Development, Automation, API Integration, Make.com

I need a tool to batch process 500+ auction lot photos at once.

THE TASK:
For each image:
1. Extract/detect lot number (or mark as "NOT FOUND")
2. Identify high-value items ($50+ retail value)
3. Generate SEO-optimized title (80 chars) and description (2-4 paragraphs)
4. Export results to CSV

TECHNICAL APPROACH:
You choose the best tech stack, AI tools, and implementation.
I don't care how you build it - just that it works and is user-friendly.

REQUIREMENTS:
- Batch upload interface (accept 500+ images at once)
- Process images and return structured data
- Export to CSV ready for our auction platform
- Handle errors gracefully
- Include progress tracking

PHASES:
1. MVP: Single image → lot number + title + description + CSV export
2. Batch: Handle 500+ images, progress tracking
3. Polish: Documentation, testing, deployment

WHAT I PROVIDE:
- Sample pallet photos
- Example prompts (showing what good output looks like)
- Clear success criteria
- Feedback during development

HOW TO APPLY:
1. Propose your approach (what tools/tech you'll use)
2. Estimated timeline for each phase
3. Any clarifying questions
4. Portfolio link (batch processing, automation, or relevant projects)

ABOUT THE BUSINESS:
Auction house processing 1,000+ lots weekly. Each lot has 5 to 70 photos.
I'm thinking about using Google Sheets + Make.com + Claude but not complete at this time.

This will be a production system used by my team to speed up cataloging
and improve auction descriptions.

START: ASAP
CONTACT: Todd

Sports Data Engineer / Analytics Freelancer (Data Cleaning & Structuring)

We are building a long-term sports analytics system and are looking for an additional freelancer to assist with cleaning, structuring, and preparing historical sports data for automation and Google Sheets use.

Current context:
We are currently reviewing a proposal from an existing freelancer and are reposting this job to compare scope, structure, timelines, and pricing before proceeding.

Sports & Years:
• NFL (2012–2024)
• NBA (2014–2024)
• Tennis (2015–2024)

What we need help with:
• Cleaning and structuring historical datasets
• Standardizing column names and formats
• Ensuring consistent team / opponent / game identifiers
• Applying basic mechanical formulas only (rates, margins, differentials — no modeling or interpretation)
• Delivering datasets that are automation-ready for Google Sheets and future scripting

What we are NOT asking for:
• No predictive modeling
• No betting strategy
• No interpretation or weighting logic

Deliverables:
• Clean CSV or Google-Sheets-ready files
• Pricing broken down by sport or task
• Estimated timeline
• Relevant examples of similar data work (if available)

This is a long-term project with potential ongoing work.

Skills: Data Processing, Excel, Analytics, Data Analysis, Google Sheets, Data Management

Job Title: Community Operations Coordinator (Ambassador Program)

Overview:
We are seeking a highly organized, detail-oriented Community Operations Coordinator to help manage and optimize our rapidly growing ambassador program. This role will focus on vetting and onboarding ambassador applications, maintaining accurate tracking, and managing the ambassador journey pipeline. The ideal candidate is someone who thrives in processes, loves spreadsheets, and has experience with community management — particularly on Facebook.

Key Responsibilities:

Review Ambassador Applications: Vet incoming ambassador applications based on set criteria, making decisions on acceptance or rejection with minimal oversight.

Onboarding & Welcome Packets: Send personalized onboarding messages, ensuring that new ambassadors feel welcomed and integrated.

Maintain Ambassador Pipeline: Track and update the journey of each ambassador in our spreadsheet, noting key steps such as email response, group join status, T-shirt delivery, and more.

Facilitate Ambassador Engagement: Monitor ambassador activity in the Facebook group, answer common questions (within a specific scope), and help maintain group energy.

Track Ambassador Sales & Performance: Regularly update sales and engagement metrics, ensuring all information is captured accurately in our dashboard.

Support Ambassador Journey: Ensure that each ambassador is moving smoothly through the onboarding process and that no one is left behind.

Facilitate Logistics for Challenges & Missions: Assist with the logistics and communication of ongoing ambassador challenges, ensuring they are organized and run smoothly.

Report Creation: Create weekly reports detailing ambassador performance, including response rates, sales performance, and group engagement metrics.

What We’re Looking For:

Experience with Facebook Community Management: Experience in managing, moderating, or supporting Facebook communities is required.

Organizational Skills: A passion for organization, tracking, and streamlining processes. Must be comfortable with spreadsheets (Google Sheets, Excel) and comfortable creating and maintaining new workflows.

Process-Driven: You love following SOPs and creating new ones. You’ll be helping build and refine ambassador processes for long-term growth.

Strong Communicator: You must be fluent in English and have excellent written communication skills.

Adaptability & Cultural Sensitivity: Must be able to relate to and support a niche, passionate community in the hunting and coffee culture.

Attention to Detail: Meticulous tracking of ambassador pipeline to ensure accuracy and follow-through.

Bonus Points: Familiarity with Shopify (or similar platforms) is a plus but not required.

Position Details:

Hours: 20–30 hours per week, with potential to increase based on growth.

Location: Remote (must be able to communicate in English).

Compensation: $8–$25/hr depending on experience and skill level.

How to Apply:
Please submit a proposal with:

A brief cover letter explaining why you’re a good fit for this position.

Examples of your past experience managing community operations or ambassador programs.

A link to your previous work managing communities or any relevant case studies.

Ideal Candidate Profile:

Skills & Experience:

Community management on Facebook

Highly organized and process-driven with strong spreadsheet skills

Excellent written English communication

Comfortable working in a remote, self-managed environment

Experience with Shopify (preferred, not required)

Proven track record of managing ambassador programs or similar roles

Cultural Fit:

We need someone who values structure, loves efficiency, and thrives on organization. You must be adaptable to a niche community with a strong culture of passion and authenticity.

If you’re meticulous, reliable, and love building seamless processes for a growing program, we’d love to hear from you!

I’m looking for someone who can jump straight onto the phones and turn cold contacts into confirmed consultation slots on my calendar. The focus is simple: reach out, qualify interest quickly, and lock in a time for a one-on-one consultation with individuals who fit my service profile.

Here’s how the workflow will look: I’ll supply a contact list, a brief overview of the service, and a suggested call script. You’ll handle the dialing, refine the conversation to suit your own style, track each interaction in a shared Google Sheet or CRM, and confirm appointments using my Calendly link.

Success is measured by the number of consultations booked and the accuracy of the notes you leave after each call—call disposition, key objections, and any follow-up actions. If you have a proven track record in cold calling, solid English communication, and the persistence it takes to turn “maybe” into “yes,” I’d love to hear how many appointments you can realistically secure each week and the tools you prefer to use.

Skills: Telemarketing, Sales, Customer Support, CRM, Call Center, Google Sheets, Lead Generation, Appointment Setting

I need an experienced Funnel.io specialist to pull lead data, campaign performance, and email analytics from Salesforce Marketing Cloud Account Engagement (Pardot) into Funnel.io, transform it as needed, and present the results in clear dashboards. Once the pipelines are running smoothly, I also want polished reports generated inside Funnel.io so stakeholders can drill down into any metric without leaving the platform.

Key deliverables:
• Robust Funnel.io connections to Pardot for the three data sets mentioned above
• Automated transformations that keep naming conventions and time zones consistent
• A shareable Funnel.io dashboard with at-a-glance insights and the ability to filter by date range and campaign
• Recurring reports scheduled directly from Funnel.io in PDF and Google Sheets formats

I will provide API access to Pardot and a clean Funnel.io workspace. Success is measured by zero-error data refreshes over a one-week test period, dashboard load times under five seconds, and reports that match Pardot totals within one percent.

Skills: Salesforce.com, Data Analytics, Data Integration, Salesforce Marketing Cloud, Funnel, API Integration

Hi need support with lead generation, B2B outreach, managing the mails ( from influencer and B2B).
Manage Shopify orders ( if possible )

Hello I'm looking to automate my contacts after initially contact them through Bark.com. Have a series of 5 contact emails to bring them through the funnel. so that they want to book an appointment with me for a Hypnosis session. After I work with them I want to start with a monthly newsletter to keep them in touch. I would also like to reach out to the thousands of emails I have accumulated through my years with Bark.com so that I can monetize that email list and drip periodic follow ups to them.

• Describe your recent experience with similar projects
• Please list any certifications related to this project
• How do you handle sensitive information or records?

I have the full set of recent financials—balance sheet, income statement, and cash-flow statement—and I need a clear, insightful assessment of how the business is really performing. The goal is straightforward: use these statements to evaluate overall health, spot strengths and weaknesses, and establish the underlying assumptions that drive results.

Please draw out the key profitability, liquidity, and other relevant ratios, interpret the trends you see, and explain what each finding means for day-to-day operations as well as long-term strategy. I also want to understand which assumptions you would adopt for items such as revenue growth, cost of sales, working-capital cycles, and capital spending so that I can plug them into future projections with confidence.

Deliverables
• A concise report (PDF or Word) summarizing ratio calculations, trend analysis, and commentary
• A working spreadsheet (Excel or Google Sheets) showing all figures, formulas, and the assumptions table

Acceptance criteria
• All calculations trace back to the supplied statements with no hard-coded totals
• Assumptions are clearly justified with a short narrative or data reference
• Findings align with the stated objective of business performance assessment

If additional figures or clarifications are required along the way, just flag them and I will provide them promptly.

Skills: Accounting, Excel, Business Analysis, Financial Planning, Data Analysis, Financial Forecasting, Financial Modeling

Company Overview
We’re a California-based fitness equipment retailer (Fitness Superstore & French Fitness) importing from China and selling B2C/B2B online.

We currently manage inventory using:
* Google Sheets master inventory (product master, invoices, POs, packing lists, etc.)
* WASP on-hand inventory
* Shopify for sales

We also have a custom Google Apps Script dashboard that’s powerful but buggy and too developer-dependent (custom UI, coding errors, hard for the team to maintain).

Our team is actively cleaning and standardizing supplier data, starting with Kingace and Tina Wang. We now want a BI / automation specialist to rebuild the reporting and logic in a clean, maintainable way.

What We Want
We want to standardize on:
* Google Sheets – as the clean data model / single source of truth
* Looker Studio (Data Studio) – for dashboards and reporting
* Very light Google Apps Script / connectors – only for refreshes & alerts (no big custom web-app UI)

The goal: keep all the visibility we want (on-hand + in-transit + open POs + packing lists), but in a structure that any strong Google-Sheets freelancer can maintain later—not just the original developer.

Phase 1 – Clean Data Model in Google Sheets
Work with our existing master inventory sheet and create/refine normalized tables such as:
* Products – product code, SKU, name, line (FFB/FFT/etc.), color, Shopify ID, URL, image link
* PurchaseOrders – one row per PO line (PO #, supplier, SKU, ordered qty, unit cost, status, dates)
* PackingLists / Containers – container/BL #, ETD, ETA, supplier, SKU, shipped qty, etc.
* OnHand_WASP – on-hand inventory snapshot(s) from WASP
* SalesHistory – basic historical sales per SKU (from Shopify export) for lead-time demand / ROP

Initial focus: Kingace + Tina Wang POs/packing lists for the current year, then make the structure reusable for other suppliers.

Deliverables (Phase 1)
* Clean, linked tables in Sheets (no business logic buried only in script)
* A “Simple Stock Query 2.0” view that lets our team enter a product code/SKU and see:
- suppliers
- invoices
- order qty / shipped qty / unshipped (in-transit)
- container/packing list info
- links to invoices, packing lists, Shopify product, and product image

Phase 2 – Looker Studio Dashboards
* Build Looker Studio dashboards that read directly from the standardized Sheets:
1. Inventory / Replenishment Dashboard
- On-hand + in-transit + open POs vs. Reorder Point (ROP)
- Filters: supplier, factory, product line, SKU, status
- A clear “Reorder Now” list of SKUs below ROP
2. PO / Supplier Performance Dashboard
- Open vs closed POs, value by supplier
- Completion % by PO and by supplier
- Units and value by container (ETD/ETA)

Dashboards should be straightforward, drag-and-drop editable for a future analyst (no hidden or opaque logic).

Phase 3 – Light Automation & Alerts
* Set up safe, maintainable ways to keep Sheets in sync with:
- WASP export(s)
- Shopify sales exports
* Use connectors (Coupler.io, Supermetrics, or similar) or clearly documented CSV import workflows.
* Add light automation only where needed:
- Email/Slack alert when a SKU falls below ROP
- Scheduled refreshes
* No complex custom web-app front-end; if Apps Script is used, it should be small, well-commented, and easy to disable/replace.

Phase 4 – Documentation & Handoff
* Short data dictionary for each table (definitions, keys, relationships)
* A 1–2 page “How this works” guide for non-technical staff
* Optional Loom walkthrough
* SOP suggestions so the team doesn’t break the model when adding future suppliers

What You’ll Need to Do With the Existing Script Dashboard
We already have a custom Apps Script dashboard that:
* Pulls from copies of our Sheets
* Has search by SKU / PO / supplier
* Includes some PO analysis logic but is buggy, with coding errors and mismatches

Your job is not to patch this forever. Your job is to:
* Review the current system
* Salvage useful ideas (not necessarily the code)
- Extract logic into formulas/queries + Looker Studio or rebuild cleanly
- Retire the script UI if needed

We care more about clarity and maintainability than preserving custom code.

Ideal Freelancer
Must-have:
* Expert-level Google Sheets
- QUERY/FILTER, array formulas, INDEX/XLOOKUP, SUMIFS, pivot tables
* Strong Looker Studio experience
- Experience building dashboards on Google Sheets
* Comfortable with Google Apps Script (reading, modifying, small scripts)
* Understanding of inventory & supply chain:
- POs, packing lists, containers, ETD/ETA
in-transit vs on-hand
- ROP / safety stock

Nice-to-have:
* Experience cleaning up someone else’s complex sheet or script
* E-commerce / Shopify background
* Familiarity with WASP or similar inventory systems

What to Include in Your Proposal
1. A brief description of a similar project you’ve done (Sheets + Looker + automation)
2. Estimated hours with a rough breakdown by phase:
- Modeling
- Dashboards
- Automation
- Documentation
3. Confirmation you are comfortable taking over an existing Apps Script project and simplifying it

• Share a link (or screenshots) to a Google Sheets + Looker Studio dashboard you built for inventory, logistics, or operations. Briefly describe the data tables behind it and how they were related.
• Suppose you receive one messy sheet where product info, POs, and packing lists are all mixed together. How would you restructure it into separate tables and keep them in sync? Describe your approach in 4–6 sentences.
• How would you calculate dynamic Reorder Points (ROP) per SKU using lead time, average demand, and safety stock in Google Sheets? Outline the key formulas you’d use.
• What tools or methods have you used to keep Google Sheets synced with systems like Shopify, ERPs, or inventory tools? Which approach would you recommend here and why?
• Tell us about a time you inherited a complex spreadsheet or custom script from another freelancer or employee. What were the main risks, and how did you simplify it into something maintainable?

DO NOT contact me outside of Upwork

Hi — I’m Chris, founder of Pyle of Goodness LLC.

I’m building multiple businesses at once. Some are digital (ecommerce, publishing, content), some are physical/local services launching soon. I’m not looking for ideas. I’m not looking for strategy. I’m not looking for someone to “reimagine” things.

I’m looking for an execution-first operations partner who enjoys tying systems together, cleaning up loose ends, and making sure things actually work end-to-end.

If you love order, detail, and helping other people’s work succeed — this role will feel good.
If you want to be the creative voice, this will not be a fit.

What this role actually is

This is a systems + execution role, not a creative or social media management role.

Your job is to connect, organize, and maintain the tools and platforms we already have so nothing is orphaned, broken, or half-set-up.

You will be working behind the scenes, quietly making things function.

Systems & tools you’ll be working with

You should be comfortable (or willing to learn quickly) with:

Kit (ConvertKit) — email system (broadcasts, tags, collaborators)

LastPass — password access & security (no shared passwords)

Wix — websites & landing pages

Shopify — ecommerce stores

Etsy

Gumroad

Social platforms:

Facebook

Instagram

TikTok

YouTube

Threads / Facebook Reels

Bluesky

You do not need to be a master of all of these — but you must not be intimidated by them, and you must enjoy figuring out how they connect.

What you will own

Tying platforms together so they actually point somewhere useful

Making sure links, bios, and CTAs are consistent and current

Ensuring email capture works where it should

Keeping assets, accounts, and access clean and organized

Using LastPass properly so access is secure and auditable

Maintaining simple trackers for:

what exists

where it lives

where it points

Flagging issues early (broken links, missing connections, platform quirks)

If something exists but goes nowhere, that’s your domain to fix.

What you will NOT be responsible for

Creating content

Writing copy

Deciding brand voice

Choosing what to post or when to post

Running ads creatively

Developing strategy

Managing other people

This role supports execution — it does not redefine direction.

Who this role is perfect for

You might be a great fit if you:

Enjoy detailed, tech-adjacent work

Take pride in clean systems

Like following clear direction and checklists

Are calm in early-stage environments

Get satisfaction from helping others succeed

Prefer execution over spotlight

Don’t need to “own” the creative

You should be comfortable saying:

“Tell me what you want connected and how you want it done.”

Who this role is NOT for

Social media strategists

Creators looking for visibility

People who want to redesign brands

Anyone who gets frustrated by ambiguity

Anyone who needs to be the decision-maker

This is not a role for ego — it’s a role for excellence.

Structure & expectations

Part-time to start

Flexible hours, async work

Clear priorities and checklists

Direct communication

High trust, high accountability

Budget is modest at first — this is an early-stage company — but the role can grow with the business if it’s a strong fit.

How to apply

Please do not send a generic pitch.

Instead, tell me briefly:

What kind of systems work you enjoy most

Which tools above you’ve worked with

Why this kind of behind-the-scenes role appeals to you

If you’ve ever been described as “the person who makes everything actually work,” I want to hear from you.

—
Chris
Founder, Pyle of Goodness LLC
DO NOT contact me outside of Upwork

• 1. This role is execution-focused and non-creative. Tell me why that appeals to you.
• 2. Which of these systems have you worked with? (Kit/ConvertKit, Shopify, Wix, Etsy, Gumroad, LastPass, Meta platforms)
• 3. Describe a time you were responsible for connecting multiple tools or platforms so they worked together cleanly.

Job Description:

1. Comment on Posts submitted to our Facebook Group

2. Log your responses in our Google Sheets

3. Repeat this every day

Note: We are hiring on a first-come, first-serve basis

I’m looking for a reliable, detail-oriented Virtual Assistant to help me with a variety of ongoing administrative and “digital life” tasks. This role will include managing email triage, planning appointments, supporting job application workflows, and handling small digital errands like downloading eBooks and sending them to my Kindle.

A key requirement: you will be controlling my computer remotely at times (with my permission and using a secure remote-access tool). You must have a strong, stable internet connection and be comfortable working carefully in real time.

This is a long-term role for the right person.

Key Responsibilities

1) Email Support

Check email on a regular basis and triage messages (label, archive, flag important items)

Draft replies for my review (or send simple responses when pre-approved)

Track key action items and follow-ups so nothing gets missed

Organize inbox to reduce clutter (folders/labels, rules/filters if needed)

2) Calendar + Appointment Planning

Schedule appointments and coordinate times

Send calendar invites and ensure details are correct (time, link/location, agenda)

Reminders and basic weekly planning support (e.g., confirming upcoming items)

3) Job Application Assistance (Using My Computer)

Assist with submitting job applications and completing online forms using my computer remotely

Help keep a simple tracker of roles applied to, dates, status, and next steps

Upload resumes/cover letters and ensure correct formatting is used

Help me answer application questions using my tools that I will provide you and train you on

Follow a clear process and confirm details before any submission when needed

4) Digital Errands (Kindle + eBooks)

Download eBooks (from sources I provide or that are legally available)

Organize files and send to my Kindle via approved methods

Maintain a simple library folder structure so files are easy to find

Handle other light digital admin tasks as they come up

Tools + Access

Remote access: You must be comfortable controlling my computer remotely (I will provide access instructions and remain available for sensitive approvals).

Communication: Chat + email updates. Quick check-ins are important.

Internet: Stable, high-speed connection is required.

Important Requirements

Strong written English and clear communication

Extremely detail-oriented (accuracy matters: names, dates, attachments, forms)

Trustworthy and privacy-conscious (you will see sensitive personal info)

Comfortable following standard operating procedures (SOPs) and checklists

Fast learner, proactive, and calm under time pressure

Able to work independently while still asking questions when needed

Security + Privacy Expectations

You must agree to keep everything confidential.

No sharing, storing, or reusing my personal information outside of this work.

You will not purchase anything, change passwords, or access financial accounts unless explicitly approved and supervised.

For job applications: confirm details before final submission if anything is unclear.

Time Commitment

Part-time to start (estimated 5–10 hours/week), with potential to increase.

Prefer someone who can respond within reasonable time windows on weekdays.

How to Apply

Please include:

A short intro and your relevant VA experience

Confirmation that you have a stable internet connection and remote-computer experience (please tell me what your internet speed is)

Examples of similar work you’ve done (email management, scheduling, job applications, digital file handling)

Your availability (time zone + typical hours)

Your hourly rate and minimum weekly commitment

Any tools you’ve used for remote access and task tracking (e.g., AnyDesk/TeamViewer/Chrome Remote Desktop, Notion/Trello/Google Sheets)

Bonus (Nice to Have)

Experience supporting job searches and application tracking


Ability to create simple checklists/templates to streamline repeated tasks

Looking forward to working with someone organized, dependable, and comfortable handling a wide variety of tasks remotely.

Skills: Data Entry, Virtual Assistant, Customer Service, Time Management, Internet Research, Email Handling

Role: Virtual Assistant (Admin Ops) — help remove daily tasks from owner workload
Hours: 10–20 hrs/week to start (grow as proven)
Core tasks:

Inbox triage + draft replies

Scheduling (appointments, reminders, confirmations)

Follow-up tracking (leads, estimates, past clients)

Build and maintain simple trackers (Google Sheets)

Create job folders + keep files organized

Vendor/order follow-ups and basic coordination

Write SOPs/checklists as we build the system

Tools: Google Workspace (required). CRM experience preferred.

• Describe your daily system for managing tasks + deadlines. What tools do you use?
• Write a short, professional text message confirming a home appointment for tomorrow at 9:00 AM.
• If you inherit a messy Google Drive, what’s your cleanup approach in the first 60 minutes?
• Tell me about a time you caught an issue before it became a problem. What did you do?
• What hours are you available (include time zone), and what’s your typical response time Mon–Fri?

Build an automated daily weather newsletter for a home services company. The system pulls weather forecasts for 37 US markets, calculates a custom scoring metric, generates a map and heatmap, and emails a formatted report to executives and operators at 6 AM daily.

1. Connect to Visual Crossing Weather API (we provide API key)
2. Pull 30-day forecasts for 37 DMAs daily
3. Calculate custom 'Yard Day Score' (1-10) per formula we provide
4. Generate Mapbox static image with color-coded market markers
5. Build 30-day calendar heatmap (HTML/CSS)
6. Build 7-day forecast table with temp/precip/YDS
7. Assemble responsive HTML email matching provided design
8. Append raw data to Google Sheets (structure provided)
9. Schedule daily send at 6 AM EST via SendGrid
10. Set up error handling with email alerts on failure
11. Provide documentation for ongoing maintenance

Summary
Project Type: Hourly Contract (Ongoing, starting at 10-20 hours/week)
Skills Required: Canva, Zapier/Make.com, LLM Prompting, Google Sheets/Airtable, E-commerce Fulfillment (Etsy/Shopify/Lulu/Blurb).
Budget: Please state your hourly rate based on your experience with the required toolset.
Project Summary
We are launching a unique personalized book product ("Grandparent Legacy Keepsake"). We need a highly organized and efficient specialist to manage our end-to-end order fulfillment pipeline, which relies on a No-Code technology stack (Canva, Zapier, Typeform, LLM APIs).
This role is critical for transforming structured customer input into a final, print-ready file through a combination of light manual design work and automation management.
Key Responsibilities & Workflow
The successful freelancer will be responsible for the entire process, starting from order confirmation through to print submission.
1. Automation Monitoring & Input Processing
• Monitor: Track incoming orders and submitted customer input forms (via Google Sheets/Airtable, integrated with Zapier/Make.com).
• AI Trigger: Ensure the automated Zapier steps successfully send the customer's 12 Milestone answers to the LLM API for narrative generation.
• Review: Lightly review the AI-generated text for immediate errors, brand tone, and flow before moving to design.
2. Manual Design & Layout (The Core Task)
• Template Customization: Copy and paste the final AI-generated story text into our pre-designed Canva template (60 pages).
• Image Placement: Manually crop and place the customer's uploaded photos into the corresponding pages within the Canva template to ensure a professional look.
• Proofing: Generate a digital proof for the customer (if required) or confirm the design meets all print standards (margins, bleed, trim).
3. Print Fulfillment
• File Export: Export the final, high-resolution, print-ready PDF and cover files from Canva.
• Manual Upload: Manually upload all files and customer shipping information to our chosen Print-on-Demand (POD) partner's platform (e.g., Blurb, Lulu, or similar web interface).
• Tracking: Update the order status and tracking number on our sales platform (Shopify/Etsy).
Required Experience & Qualifications
• Expertise with Canva: Must be highly proficient in using Canva for multi-page document layout, image cropping, and generating print-ready PDFs.
• No-Code/Automation: Practical experience using Zapier or Make.com to connect forms, spreadsheets, and APIs.
• LLM Familiarity: Experience using ChatGPT or other LLM interfaces (no coding required, just strong prompting skills) to generate and edit structured content.
• Detail-Oriented: Exceptional attention to detail to ensure perfect typography, image placement, and adherence to print margins.
• Fulfillment Experience: Prior experience using major POD platforms (Lulu, Blurb, IngramSpark, etc.) or general e-commerce order management (Etsy, Shopify).
How to Apply
1. State your competitive hourly rate.
2. Briefly describe your experience with Canva layout for multi-page documents and your experience using Zapier/Make.com.
3. Confirm your availability to begin immediately.
This is a specialized role, so the job description needs to be very specific to filter for the right combination of AI, automation, and print-on-demand experience.

Skills: Project Management, Proofreading, Customer Service, Etsy, Airtable, Google Sheets, Automation, Zapier, Canva, Make.com

OVERVIEW
I’m looking for a highly organized, detail-oriented, proactive Virtual Assistant to support me directly with bookkeeping, financial tracking, task and calendar management, and administrative work.

This is a personal role working one-on-one with me (not shared with my team). A major part of this position is helping keep me on track — reminding me of tasks, deadlines, appointments, and following up so nothing falls through the cracks.

I run a fast-paced vacation rental management business with multiple income streams, vendors, homeowner payouts, and a Profit First structure. Once fully trained, this role will grow into a controller / mini-CFO-style support position, helping analyze finances and improve profitability.

This is a long-term role for the right person.

CORE RESPONSIBILITIES
Daily Financial & Bookkeeping Support

Daily transaction entry and reconciliation

Managing accounts payable (vendors, cleaners, reimbursements, invoices)

Managing accounts receivable across multiple platforms

Reconciling payouts from Airbnb, Hostaway, Stripe, checks, Venmo, and Cash App

Supporting Profit First account tracking and allocations

Maintaining clean, organized financial spreadsheets

Daily Financial Snapshot (Every Business Day)

Prepare a short daily report that includes:

Cash on hand

Accounts payable & receivable status

Posted payouts

Profit First balances

Cleaning and reimbursable account review

Flags for discrepancies or missing documentation

Clear action items requiring my attention


Task, Schedule & Accountability Management (Major Role Component)

A core part of this role is helping keep me, my tasks, and my schedule on track.

This includes:

Capturing all tasks I mention (email, messages, meetings, or verbally)

Maintaining a master task list organized by urgency and priority

Sending daily reminders and nudges

Following up on incomplete tasks

Alerting me to upcoming deadlines and appointments

Preparing daily and weekly priority lists

Helping structure my schedule to prevent overload

This role is proactive, not reactive.

Administrative Support

Email inbox triage and drafting replies

Digital file and Google Drive organization

Updating SOPs, templates, and internal documents

Light scheduling, reminders, and follow-ups

Occasional personal admin tasks (ordering items, research, scheduling)

Financial Reporting & Strategic Support (After Training)

Producing monthly Profit & Loss statements

Producing monthly balance sheets

Identifying inefficiencies or revenue leaks

Analyzing expense trends and seasonality

Recommending improvements to financial systems

Supporting profitability and scaling decisions

REQUIREMENTS

Experience with bookkeeping or financial administration

Experience with accounts payable and accounts receivable

Ability to produce or assist with P&L and balance sheet reporting

Strong proficiency with Google Sheets (formulas, organization, dashboards)

Excellent written communication

Highly organized, detail-oriented, and proactive

Comfortable handling confidential financial information

Able to provide daily availability and consistent communication

Interested in a long-term role with growing responsibility

COMPENSATION STRUCTURE

This role uses a blended compensation model designed to balance daily availability with focused work time.

• Monthly Retainer: $200–$250 (USD)
Covers daily availability, reminders, daily financial snapshot, and ongoing support.

• Hourly Rate: $5/hour (USD)
For bookkeeping, AP/AR, reporting, spreadsheets, systems, and deep administrative work (approximately 10–20 hours per week).

• Monthly Performance Bonus: $40–$75 (USD)
Based on accuracy, proactive support, communication, and system organization.

HOURS & COMMITMENT

Approximately 10–20 hours per week of active work

Daily availability during agreed-upon hours

Long-term position with growth into a controller / strategic finance support role

HOW TO APPLY

Please include:

A brief introduction

Your experience with bookkeeping and AP/AR

Any experience producing P&L or balance sheet reports

Your Google Sheets skill level

Your time zone and daily availability

One example of how you helped a client stay organized, on track, or financially organized

PLEASE SEE ATTACHMENT. We are seeking an experienced API integration specialist to connect Lightspeed POS X series with Google Sheets. The goal is to automate data transfer between the two platforms, ensuring real-time updates and seamless synchronization of sales and inventory data. The ideal candidate will have prior experience with similar integrations and be able to troubleshoot any issues that may arise during the process. If you have a strong understanding of APIs and are passionate about enhancing operational efficiency, we would love to hear from you!

• Describe your recent experience with similar projects

I’m building a fresh marketing pipeline and need a reliable list of individual consumers who are actively shopping for auto parts. I’m interested only in people, not wholesalers or repair shops, so the data has to be clearly segmented as end-user buyers.

What I expect from you
• A spreadsheet (Excel or Google Sheets) with up-to-date contact information: name, email address, phone number (where available), city/state, and a brief note on the part or category they’re currently seeking.
• Sources that can be verified on request—no scraped junk or outdated records.
• A short summary of how the leads were gathered so I understand the acquisition method and can stay compliant with anti-spam rules.

Acceptance criteria
• Minimum 500 qualified individual-consumer leads.
• Bounce rate below 5 %.
• Random sample of 20 leads must pass manual verification before final hand-off.

If you’ve generated similar consumer lists in the automotive space and can hit those quality metrics, let’s get started.

Skills: Data Entry, Excel, Leads, Web Search, Market Research, Google Sheets, Lead Generation, Data Collection

I have a list of 23 domains and I simply need their current Ahrefs Domain Rating (DR). This is a single-shot task—no ongoing tracking—so once the numbers are gathered, the job is done.

Because I don’t have my own Ahrefs subscription, you’ll have to run the lookup from your account. As soon as the data is pulled, drop it into a Google Sheet and share the link with me (view-only is fine).

Deliverable
• One Google Sheet containing each of the 23 domains in column A and its corresponding DR value in column B, captured on the day you run the check.

That’s all there is to it. If you already have an active Ahrefs account and can turn this around quickly, I’d love to work with you.

Skills: SEO, Data Entry, Web Scraping, Digital Marketing, Data Analysis, Google Sheets, Data Collection, Data Management

I have already written working code in Excel VBA to add additional information and formatting to a spreadsheet, and I need this simply translated to work in Apps Script with Google Sheets. The code is only about 200 lines long total, so I expect this to be a short project.

Experience with both VBA and Apps Script is essential.

Upon awarding the contract, I will send you my existing code for you to convert. No additional coding is necessary, just a simple 1:1 translation. I have already tried Chatgpt and other AI softwares and none of them convert the code correctly.

I need help taking a manual work logging system at our call center for about 50 employees and turning it into an app.

Here is the project folder. The doc brief includes a video of the what we currently use Google Sheets for.
https://drive.google.com/drive/folders/1rBRj5XLpA3jLbJkSMZgvZu15n7rMDxCq?usp=drive_link

Is this something we could use AppSheets or another no-code platform to create? Open to suggestions.

• Describe your recent experience with similar projects