Optimize Upwork Searches with Google Sheets

Urgent: Match Exported Conversations to Contacts & Organize Notes — Must Be Completed Within 10 Hours

I’m looking for someone who is available to start immediately and can complete this entire project within 10 hours of being hired.

I will provide an export containing conversations/messages along with a spreadsheet or list containing contacts and phone numbers.

What I need done
Go through the exported conversations and determine who each conversation was with.
Find the phone number associated with each conversation.
Match that phone number to the correct person/record in the spreadsheet.
Review the conversation and place the relevant information into one Notes column for that person.
Include the date and timestamp with each conversation/note and put in chronological order.
When multiple conversations belong to the same phone number/person, combine all of their information into that person's Notes field instead of creating duplicate records.
Keep the original information accurate and make sure notes are never assigned to the wrong person.
Example

If a conversation is associated with a number, you would find that number in the spreadsheet, identify the correct person, and add all conversations associated with that number to their Notes column.

The Notes field could look like:

08/10/2026 10:32 AM – Spoke with customer regarding scheduling. Customer requested a callback next week.

08/14/2026 2:15 PM – Followed up. Customer confirmed interest and asked about pricing.

Deadline — Please Read Before Applying

The completed file must be delivered within 10 hours of being hired.

Please only apply if you:

Can start immediately.
Can dedicate enough time to finish the project within the 10-hour deadline.
Are experienced with Excel/CSV/Google Sheets files and large amounts of data.
Can accurately match records using phone numbers, even when numbers may be formatted differently.
Will flag uncertain matches instead of guessing.

When applying, please tell me how soon you can start and confirm that you can deliver the completed file within 10 hours.

Please begin your proposal with MATCH so I know you read the entire description.

I’m building a new travel-tech venture and need a clean, well-structured research file that I can feed straight into outreach tools. The scope covers three intersecting sectors—travel-tech, hospitality and mobility—and zeroes in on high-value decision makers:

• Founders / CEOs
• Senior marketing contacts
• Investment-team contacts

For every company you add, I need:
– Full company name and segment tag (travel-tech, hospitality or mobility)
– Contact’s name, title and LinkedIn URL
– Website URL and any publicly listed email or phone number
– Source column showing exactly where each data point was verified (LinkedIn profile, company website or trusted public database)

Please build the file in Google Sheets (Excel-compatible), keep consistent formatting, and avoid duplicate entries. All data must be openly available—no scraped private emails. I’ll review by spot-checking 10 random rows; any missing or unverifiable field will need correcting before sign-off.

Skills: Data Entry, Research, Business Analysis, Market Research, Email Marketing, Google Sheets, Lead Generation, Data Collection, Data Management, Business Development

Job Description:

The Laundry Valet is a growing laundry pickup & delivery service based in Singapore. We're looking for a proactive Virtual Sales Assistant to help us grow our customer base through outbound outreach, lead qualification, and appointment setting.

What you'll be doing:

Research and identify prospects (condo management, offices, and individual households in target HDB estates)
Conduct outbound outreach via email, WhatsApp, and/or LinkedIn to generate interest
Qualify inbound leads and schedule follow-ups for the team to close
Maintain a simple CRM/spreadsheet tracker of outreach activity and lead status
Provide basic weekly reporting on outreach volume and response rates

We're looking for someone who:

Has prior experience in sales development, telemarketing, or lead generation (B2B and/or B2C)
Is a confident, clear communicator in written and spoken English
Is comfortable with cold outreach and follow-up persistence
Can work independently with minimal supervision
Familiarity with the Singapore market is a plus, but not required

Details:

Contract type: Part-time / hourly, with potential to scale into ongoing role
Compensation: [Hourly rate] + performance bonus for qualified leads/conversions
Tools: WhatsApp Business, Google Sheets/CRM (training provided)
Start: Immediate

To apply: Please share a short note on your relevant sales/outreach experience and your availability (hours/week).

I'm looking for a reliable Virtual Assistant to help with outreach to owner who are looking for their space to be rented. This is a long-term opportunity for the right person. Initially, the workload is approximately 5 hours per week with the potential to grow as my rental business expands.

B2B Lead Generation — Facilities Managers for Restaurant & Retail Chains

I’m looking for an experienced B2B lead-generation specialist to build a targeted contact list for my commercial facilities maintenance company.

We provide facilities maintenance and small-project services in **New York City and Long Island** and want to connect with decision-makers responsible for facilities/vendor management at multi-location restaurant, retail, fitness, healthcare, and franchise companies.

### Target Companies

Examples include:

* Chipotle
* Panda Express
* CAVA
* QDOBA
* Tropical Smoothie Cafe
* Jersey Mike’s
* Wingstop
* Five Guys
* Planet Fitness
* Dunkin’
* Similar multi-location brands

### Target Job Titles

Please focus on:

* Facilities Manager
* Regional Facilities Manager
* Director of Facilities
* Senior Facilities Manager
* Facilities Maintenance Manager
* Vendor Manager
* Vendor Relations Manager
* Facilities Procurement
* Construction & Facilities Manager
* Regional Operations/Facilities leaders involved in vendor selection

### Geographic Focus

Priority:

1. New York City
2. Long Island
3. New York / Northeast region

### Deliverable

I would like **100 highly targeted contacts** delivered in Excel or Google Sheets with:

* First Name
* Last Name
* Job Title
* Company
* Work Email
* Email verification status
* LinkedIn profile URL
* City/Region
* Company website
* Notes explaining why the contact is relevant

### Important

I do **not** want a generic scraped list.

Every person should have a reasonable connection to **facilities maintenance, contractor/vendor management, repair services, or construction/facilities operations**.

Please verify work emails wherever possible.

In your proposal, please tell me:

1. What tools you use for sourcing leads
2. What tools you use for email verification
3. How you prevent bounced/outdated emails
4. Whether you have experience researching facilities-management contacts
5. Your price for 100 verified contacts
6. How long delivery will take

Please include a sample of **3–5 contacts** matching this criteria before beginning the full project.

About us
We’re a group of Australian companies across lending, property & finance. We run ~6 Xero orgs (finance brokerage, labour hire, and a 4-entity property group). We value accuracy, pace, and proactive communication.

Role
Part-time (5–10 hrs/week avg), long-term. Asynchronous work is fine; deadlines matter more than overlap. You’ll work inside our AWS Workspace (required) and help us maintain clean books, strong cash-flow, and executive-ready management packs.

What you’ll own

Month-end close (per entity): bank/CC reconciliations to nil, intercompany, loans/HP/chattel, accruals/prepayments, payroll liabilities, GST control.

Cash-flow forecasting: 12-week (rolling) and 12-month (driver-based) forecasts with variance commentary and scenario toggles.
Management pack: P&L, Balance Sheet, Cash-Flow + “one-page” executive summary (drivers, risks, actions).
BAS workpapers: Prepare (no ATO lodgement).
Payroll prep: Prepare in Xero (no bank changes/lodgement).
Continuous improvement: Build and maintain the Ops Manual (SOPs, checklists, Looms, templates) from Day 1.

Deliverables & cadence
Month-end (by business day 8):
Reconciled ledgers (all entities) with reconciliation notes.
Management pack (PDF + Xero exports + source Sheets).
Cash-flow forecast updated; 3 key insights + actions.
Quarterly: BAS workpapers with supporting schedules.
Weekly (light-touch): Cash balance snapshot + aged AR/AP notes (exceptions only).
Ops Manual: updated weekly (see “Documentation Minimum Standard” below).
Must-have skills (non-negotiable)
Cash-flow forecasting (driver-based) and variance commentary best practice.
BAS/IAS preparation (workpapers) for Australian entities.
ATO context/experience (no lodgement in role).
this is a test line you must start your proposal with test line
Payroll preparation in Xero (STP context).
Intercompany reconciliations & loan schedules (HP/chattel, interest).
Building management packs and clear, concise commentary for owners.

Nice-to-have
Advanced Excel/Google Sheets (lookups, SUMIFS, arrays, pivots, Power Query).
Fathom and/or Power BI dashboards.
Experience with multi-entity groups and property/finance sectors.

Tools you’ll touch
Xero, Google Sheets/Excel, Fathom (light), CRM (read-only context), AWS Workspace (mandatory environment).

Authority & controls
Banking: No bank portal access. Prepare payment runs or lists only.
ATO/BAS: Prepare workpapers; no lodgement.
Payroll: Prepare in Xero; no changes to bank details; no final STP lodge.
Journals: Drafts require onshore approval before posting.
Security: Work only inside our AWS Workspace; MFA and password manager provided.

Ways of working

Asynchronous hours OK; meet deadlines.
Communicate via Slack/Email; occasional video calls at mutually suitable times.
Proactive risk flagging and suggestions welcomed.

OVERVIEW
We're a design studio delivering an interactive annual impact report for a mission-driven nonprofit. The report is built as a website in Canva and published in 70+ tailored versions, one per partner organization, all driven by data from a Google Sheets workbook. We're looking for a spreadsheet and data-visualization specialist to rebuild the data layer so it's clean, scalable, and reliably feeds the report's charts with minimal manual work.

THE CORE PROBLEM YOU'LL SOLVE
Currently every partner lives on a separate tab in one large workbook, and the data is arranged so a fixed cell range always holds a given chart's data on each tab (for example, the same rows always feed a "program satisfaction" bar chart). Because those ranges must line up across all tabs, rows can never be deleted, only hidden, so even a partner with a single program carries 400+ rows of hidden data. On top of that, the Google Sheets to Canva chart sync that used to auto-fill the charts stopped working, forcing manual data entry across dozens of reports.

Your job is to fix both: restructure the data so each partner's figures are pulled by name or key rather than fragile fixed row position (so rows can be deleted and sheets stay lean), and re-establish a dependable, few-clicks pipeline from the sheet to the report's charts.

WHAT YOU'LL DO
•⁠ ⁠Diagnose why the Google Sheets to Canva sync fails and identify the reliable path. Variables to test include file size, sheet structure, and Google Drive storage location (personal vs shared drive).
•⁠ ⁠Restructure the workbook using lookups (XLOOKUP / FILTER / QUERY / named ranges) so data is keyed by partner rather than by cell position.
•⁠ ⁠Decide and implement the best architecture: one restructured workbook vs. a separate lightweight file per partner.
•⁠ ⁠Build a clean "chart feed" structure that Canva, or an embedded chart tool, can bind to reliably.
•⁠ ⁠Recommend native Canva charts vs. embedded charts (Datawrapper or Flourish) per chart type (bar, pie, and gauge/percentage dials), prioritizing reliability and clean labeling.
•⁠ ⁠Make chart and data updates near-automatic across 70+ report versions.
•⁠ ⁠Document the final system and write a short handoff guide so a non-technical team can maintain it.

REQUIRED SKILLS
•⁠ ⁠Advanced Google Sheets: complex formulas, lookups, data modeling, named ranges
•⁠ ⁠Data visualization experience (bar, pie, gauge charts) with an eye for clarity and accessibility
•⁠ ⁠Hands-on Canva experience, especially its chart/data features and Google Sheets connection
•⁠ ⁠Ability to design spreadsheet structures for scale and easy repeat updates
•⁠ ⁠Clear written communication and documentation

NICE TO HAVE
•⁠ ⁠Datawrapper and/or Flourish experience (live-syncing embedded charts)
•⁠ ⁠Familiarity with WCAG 2.1 accessibility for data visualization
•⁠ ⁠Experience building templated or duplicated deliverables at scale

TO APPLY, PLEASE ANSWER
1.⁠ ⁠Describe a project where you connected Google Sheets data to a live chart or dashboard that updated with little to no manual work. What tools did you use?
2.⁠ ⁠How would you structure a spreadsheet so a specific record's data can be pulled by a name or key rather than a fixed cell position?
3.⁠ ⁠Rate your Canva experience from 1 to 10 and briefly describe what you've built in it, including any work with its charts or data connections.

I have a spreadsheet template ready and need every cell populated with mixed data—both text and numbers—copied exactly from the provided files. Accuracy is critical: spelling, numeric values, and any punctuation must mirror the originals. Once the raw information is in place, a quick double-check for consistency (date formats, column alignment, duplicates) will complete the task.

You may use Excel or Google Sheets, whichever you prefer, but please keep formula cells and formatting intact. When finished, send back the updated file along with a brief note confirming that totals and sample cross-checks balance.

If you have a proven eye for detail and can turn this around promptly, let me know your expected timeframe and any clarifying questions.

Skills: Data Processing, Data Entry, Excel, Word, Data Cleansing, Data Analysis, Data Management

Hi,

I’m interested in working with an Amazon FBA product research specialist. My main focus would be **reselling branded products and creating bundled products**, rather than private label.

I wanted to ask if you have previous experience working with this type of business model, especially with **branded products and profitable bundles**.

I’m also specifically interested in selling on the **Spanish Amazon marketplace (Amazon.es)**, so I’d like to know if you have experience working with the Spanish market and whether you can conduct product research specifically for Amazon.es.

For the product leads, I would be looking for criteria such as:

* Around **35%+ ROI**
* Strong monthly sales volume
* Good profit potential
* Products with enough demand and room for profitable resale
* Products suitable for the **Spanish market**

I’m considering a **30-day monthly plan**, and I’d like to know approximately:

* How many leads would I receive per day?
* What type of leads would they be?
* Would they be based on my specific criteria, or more general product opportunities?

Finally, apart from providing leads, do you also offer **ongoing support and guidance**? For example, helping with questions about potential products, analyzing opportunities, or solving problems that may come up while sourcing and reselling.

If you have experience with this model and the Spanish Amazon market, I’d be interested in hearing how you normally work with clients like me.

Thanks!

Summary

We are looking for an experienced Google Apps Script developer to build a custom product-performance reporting system using the Lightspeed Retail X-Series API, BigQuery, and Google Sheets.

Lightspeed's standard reporting does not accurately show which of our products are truly performing best or worst because:

Bulk inventory skews sell-through rates. We may buy large quantities of a strong seller, making its traditional sell-through percentage appear artificially low.
Out-of-stock periods skew items-sold-per-day. A product that sells 10 units while available for only 10 of 30 days should not be evaluated as though it had 30 days of selling opportunity.

We currently have approximately 7,000+ SKUs and sell roughly 17,000 items per year.

What We Need

The system should use:

Lightspeed X-Series → Google Apps Script → BigQuery → Google Sheets

BigQuery should store the historical/raw data, while Google Sheets should be the searchable/filterable reporting interface.

1. OOS-Adjusted Sales Velocity

The primary metric should be:

Items Sold Per In-Stock Day = Units Sold ÷ Days Available for Sale

Days when inventory is considered out of stock should be excluded from the denominator.

We also need a configurable Out-of-Stock Margin because inventory is not always perfectly accurate due to theft/shrinkage.

Example: if a SKU has an OOS margin of 3, an inventory level of 3 or below should be treated as out of stock for reporting purposes.

The margin should be configurable by product/SKU.

2. Sales and Inventory Must Be Tracked Separately

Actual Lightspeed sales data should determine units sold and returns.

Inventory changes should determine product availability/OOS status.

Inventory changes caused by things such as:

Receiving deliveries
Theft/shrinkage
Inventory counts
Manual corrections
Transfers

must not accidentally be counted as sales or returns.

3. Historical Data

We want historical sales imported into the new system before launch.

Use the Lightspeed API where possible, with Lightspeed CSV exports as a fallback if necessary.

We understand historical sales may be available even if historical daily inventory levels are not. The developer should determine what inventory history Lightspeed exposes and clearly identify the earliest date for which the new OOS-adjusted calculation can be considered reliable.

4. Product/Supplier SKU Grouping

Our internal Lightspeed SKUs are generally numerical.

Multiple internal SKUs may share the same supplier SKU because they represent different colors/sizes of the same product.

Example:

Supplier SKU XYZ

Internal SKU 123 – Small
Internal SKU 124 – Medium
Internal SKU 125 – Large

Searching XYZ should allow us to see either:

The combined performance of the product family, or
The performance of each individual SKU/variant.

Some supplier SKUs also contain size/color suffixes, so searching a root such as KA664 should return related variants such as KA664-SM, KA664-MD, etc.

We prefer predictable root/group matching over broad fuzzy matching that may generate incorrect SKU relationships.

5. Google Sheets Report

The final user-facing report must remain inside Google Sheets.

Users should be able to use multiple filters simultaneously, including:

Date range
Internal SKU
Supplier SKU/product family
Vendor/Supplier
Category
Product
Size/Color where applicable

A Google Sheets sidebar or similar Apps Script interface is acceptable if it provides a better experience than standard Sheets filters.

The report should show key fields such as:

SKU / Supplier SKU
Product
Vendor
Category
Units sold
In-stock days
OOS days
OOS-adjusted items sold per day
Current inventory
OOS margin
Performance ranking
6. Discount Context

We also need an average discount metric for the selected reporting period.

This is important because a poorly performing product placed on clearance may suddenly appear to be a strong seller.

A quantity-weighted average discount is preferred if the Lightspeed data supports it.

Technical Requirements
Use bulk/paginated API calls, not individual API calls for thousands of SKUs.
Design around Google Apps Script execution limits using chunked/resumable processing where needed.
Avoid duplicate data when jobs retry or resume.
Store API credentials securely in Apps Script Properties or another agreed secure location—not spreadsheet cells.
Log API/sync errors so failures do not happen silently.
Keep BigQuery as the historical data store rather than allowing raw logs to make the Google Sheet increasingly slow.
The normal integration should be read-only with respect to Lightspeed.
Testing

The freelancer is responsible for setting up or using an appropriate Lightspeed test/development environment, credentials, and dummy data necessary to validate the system before connecting it to production.

Testing should confirm that:

Sales count as sales.
Returns count correctly.
Receiving inventory does not count as a return.
Shrinkage/manual inventory reductions do not count as sales.
OOS thresholds affect available selling days correctly.
Related SKU variants can be viewed individually or together.
Documentation

Provide concise documentation suitable for our internal RAG system covering:

System Overview & Links

What the system does
Google Sheet
Apps Script project
BigQuery resources
Other required operational links

Users/Managers

How to search/filter reports
How to interpret the metrics
How to change OOS margins

Developer/IT

Architecture
API/authentication
BigQuery structure
Sync/pagination/resume logic
OOS calculation
SKU grouping
Error handling
Triggers and maintenance
Deliverables
Working Lightspeed → BigQuery automated data pipeline
Historical sales backfill
Ongoing inventory/OOS tracking
OOS-adjusted sales-performance calculations
Supplier SKU/product-family grouping
Discount metric
Filterable/searchable Google Sheets report
Source code
Testing
Documentation

I’m looking for a Lead Generation / Appointment Setter & Data Specialist to help GrandCoast Hospitality Management grow its client base.

The ideal person will be responsible for:

* Finding and researching potential short-term rental property owners and hosts.
* Building and maintaining a qualified lead list.
* Reaching out to prospects through email, social media, calls, and other appropriate channels.
* Starting conversations and identifying owners who may need short-term rental management or virtual hospitality support.
* Qualifying leads based on their property, needs, and interest.
* Following up consistently with potential clients.
* Setting qualified appointments for sales calls.
* Helping move prospects through the sales process and assisting with closing new clients.
* Keeping accurate records of leads, conversations, follow-ups, appointment status, and outcomes.
* Updating our CRM/Google Sheets and ensuring all lead information is organized and accurate.
* Providing regular reports on leads generated, contacts made, appointments booked, and clients converted.

I’m looking for someone who is proactive, organized, persuasive, detail-oriented, comfortable with outreach, and focused on results. Experience with short-term rentals, Airbnb, property management, lead generation, appointment setting, or sales is a strong advantage.

The main goal is simple: **find qualified property-owner leads, turn them into conversations, book appointments, and help convert them into GrandCoast Hospitality Management clients.**

Busco apoyo continuo como asistente virtual, con énfasis en la carga ágil de datos y la facturación tanto de productos como de servicios.

Lo que necesito de forma clara y recurrente:
• Carga precisa de información en nuestras hojas de cálculo y sistemas internos.
• Emisión y registro de facturas para productos y para servicios, verificando que cada comprobante cumpla con los requisitos fiscales locales.
• Organización y actualización diaria de los archivos digitales para que todo el equipo pueda consultarlos al instante.

Valoro una comunicación fluida, manejo responsable de datos confidenciales y la capacidad de seguir procesos ya definidos mientras propone mejoras cuando detecte oportunidades. Si cuentas con experiencia previa en asistencia virtual y conoces herramientas habituales de facturación (por ejemplo, Excel, Google Sheets o cualquier sistema ERP), me gustaría saber cómo puedes aplicar ese conocimiento a nuestro flujo actual.

Entrego lineamientos detallados una vez iniciado el proyecto y estoy disponible para resolver dudas durante la implementación.

Skills: Data Processing, Data Entry, Excel, Virtual Assistant, ERP, Google Sheets, Billing, Data Management

Title: Cognito Forms and Google Sheets Specialist for Ongoing Business Support

We are seeking an experienced contractor to take over the day-to-day technical support and maintenance of several business processes built using Cognito Forms and Google Sheets.

Our company operates in the deathcare industry and relies on online forms and spreadsheets to collect customer information, manage cases, track operations, and support staff across multiple locations. We need someone who can quickly understand the existing system, keep it running reliably, troubleshoot problems, and improve it where appropriate.

Responsibilities

Maintain and update existing Cognito Forms.

Manage conditional logic, calculations, repeating sections, payment fields, notifications, and document generation.

Maintain Google Sheets connected to Cognito Forms.

Troubleshoot missing, duplicated, incorrectly formatted, or improperly transferred data.

Update formulas, filters, lookups, validations, protected ranges, and reporting sheets.

Assist staff when forms, spreadsheets, or workflows are not functioning correctly.

Test changes before they are placed into production.

Document how the current system works and record all significant changes.

Recommend practical improvements without unnecessarily rebuilding working systems.

Help prepare the company for an eventual transition to a more integrated operating platform.

Required Experience

Strong hands-on experience with Cognito Forms.

Advanced proficiency with Google Sheets.

Experience connecting form submissions to operational spreadsheets.

Ability to work with formulas, conditional logic, data validation, permissions, and automated notifications.

Strong troubleshooting skills.

Ability to understand an existing system created by someone else.

Clear written and verbal communication.

Dependability and careful attention to detail.

Experience with Google Apps Script, Zapier, Make, APIs, or similar automation tools is helpful but not required.

Engagement

This is a remote, part-time contract position. The initial workload will be heavier while the contractor learns the existing system and assumes responsibility for it. After the transition, the work should become ongoing maintenance, troubleshooting, and occasional development.

The contractor should be available during at least part of the U.S. Eastern Time business day and able to respond promptly when an operational problem arises.

Because the system contains sensitive customer and business information, confidentiality and discretion are essential.

To Apply

Please include:

A description of your experience with Cognito Forms.

Examples of Google Sheets systems you have built or maintained.

Your experience troubleshooting an existing form-and-spreadsheet workflow.

Your hourly rate and general availability.

Whether you are available for ongoing support after the initial transition.

Screening Questions

How many Cognito Forms projects have you worked on?

Have you maintained Cognito Forms and Google Sheets systems built by another developer?

How would you diagnose a situation in which a Cognito submission appears in the form system but not in the connected Google Sheet?

Are you comfortable documenting the existing system before making major changes?

What hours are you normally available in U.S. Eastern Time?

About Us:
We are a high-end travel agency specializing in luxury travel, VIP entertainment logistics, and complex corporate group blocks. We manage travel for touring artists, executives, and high-net-worth individuals. We move fast, expect high attention to detail, and value team members who truly understand how the hospitality industry works from the inside out.

The Role:
We are looking for a highly organized, hospitality-driven Hotel Sourcing & Group Travel Coordinator to join our remote team. In this role, you will be the backbone of our hotel operations—sourcing 4- and 5-star properties globally, managing complex group room blocks, and handling VIP rooming lists.

The ideal candidate has prior experience working on-property at a hotel (Group Sales, In-House Reservations, or Revenue Management) or at a corporate travel management company. You need to know how hotels operate behind the scenes, how to read a group contract, and how to negotiate the best concessions for our clients.

What You Will Do:

Hotel Sourcing & RFPs: Research and source luxury hotels globally. Build, send, and track RFPs, ensuring all client requirements (e.g., bus parking, suite upgrades) are addressed.

Group Block Management: Manage the lifecycle of group room blocks. Keep strict track of contract cut-off dates, attrition clauses, deposit schedules, and cancellation policies.

Rooming Lists & VIPs: Submit accurate rooming lists, ensure VIP preferences are flagged, and confirm all special requests are securely in the hotel's PMS.

Data & Reconciliation: Maintain and update our internal client tracking databases and master reconciliation spreadsheets (Google Sheets/Excel).

Vendor Relations: Serve as the professional liaison between our agency and hotel sales managers globally—chasing down emails, securing contract revisions, and building strong relationships.

What You Bring (Requirements):

Hospitality Background: 2+ years of experience working directly for a hotel (Group Sales, Reservations, Event Planning) or a corporate travel agency.

Industry Fluency: Deep understanding of hotel terminology (ADR, Attrition, Concessions, Cut-Off Dates, PMS).

Tech Savvy: Highly proficient in Google Workspace (Sheets, Docs) and Microsoft Excel.

Bonus (Not Required): Experience with Sabre GDS or Cvent is a massive plus. Let us know if you have this!

Detail Obsessed: You can spot an error on a 50-person rooming list instantly.

Communication: Exceptional written and spoken English. You are comfortable calling hotel sales departments globally to negotiate and secure space.

Logistics & Schedule:

Hours: 30 Hours a Week during Probation Period and then 40 Hours a Week. .

Time Zone: Pacific Time Zone - US West Coast.

How to Apply:
Please submit a brief proposal highlighting your specific experience working with hotels or group room blocks.

Important: To ensure you have read this entire job description and possess the attention to detail required for managing VIP travel, please start your cover letter with the exact phrase: "Rooming List Ready." Proposals without this phrase will be automatically declined.

Subject: Seeking an automation and AI specialist for embroidery and screen printing business. Hello, I own an embroidery and screen printing shop looking to build an automated system that integrates email, phone calls, orders, and customer data. The goal is to capture leads, track orders, manage production stages, and automatically update customers by email or text. I'm open to platforms like Shopify, QuickBooks, Google Workspace, Zapier, or similar tools, with possible AI features such as an AI phone assistant and email responder. Deliverables include a full workflow map, software recommendations, CRM integration, automation setup, and training so I can manage the system. Ongoing support is a plus. Please reply with your experience, examples of similar integrations, recommended software stack, estimated timeline, and cost. I'd love to find a long-term partner to help scale this business. Thanks.

I’m looking for reliable, ongoing help with the day-to-day admin that keeps my workweek on track. Each week you’ll jump into my inbox, tidy up priorities, draft quick replies when appropriate, and flag anything that needs my direct input. You’ll then move over to my Google Calendar to lock in meetings, reschedule conflicts, and add reminders so nothing slips through the cracks. Finally, you’ll update a few Microsoft Excel and Google Sheets trackers so my data stays clean and searchable.

Core tools in play are Microsoft Office Suite and Google Workspace. If you also like using Trello or a similar board to visualise tasks, I’m open to it—whatever keeps the workflow smooth.

Deliverables each week:
• An organised inbox with key emails labelled or forwarded for action
• A fully updated calendar, including meeting links and brief notes
• Updated spreadsheets/files with accurate, well-formatted data

Consistency and clear communication matter more to me than time zone, although overlapping a few hours with US Eastern afternoons would help for quick check-ins. If you’re detail-oriented, proactive, and comfortable making decisions based on standing guidelines, we’ll be a great fit.

Skills: PHP, Data Processing, Data Entry, Excel, Time Management, Microsoft Office, Google Sheets, Administrative Support

# TikTok Shop Affiliate & Creator Growth Lead - Sports / DTC Brand

We're looking for an experienced **TikTok Shop Affiliate & Creator Growth Lead** to help us build and operate a large-scale, performance-driven TikTok Shop affiliate program.

**This is NOT a traditional influencer marketing role.**

We are NOT looking for someone whose primary experience is negotiating paid influencer posts, gifting products to influencers, or managing brand-awareness campaigns.

We want someone who understands how to build a **TikTok Shop affiliate machine** where creators are recruited at scale, compensated primarily through commission, developed into high-performing affiliates, and the best creators/content are identified and scaled further.

What We're Building

Our goal is to build a large network of football-focused creators and affiliates.

The basic model:

**Recruit creators at scale → Send samples to qualified creators → Get creators posting → Generate affiliate GMV → Identify top performers → Increase incentives → Develop deeper creator relationships → Turn winning creator content into paid advertising creative → Repeat**

We ultimately want a smaller group of elite creators within the larger affiliate network who:

* Post consistently
* Generate meaningful TikTok Shop GMV
* Receive increased commission and incentives
* Get early access to new products
* Produce content around product launches
* Work closely with our team
* Create content that can be tested and scaled through Meta advertising

The goal is not simply to recruit affiliates.

**The goal is to build a creator distribution and content engine**

What You'll Own

You will help build this program from the ground up and eventually take ownership of its day-to-day operation.

Responsibilities will include:

* Develop and execute our TikTok Shop affiliate growth strategy
* Source sports creators at scale
* Build automated creator outreach and follow-up systems
* Manage TikTok Shop Open and Target Collaborations
* Evaluate and approve creator sample requests
* Improve sample-to-content/posting rates
* Onboard and activate new affiliates
* Develop commission and incentive structures with our team
* Identify high-performing affiliates based on GMV, content quality, consistency, and other performance metrics
* Build deeper relationships with top-performing creators
* Coordinate early product access and launches with top affiliates
* Create creator competitions, bonuses, leaderboards, and other performance incentives
* Track creator and affiliate performance
* Identify top-performing affiliate videos
* Coordinate with our Meta advertising team to test winning creator content as paid ads
* Help secure and organize appropriate creator content/usage rights
* Build systems and SOPs that can eventually be executed by VAs
* Manage and train VAs as the affiliate program grows
* Report weekly on affiliate growth, creator activity, content volume, GMV, and key opportunities

Tools / Experience We're Interested In

Experience with some of the following is strongly preferred:

* TikTok Shop Seller Center
* TikTok Shop Affiliate Center
* TikTok Shop Open Collaboration
* TikTok Shop Target Collaboration
* GMV Max / TikTok Shop Ads
* Euka
* Reacher
* Creator CRM / outreach automation tools
* Discord creator communities
* Airtable / Google Sheets
* Creator sample management
* Affiliate commission structures
* Meta Ads creator-content workflows

You do **not** need experience with every tool listed above, but would be preferred.

We care much more about whether you've actually built or operated a successful TikTok Shop affiliate program.

Who We're Looking For

You should have direct experience with **TikTok Shop affiliates and creator commerce.**

Ideally, you've previously helped a brand:

* Recruit hundreds or thousands of affiliates
* Build high-volume creator outreach systems
* Improve creator activation rates
* Manage product samples at scale
* Generate meaningful affiliate GMV
* Build relationships with top-performing affiliates
* Create performance-based creator incentives
* Manage creator communities
* Turn affiliate content into paid advertising creative
* Build systems that VAs can execute

We're looking for someone who is **extremely performance and numbers driven.**

We care about:

**Active affiliates.
Content produced.
Sample-to-post rate.
GMV.
GMV per creator.
GMV per video.
Creator profitability.
Contribution margin.
Top creator development.
Winning advertising creative.**

Not vanity metrics.

Important: Commission-First Creator Model

Our goal is to build this program primarily around **performance-based creator compensation rather than creator retainers.**

We want our best creators to make a lot of money.

As creators prove themselves, we want to reward them through increased commissions, performance bonuses, competitions, early product access, increased exposure, and deeper relationships with the brand.

Part of your responsibility will be helping us determine how to structure these incentives so that:

**Creators have a strong financial reason to prioritize our brand while the program remains profitable and scalable for the brand.**

Initial Engagement

We are open to beginning this as a **20–30 hour/week engagement** with the potential to develop into a much larger long-term role.

Initially, your job will be to help us:

1. Audit our current TikTok Shop affiliate setup
2. Design the affiliate acquisition funnel
3. Establish creator qualification criteria
4. Implement creator sourcing and outreach systems
5. Establish sample approval criteria
6. Develop affiliate commission/incentive tiers
7. Build creator performance tracking
8. Launch high-volume affiliate recruitment
9. Establish a process for identifying and developing top creators
10. Build the workflow between TikTok affiliate content and our Meta advertising team

If the program scales successfully, we expect to add VAs underneath this role to handle sourcing, outreach, follow-ups, sample management, tracking, and other repetitive tasks.

**We want the person in this role to eventually lead that system rather than personally performing every repetitive task forever.**

## To Apply

Please answer the following questions in your application.

**1. What TikTok Shop affiliate programs have you personally built or managed?**

Please include approximate numbers where possible:

* Number of affiliates
* Active affiliates
* Monthly affiliate GMV
* Monthly creator outreach volume
* Samples sent per month
* Sample-to-post rate
* Content volume

**2. Walk us through how you would recruit 500+ qualified creators for a football performance brand.**

Be specific.

**3. What tools have you personally used for TikTok Shop creator sourcing, outreach, CRM, and affiliate management?**

Please specifically mention whether you've used **Euka or Reacher.**

**4. How have you structured creator commissions and performance incentives in previous programs?**

**5. How do you decide which creators should receive free samples?**

**6. How do you turn someone who posts one affiliate video into a creator who consistently posts for the brand?**

**7. Have you built or managed a VIP/top-creator program? If so, explain how it worked.**

**8. Have you taken winning TikTok affiliate content and worked with a Meta advertising team to scale that content as paid creative? Explain the workflow you used.**

**9. Have you managed VAs as part of an affiliate or creator program? If so, how did you divide responsibilities?**

**10. If you joined tomorrow, what would your first 30 days look like?**

Please do not send us a generic influencer marketing proposal.

We're specifically looking for someone who understands **TikTok Shop affiliate growth, creator performance, systems, and scale.**

# TikTok Shop Affiliate & Creator Growth Lead - Sports / DTC Brand

We're looking for an experienced **TikTok Shop Affiliate & Creator Growth Lead** to help us build and operate a large-scale, performance-driven TikTok Shop affiliate program.

**This is NOT a traditional influencer marketing role.**

We are NOT looking for someone whose primary experience is negotiating paid influencer posts, gifting products to influencers, or managing brand-awareness campaigns.

We want someone who understands how to build a **TikTok Shop affiliate machine** where creators are recruited at scale, compensated primarily through commission, developed into high-performing affiliates, and the best creators/content are identified and scaled further.

What We're Building

Our goal is to build a large network of football-focused creators and affiliates.

The basic model:

**Recruit creators at scale → Send samples to qualified creators → Get creators posting → Generate affiliate GMV → Identify top performers → Increase incentives → Develop deeper creator relationships → Turn winning creator content into paid advertising creative → Repeat**

We ultimately want a smaller group of elite creators within the larger affiliate network who:

* Post consistently
* Generate meaningful TikTok Shop GMV
* Receive increased commission and incentives
* Get early access to new products
* Produce content around product launches
* Work closely with our team
* Create content that can be tested and scaled through Meta advertising

The goal is not simply to recruit affiliates.

**The goal is to build a creator distribution and content engine**

What You'll Own

You will help build this program from the ground up and eventually take ownership of its day-to-day operation.

Responsibilities will include:

* Develop and execute our TikTok Shop affiliate growth strategy
* Source sports creators at scale
* Build automated creator outreach and follow-up systems
* Manage TikTok Shop Open and Target Collaborations
* Evaluate and approve creator sample requests
* Improve sample-to-content/posting rates
* Onboard and activate new affiliates
* Develop commission and incentive structures with our team
* Identify high-performing affiliates based on GMV, content quality, consistency, and other performance metrics
* Build deeper relationships with top-performing creators
* Coordinate early product access and launches with top affiliates
* Create creator competitions, bonuses, leaderboards, and other performance incentives
* Track creator and affiliate performance
* Identify top-performing affiliate videos
* Coordinate with our Meta advertising team to test winning creator content as paid ads
* Help secure and organize appropriate creator content/usage rights
* Build systems and SOPs that can eventually be executed by VAs
* Manage and train VAs as the affiliate program grows
* Report weekly on affiliate growth, creator activity, content volume, GMV, and key opportunities

Tools / Experience We're Interested In

Experience with some of the following is strongly preferred:

* TikTok Shop Seller Center
* TikTok Shop Affiliate Center
* TikTok Shop Open Collaboration
* TikTok Shop Target Collaboration
* GMV Max / TikTok Shop Ads
* Euka
* Reacher
* Creator CRM / outreach automation tools
* Discord creator communities
* Airtable / Google Sheets
* Creator sample management
* Affiliate commission structures
* Meta Ads creator-content workflows

You do **not** need experience with every tool listed above, but would be preferred.

We care much more about whether you've actually built or operated a successful TikTok Shop affiliate program.

Who We're Looking For

You should have direct experience with **TikTok Shop affiliates and creator commerce.**

Ideally, you've previously helped a brand:

* Recruit hundreds or thousands of affiliates
* Build high-volume creator outreach systems
* Improve creator activation rates
* Manage product samples at scale
* Generate meaningful affiliate GMV
* Build relationships with top-performing affiliates
* Create performance-based creator incentives
* Manage creator communities
* Turn affiliate content into paid advertising creative
* Build systems that VAs can execute

We're looking for someone who is **extremely performance and numbers driven.**

We care about:

**Active affiliates.
Content produced.
Sample-to-post rate.
GMV.
GMV per creator.
GMV per video.
Creator profitability.
Contribution margin.
Top creator development.
Winning advertising creative.**

Not vanity metrics.

Important: Commission-First Creator Model

Our goal is to build this program primarily around **performance-based creator compensation rather than creator retainers.**

We want our best creators to make a lot of money.

As creators prove themselves, we want to reward them through increased commissions, performance bonuses, competitions, early product access, increased exposure, and deeper relationships with the brand.

Part of your responsibility will be helping us determine how to structure these incentives so that:

**Creators have a strong financial reason to prioritize our brand while the program remains profitable and scalable for the brand.**

Initial Engagement

We are open to beginning this as a **20–30 hour/week engagement** with the potential to develop into a much larger long-term role.

Initially, your job will be to help us:

1. Audit our current TikTok Shop affiliate setup
2. Design the affiliate acquisition funnel
3. Establish creator qualification criteria
4. Implement creator sourcing and outreach systems
5. Establish sample approval criteria
6. Develop affiliate commission/incentive tiers
7. Build creator performance tracking
8. Launch high-volume affiliate recruitment
9. Establish a process for identifying and developing top creators
10. Build the workflow between TikTok affiliate content and our Meta advertising team

If the program scales successfully, we expect to add VAs underneath this role to handle sourcing, outreach, follow-ups, sample management, tracking, and other repetitive tasks.

**We want the person in this role to eventually lead that system rather than personally performing every repetitive task forever.**

## To Apply

Please answer the following questions in your application.

**1. What TikTok Shop affiliate programs have you personally built or managed?**

Please include approximate numbers where possible:

* Number of affiliates
* Active affiliates
* Monthly affiliate GMV
* Monthly creator outreach volume
* Samples sent per month
* Sample-to-post rate
* Content volume

**2. Walk us through how you would recruit 500+ qualified creators for a football performance brand.**

Be specific.

**3. What tools have you personally used for TikTok Shop creator sourcing, outreach, CRM, and affiliate management?**

Please specifically mention whether you've used **Euka or Reacher.**

**4. How have you structured creator commissions and performance incentives in previous programs?**

**5. How do you decide which creators should receive free samples?**

**6. How do you turn someone who posts one affiliate video into a creator who consistently posts for the brand?**

**7. Have you built or managed a VIP/top-creator program? If so, explain how it worked.**

**8. Have you taken winning TikTok affiliate content and worked with a Meta advertising team to scale that content as paid creative? Explain the workflow you used.**

**9. Have you managed VAs as part of an affiliate or creator program? If so, how did you divide responsibilities?**

**10. If you joined tomorrow, what would your first 30 days look like?**

Please do not send us a generic influencer marketing proposal.

We're specifically looking for someone who understands **TikTok Shop affiliate growth, creator performance, systems, and scale.**

Job Overview:
We are looking for an experienced, detail-oriented bookkeeper to complete a one-time historical bookkeeping project to wrap up our entity. We have up to 500 total transactions spanning across the past 3 years distributed across 3 corporate bank accounts (including international transfer platforms) and corporate credit cards.

No ongoing monthly maintenance is needed. We need a clean, fully reconciled set of financial statements delivered for tax preparation and final corporate closeout.

Key Responsibilities & Scope:
Data Import & Integration: Import CSV/bank feeds for 3 bank accounts and credit card accounts for the past 3 years into an accounting ledger (QuickBooks Online, Xero, or Wave).

Transfer Matching: Correctly identify and pair inter-account transfers between credit cards, bank accounts, and payment platforms so funds are not double-counted as income or expenses.

Transaction Categorization: Properly categorize all transactions across the Chart of Accounts.

Account Reconciliation: Reconcile all bank and credit card accounts to ensure zero discrepancy between the ledger and ending bank statement balances.

Financial Deliverables: Produce final, exportable versions of:

Profit & Loss Statement (P&L) (Annual & Cumulative)

Balance Sheet (BS)

General Ledger & Trial Balance

Requirements / Qualifications:
Proven experience in historical bookkeeping cleanup and multi-account reconciliation.

Proficient in QuickBooks Online, Xero, or Wave Financial.

Experience handling multi-currency and international transfer matching across startup financial platforms.

Strong communication skills and ability to complete the project efficiently with minimal oversight.

Project Details:
Project Type: One-time / Fixed-price project

Total Transaction Volume: Up to 500 transactions across 3 years

Estimated Time: 6–10 hours

How to Apply:
Please submit your proposal with:

Your experience with historical cleanup and transfer matching.

Your fixed quote for completing this project.

Your estimated turnaround time.

Customer Service and Android Technical Support — Three Long-Term Positions

We are expanding our international customer-support and technology team and are looking for three dependable people interested in stable, long-term work.

This is a varied, hands-on position combining:

Customer service
Android technical support
TeamViewer remote assistance
Sales and purchasing assistance
Customer retention and marketing support
CRM and general administration

The starting rate is $3 per hour. Full product training, mentoring and structured onboarding will be provided.

We are particularly interested in applicants with previous senior-support, supervisory or leadership experience. This is not initially a dedicated management position: everyone must be willing to perform hands-on customer support, technical support, sales and administrative work. However, strong performers may progress into positions with greater responsibility as the team expands.

Pay and working hours
Starting rate: $3 per hour
Long-term work for successful applicants
Our customer-service operation is open from 07:00 to 23:00 Central European time, using CET or CEST as seasonally applicable
Flexible scheduled shifts of approximately 5–10 hours per working day
Weekend availability is essential
Exact schedules will be agreed according to availability and operational requirements
Increased responsibility and progression are available based on reliability, ability and performance

Team members must remain online, responsive and focused throughout their scheduled paid shifts. If an internet, electricity, health or attendance problem occurs, you must communicate immediately rather than disappearing without explanation.

Responsibilities
Help customers troubleshoot Android TV devices and applications
Connect to customer devices using TeamViewer, AnyDesk or similar remote-support software
Install, update and configure Android applications
Diagnose technical problems methodically and resolve them safely
Explain technical steps clearly and patiently
Respond promptly to customer messages in professional English
Understand customer requirements and help customers select and purchase suitable products or services
Assist with customer follow-ups, retention, sales and marketing activities
Update customer records, CRM systems and spreadsheets accurately
Follow documented procedures consistently
Protect confidential customer and company information
Identify and escalate problems that cannot be safely resolved
Take ownership of assigned work without requiring constant reminders
Work independently and use initiative when appropriate
Cooperate with colleagues and assist during busy periods
Learn new systems, products and processes
Suggest practical improvements when appropriate
Essential requirements
Good written and spoken English
Minimum English typing speed of 35 words per minute with at least 95% accuracy
Practical knowledge of Android devices and applications
Experience using TeamViewer, AnyDesk or similar remote-support software
Strong customer-service skills
Confidence assisting customers with sales and purchasing enquiries
A reliable Windows computer
Stable primary internet with backup internet available
Suitable power-backup arrangements
Reliable attendance and punctuality
Honest, clear and proactive communication
Strong work ethic and a positive, can-do attitude
Ability to follow instructions and documented procedures accurately
Ability to work independently without constant supervision
Ability to cooperate as part of a team
Willingness to learn and accept constructive feedback
Availability for flexible 5–10-hour shifts, including weekends
Ability to handle customer and company information confidentially
Desirable experience

The following would be useful but is not essential:


Previous leadership, supervisory or senior-support experience
CRM and customer-record management
Google Sheets, Excel or similar software
Sales, customer retention or marketing support
Android TV boxes, streaming devices or remote device support
Working with international customers

We value attitude, reliability, initiative and learning ability as much as existing technical knowledge. You do not need to know our products before joining because full training will be provided.

However, you must have genuine technical aptitude, good English, commercial awareness and a strong work ethic. Limited experience is acceptable when supported by genuine ability and a willingness to learn. Exaggerated or false experience is not acceptable.

We are building a positive, enjoyable and expanding international team. This position suits someone who wants more than a short freelance project and is interested in developing their skills, accepting responsibility and becoming an important part of the business.

Selection process

Shortlisted applicants will complete:

An English writing, typing and technical-aptitude assessment
Verification of a minimum English typing speed of 35 WPM with at least 95% accuracy
A practical Android and TeamViewer exercise involving device connection, diagnosis and troubleshooting
An initial paid practical trial
Structured training and supervised onboarding if selected

AI writing assistance is not automatically a problem, but every answer and experience claim must be truthful, personally understood and explainable during the practical assessment.

Application questions

Please answer every question personally:

Describe your experience using TeamViewer, AnyDesk or similar remote-support software. What tasks have you personally completed?
Which Android devices and applications have you personally configured or troubleshot?
A customer reports: “My Android TV application was working yesterday, but it will not open today.” Write the exact first reply you would send to the customer.
After receiving the customer’s reply, what would you check first, and why?
What is your current English typing speed in words per minute? Include your accuracy percentage and state how it was measured.
Describe your Windows computer, headset, workspace, internet connection, backup internet and power-backup arrangements.
Which days and hours are you consistently available between 07:00 and 23:00 CET/CEST?
Are you comfortable working flexible shifts of between 5 and 10 hours, including weekends?
Do you currently have another job or client commitment that could overlap with these working hours?
Describe any customer-service, sales, customer-retention or marketing experience you have.
Have you previously supervised colleagues or taken responsibility for a team? If yes, explain exactly what you personally managed.
Give an example of a work problem you solved using your own initiative.
Why are you interested in a stable, long-term position with our team?
If selected, when could you begin?
Are you willing to begin at the advertised rate of $3 per hour?

Begin your application with the words “Reliable Android Support” to confirm that you have read the complete description.

Grace Promotion is organizing benefit concerts at Barclays Center (Brooklyn) and BMO Stadium (Los Angeles) to raise funds for families displaced by the California Fires.

Our model is simple: 75% of every donation and Concert profit goes directly to Organizations building homes for those who lost theirs.
The remaining 25% covers concert production, salaries of Promoters.

We want to raise the venue money first. Our website will be rebuildingcalifornia.org


Best regards,
Ed Koster
Grace Promotion
Every dollar counts. Every person who gives is part of the rebuild.

We are an Australian transport and last-mile delivery business looking for an experienced Fractional CFO / Commercial Finance Analyst to assist the business owner with financial analysis, cash-flow management and improving the profitability of one of our major delivery contracts.

This is initially a small, part-time engagement with the opportunity to become an ongoing role.

We are open to experienced international candidates and are looking for someone who can provide strong financial analysis at a competitive hourly rate.

About the Role

Our business receives revenue through multiple streams, including:

* Delivery/service income
* Vehicle/lease-related income
* Performance/incentive payments where applicable

We also have significant operating costs including:

* Driver wages
* Superannuation and employee costs
* Vehicle/fleet costs
* Insurance
* Fuel
* Repairs and vehicle damage
* Management and administration
* Recruitment and training
* Other operating expenses

We want someone who can bring all of this together and help us understand the true profitability and cash flow of the contract.

Responsibilities

You will work directly with the Director to:

* Review our current financial position
* Analyse contract revenue against operating costs
* Separate and analyse different revenue streams
* Analyse labour and fleet costs
* Calculate profit per route and per vehicle
* Identify areas where costs can be reduced
* Identify margin leakage and opportunities to improve profitability
* Build a simple management P&L for the contract
* Develop a 13-week cash-flow forecast
* Create budget vs actual reporting
* Forecast future revenue, expenses and cash requirements
* Model different business scenarios
* Help determine break-even points
* Review the financial impact of adding more vehicles/drivers
* Create a simple financial dashboard for the Director
* Provide recommendations rather than simply reporting numbers

What We Are Looking For

Experience in one or more of the following:

* FP&A
* Fractional CFO services
* Commercial finance
* Management accounting
* Financial modelling
* Cash-flow forecasting
* Budgeting and forecasting
* Xero
* Excel / Google Sheets

Experience working with Australian businesses is highly desirable.

Experience with transport, logistics, delivery, fleet-based or labour-intensive businesses would be a major advantage.

Starting Arrangement

We want to start small and cost-effectively.

Initially, we would like someone to review the business and build the financial model/dashboard.

After the initial setup, this could become an ongoing position involving a few hours each week/month to:

* Update financial reporting
* Review cash flow
* Review profitability
* Identify financial issues
* Meet with the Director
* Recommend improvements

If the relationship works well and you demonstrate value, there is potential for the role and hours to increase as the business grows.

When Applying

Please answer the following:

1. What experience do you have with FP&A, commercial finance or fractional CFO work?
2. Have you worked with Australian businesses and Xero?
3. Have you worked with logistics, transport, delivery or fleet-based businesses?
4. Have you built a 13-week cash-flow forecast before?
5. Please provide an example of a financial dashboard or financial model you have built.
6. If a business receives service revenue and vehicle lease revenue but has significant labour and fleet costs, how would you determine the true profitability of the contract?
7. What is your hourly rate?
8. How many hours per week would you recommend initially for a business like ours?

MARKETING GROWTH & AUTOMATION SPECIALIST
GoHighLevel • Funnels • Email Marketing • Meta Ads • Automatisation
Entreprise : Groupe Transforme
Poste : Marketing Growth & Automation Specialist
Type : À distance
Collaboration directe avec la CEO
À PROPOS DE GROUPE TRANSFORME
Groupe Transforme est une entreprise de transformation personnelle et de littératie financière qui accompagne les femmes professionnelles à prendre le contrôle de leurs finances, développer leur potentiel et transformer leur vie à travers des principes divins.
Notre mission est ambitieuse : aider des millions de femmes à transformer leur relation avec l’argent et leur vie.
Nous avons déjà accompagné des milliers de femmes dans leur transformation.
Nous sommes actuellement dans une phase de croissance importante.
Notre objectif est de structurer et d’optimiser notre système marketing afin de passer à plusieurs six chiffres de revenus et de construire une entreprise capable de générer sept chiffres de revenus et plus.
Et pour y arriver, nous recherchons un expert en marketing.

LE POSTE
Nous recherchons une personne passionnée par le marketing, les funnels, l’automatisation et la croissance, capable de prendre en charge une grande partie de notre infrastructure marketing.
Tu travailleras directement avec la CEO et tu seras une personne clé dans l’exécution de notre stratégie d’acquisition et de conversion.
Nous ne cherchons pas une personne qui attend qu’on lui dise exactement quoi faire.
Nous cherchons quelqu’un qui peut recevoir un objectif et répondre :
« Voici comment je te propose de le faire. »
Tu dois être capable de réfléchir, proposer, construire, tester, analyser et optimiser.

TES RESPONSABILITÉS
1. FUNNELS & GOHIGHLEVEL
Tu seras responsable de la création et de l’optimisation de nos tunnels de vente dans GoHighLevel.
Tu devras notamment :
Créer des landing pages et funnels complets
Construire les différentes étapes d’un funnel
Configurer les formulaires et les calendriers
Mettre en place les workflows et automatisations
Configurer les triggers, tags, pipelines et actions
Connecter les différentes étapes du parcours client
Tester les funnels de A à Z
Identifier les problèmes de conversion
Optimiser les funnels existants
Suivre les performances et proposer des améliorations
GoHighLevel doit être un outil que tu maîtrises réellement.
Nous recherchons un niveau intermédiaire avancé à expert.

2. EMAIL MARKETING & AUTOMATISATION
Tu seras également responsable de notre système d’email marketing.
Tu devras pouvoir :
Créer des séquences d’emails
Écrire des emails de conversion
Construire des welcome sequences
Créer des nurture sequences
Créer des séquences de lancement
Créer des séquences de vente
Créer des séquences de relance
Mettre en place les automatisations
Segmenter les contacts
Configurer les triggers et conditions
Tester les séquences
Analyser les performances
Optimiser les taux d’ouverture et de clic
Optimiser les conversions
Tu dois comprendre qu’un email n’est pas simplement « un beau texte ».
Tu dois comprendre le parcours psychologique du prospect et l’objectif commercial derrière chaque email.

3. META ADS
Tu participeras également à la gestion de notre acquisition payante.
Tu devras être capable de :
Créer et configurer des campagnes Meta
Créer les audiences
Mettre en place les campagnes de retargeting
Créer différentes variations publicitaires
Rédiger les copies publicitaires
Proposer des hooks
Créer des angles marketing
Définir et gérer les budgets publicitaires
Suivre les KPIs
Analyser les résultats
Identifier les campagnes gagnantes
Tester différentes créatives
Optimiser les campagnes
Tu dois comprendre les métriques importantes :
CTR • CPC • CPM • CPL • CPA • ROAS • Conversion Rate
Et surtout comprendre ce que ces chiffres veulent dire pour le business.

4. COPYWRITING & CONVERSION
Nous recherchons quelqu’un qui possède également un bon instinct marketing.
Tu dois pouvoir contribuer à la création de :
Headlines
Hooks
Landing pages
Pages de vente
Emails
Publicités
CTA
Scripts courts
Séquences de nurturing
Messages de retargeting
Tu n’as pas besoin d’être copywriter senior, mais tu dois savoir écrire une copie qui capte l’attention, crée du désir et pousse à l’action.

5. CRÉATION DE VISUELS & LEAD MAGNETS
Tu seras également amené(e) à créer des supports marketing simples et professionnels.
Par exemple :
Guides PDF
Lead magnets
Workbooks
Ebooks
Checklists
Présentations
Visuels publicitaires
Créatives pour les campagnes
Supports promotionnels
La maîtrise de Canva est fortement souhaitée.
Tu dois avoir un bon œil visuel et comprendre les principes fondamentaux du design marketing.

6. AUTOMATISATIONS & INTÉGRATIONS
Tu dois être à l’aise avec les outils d’automatisation et les intégrations.
Une bonne connaissance de :
Zapier
Make
Webhooks
Intégrations API de base
Google Sheets
GoHighLevel
Outils marketing
est fortement souhaitée.
Tu dois être capable de connecter les outils entre eux et de résoudre les problèmes lorsque quelque chose ne fonctionne pas.

7. EXCEL / GOOGLE SHEETS & ANALYSE
Tu dois être confortable avec Excel et/ou Google Sheets.
Tu seras amené(e) à :
Organiser des données
Créer des tableaux de suivi
Suivre les campagnes
Analyser les performances
Suivre les leads
Suivre les conversions
Créer des reportings marketing
Identifier les tendances
Nous voulons quelqu’un qui ne se contente pas de faire du marketing, mais qui comprend les chiffres derrière le marketing.

LE PROFIL QUE NOUS RECHERCHONS
Tu es probablement la bonne personne si :
Tu es passionné(e) par le marketing digital
Tu adores construire des funnels
Tu maîtrises GoHighLevel
Tu comprends les mécanismes de conversion
Tu es à l’aise avec l’automatisation
Tu comprends Meta Ads
Tu sais écrire de bonnes copies
Tu as un bon sens visuel
Tu es analytique
Tu es très organisé(e)
Tu es autonome
Tu es proactif(ve)
Tu es curieux(se)
Tu apprends rapidement
Tu cherches constamment à améliorer les performances
Tu prends des initiatives
Tu sais résoudre des problèmes sans attendre qu’on te donne la solution
Et surtout…
Tu es un(e) builder.
Tu aimes prendre une idée et la transformer en système fonctionnel.

CE POSTE N’EST PAS POUR TOI SI…
Tu as besoin qu’on te dise quoi faire à chaque étape.
Tu n’as jamais construit de funnel.
Tu connais GoHighLevel uniquement en théorie.
Tu n’es pas à l’aise avec les chiffres.
Tu n’aimes pas tester et optimiser.
Tu attends toujours des instructions détaillées.
Tu n’es pas capable de rechercher une solution par toi-même.
Tu n’es intéressé(e) que par l’exécution et pas par la stratégie.
Tu considères les erreurs techniques comme « le problème de quelqu’un d’autre ».
Nous avons besoin d’une personne qui prend ownership.
CE QUE NOUS OFFRONS
Tu travailleras directement avec la CEO de Groupe Transforme.
Tu auras l’occasion de participer directement à la croissance d’une entreprise ambitieuse dans les domaines de la transformation personnelle et de la littératie financière.
Tu ne seras pas simplement une personne qui « exécute des tâches ».
Tu seras impliqué(e) dans :
La stratégie → l’acquisition → les funnels → l’automatisation → la conversion → l’optimisation → la croissance.
Si tu es performant(e), autonome et que tu apportes réellement de la valeur, il existe une possibilité d’évolution importante avec l’entreprise.

EXPÉRIENCE REQUISE

Obligatoire
Expérience concrète en marketing digital
Expérience dans la création de funnels
Maîtrise intermédiaire/avancée de GoHighLevel
Expérience avec les automatisations
Expérience avec l’email marketing
Expérience avec Meta Ads
Bonne capacité rédactionnelle
Bonne compréhension des conversions et KPIs
Excellente organisation
Très grande autonomie
Atouts importants
Zapier
Make
Canva
Excel / Google Sheets
Copywriting
Lead generation
Infoprenariat / coaching / formation en ligne
E-commerce ou business digital
Expérience avec des offres high-ticket

IMPORTANT — VIDÉO LOOM OBLIGATOIRE
Nous voulons voir la personne derrière le CV.
Pour postuler, tu dois obligatoirement enregistrer une courte vidéo Loom de 3 à 5 minutes dans laquelle tu te présentes et nous parles de ton expérience.
Dans ta vidéo, réponds notamment aux questions suivantes :
Qui es-tu et quel est ton parcours ?
Depuis combien de temps travailles-tu dans le marketing digital ?
Quelle est ton expérience avec GoHighLevel ?
Quels types de funnels as-tu déjà construits ?
Quelle est ton expérience avec Meta Ads ?
Quelle est ton expérience en email marketing et automatisation ?
Quels outils maîtrises-tu : GoHighLevel, Make, Zapier, Canva, Excel, etc. ?
Parle-nous d’un projet marketing dont tu es particulièrement fier/fière.
Pourquoi penses-tu être la bonne personne pour Groupe Transforme ?

⚠️ ATTENTION
La vidéo Loom est obligatoire.
Toute candidature sans vidéo Loom ne sera pas considérée.
Nous ne recherchons pas simplement un CV.
Nous voulons comprendre qui tu es, comment tu réfléchis, ton niveau d’expertise et surtout ta passion pour le marketing.

COMMENT NOUS ÉVALUERONS TA PERFORMANCE
Tu ne seras pas évalué(e) uniquement sur le nombre de tâches réalisées.
Nous regarderons notamment :
Leads générés
Coût par lead
Taux de conversion
Performance des funnels
Performance des emails
ROAS
Revenus générés
Qualité des automatisations
Vitesse d’exécution
Capacité à résoudre les problèmes
Capacité à proposer des améliorations
Notre objectif est simple :
Construire une machine marketing qui fonctionne et qui peut scaler.

POURQUOI NOUS REJOINDRE ?
Si tu veux simplement « faire un job », ce poste n’est probablement pas pour toi.
Mais si tu veux rejoindre une entreprise en croissance, travailler directement avec une CEO ambitieuse et construire les systèmes marketing qui permettront à l’entreprise de passer au niveau supérieur, alors nous voulons te connaître.
Nous recherchons quelqu’un qui veut grandir avec l’entreprise.
Quelqu’un qui voit une opportunité là où les autres voient un problème.
Quelqu’un qui pense :
« Comment pouvons-nous faire mieux ? »
Si cette personne, c’est toi, nous avons hâte de te rencontrer.

POUR POSTULER
Merci de nous transmettre :
Ton CV
Ta vidéo Loom obligatoire de 3 à 5 minutes
Une présentation de toi
Ton expérience avec GoHighLevel
2 à 3 exemples de funnels que tu as construits
Des exemples de campagnes Meta Ads que tu as gérées
Des exemples d’emails ou séquences que tu as créés
Ton portfolio, si disponible
Tes disponibilités
Tes prétentions salariales / tarifaires

🚨 IMPORTANT
Les candidatures sans vidéo Loom ne seront pas considérées.
Les candidats sans expérience concrète avec GoHighLevel ne seront pas retenus.

Project Description:

We are looking for a QuickBooks Online specialist with solid experience in accounting for import companies to lead the integration and standardization of accounting processes across three related companies. One of them is focused on vehicle importation, while the other two operate in the purchase of vehicles domestically.

Currently, the group has a single Treasury department supporting all three companies, but reporting is handled manually through spreadsheets. This has created significant limitations in management visibility and timely decision-making.

Project Scope:

The main goal is to migrate and implement the essential accounting processes of the three companies into QBO, ensuring clear, timely, and reliable information for management. Priority areas include:

Payroll
Inventory
Accounts Receivable (AR)
Future commitments and debt management
Balance sheet
Cash flow

A critical point of the project is managing multiple bank accounts shared among the three companies. Clear, accurate tracking of income and expenses for each entity is required, avoiding confusion between them.

Duration and Training:

The project is estimated to take 3 months, during which the specialist will also train the administrative team of all three companies to ensure proper adoption and continued use of the platform once implementation is complete.

Requirements:

Proven experience with QuickBooks Online (QBO), certification preferred.
Prior experience in accounting for import companies (handling tariffs, import taxes, associated costs, etc.).
Experience implementing accounting systems for multiple related entities/companies.
Ability to structure and automate management reports (cash flow, balance sheet, AR, etc.).
Ability to train non-technical teams on using the tool.
Strong communication and process documentation skills.

We are looking for an experienced AI Engineer / Automation Specialist with advanced n8n expertise to join our team.
You will be responsible for building scalable automations, implementing AI/LLM workflows, maintaining Monday.com integrations, and supporting BI dashboards and reporting.
Your mission: eliminate manual work, build reliable automation systems, and maintain clean, scalable, and exceptionally organized workflow architecture.

Responsibilities:
Design, build, and maintain advanced n8n workflows, ensuring impeccable organization, architecture, documentation, and scalability.
Build and troubleshoot Monday.com automations, cross-board logic, notifications, and integrations.
Work with APIs, webhooks, JSON, conditional logic, error handling, monitoring, and retries.
Build AI-powered workflows using OpenAI/LLMs and OCR, including document/image processing and structured data extraction.
Engineer prompts for consistent outputs and integrate AI results into business workflows.
Build and maintain BI dashboards and reporting using tools such as Power BI, Looker Studio, Tableau, Metabase, or Monday.com.
Create lightweight data pipelines connecting Monday.com, Google Sheets, n8n, and other business systems.
Monitor data quality and produce recurring reports and business insights.

Advanced/Expert-level n8n experience is required.
Proven experience building complex, production-ready automation workflows.
Strong understanding of clean and scalable workflow architecture.
Experience with OpenAI/LLMs, APIs, webhooks, JSON, and third-party integrations.
Experience with Monday.com and BI/reporting tools.
Strong troubleshooting, documentation, and analytical skills.
Advanced English.
JavaScript/Python and Make/Zapier experience are a plus.

Most important: We're looking for someone who builds workflows that are not only functional, but clean, organized, scalable, reliable, and easy to maintain.

Evening Case Coordinator / Client Concierge

Remote | 4 hours per day | Monday–Friday

We are a fast-growing dental laboratory working with dental practices across the USA.

We’re looking for an extremely organised, proactive person to manage our evening case coordination and client communication.

Your role

You will be responsible for keeping our cases moving and ensuring our clients are kept updated throughout the process.

Your daily responsibilities will include:

* Managing client communication through WhatsApp
* Monitoring active dental cases
* Updating our internal Google Sheets
* Managing and checking case files within Dropbox
* Checking that new cases have all required files and information
* Coordinating with our design and manufacturing teams
* Following up immediately when information or files are missing
* Monitoring deadlines and identifying cases at risk of delay
* Providing clients with clear, professional case updates
* Escalating important issues to management
* Making sure every active case has a clear status and next action

What we’re looking for

You must be:

* Extremely organised
* Reliable and consistent
* Confident communicating with US clients
* Excellent written English
* Comfortable using WhatsApp, Google Sheets and Dropbox
* Able to manage multiple cases simultaneously
* Proactive rather than waiting to be told what to do
* Comfortable working in a fast-moving environment

Dental or dental laboratory experience would be a major advantage, but attitude, communication and organisation are more important.

What success looks like

At the end of every shift:

Every client has been answered.
Every case is updated.
Every deadline has been checked.
Every problem has an owner.
Every case has a next action.

We’re looking for someone who wants to take ownership of this part of the business and potentially grow into a larger operations/client management role as the company continues to expand.

To apply: Send a short introduction explaining your previous experience, the systems you’ve worked with, your availability, and why you think you’d be good at managing a high-volume client workflow.

Lead Generation & Commercial Real Estate Research Specialist – Fresno Counties
We are looking for a detail-oriented Lead Generation / Commercial Real Estate Research Specialist to build a highly accurate, up-to-date spreadsheet of commercial properties suitable for an automotive mechanic/repair shop in Central California.
This is a results-based research project, not simply a list-scraping assignment. We are willing to pay more per lead for records that include verified owner information, direct contact information, zoning/use information, current asking terms, and other details that help us actually contact the decision-maker and evaluate the property.
Target Area
Primary search area:
* Fresno County, California
* Fresno
* Clovis
* Madera
* Kerman
* Sanger
* Other Fresno or communities with suitable commercial/industrial properties
Properties We Are Looking For
The primary objective is to identify commercial buildings that could potentially be used as a mechanic shop, automotive repair facility, service garage, automotive business, or similar use.
Preferred property characteristics:
* Approximately 2,000–8,000 square feet
* Commercial, industrial, service-commercial, flex, warehouse, automotive, or similar property
* Suitable for automotive repair/mechanic operations
* Roll-up doors or vehicle-accessible bays preferred
* Parking and/or yard space preferred
* Good vehicle access
* Existing auto-related use is especially desirable
* Buildings previously used as mechanic shops, tire shops, body shops, transmission shops, dealerships, service centers, fleet facilities, warehouses, or similar operations should be prioritized
* For lease, lease-to-own, owner financing, or purchase opportunities may all be included
* Vacant buildings and potentially available off-market properties are welcome
IMPORTANT: Listings Must Be Current
We do not want outdated commercial real estate listings.
Each lead should be researched and verified as recently as possible.
Priority should be given to:
1. Active listings
2. Recently listed properties
3. Recently verified available properties
4. Owner-direct opportunities
5. Off-market properties where the owner can be identified and there is a reasonable possibility the property could be leased or sold
Please identify the date the property was last verified.
Listings that have already been leased, sold, withdrawn, or have not been updated for a long period should not be submitted unless specifically marked as an off-market owner prospect.
Spreadsheet Information Required
Each property should preferably include the following columns:
PROPERTY INFORMATION
* Lead ID
* Property name, if applicable
* Street address
* City
* County
* ZIP code
* APN/parcel number, if available
* Property type
* Current use
* Previous use, if known
* Building square footage
* Lot square footage/acres
* Number of buildings
* Number of automotive/service bays, if applicable
* Number of roll-up doors
* Ceiling height, if available
* Parking information
* Fenced yard information
* Street frontage
* Major cross streets
* Freeway/highway proximity
* Year built, if available
LISTING INFORMATION
* For Lease / For Sale / Lease-to-Own / Off-Market
* Asking rent
* Rent per square foot
* NNN/CAM charges, if applicable
* Estimated monthly rent
* Asking sale price
* Price per square foot
* Deposit information
* Lease term
* Available date
* Listing date
* Days on market, if available
* Listing status
* Date availability was last verified
* Listing URL/source
AUTOMOTIVE / ZONING INFORMATION
One of the most valuable parts of this assignment is determining whether the property could realistically support an automotive repair operation.
Include whenever reasonably available:
* Current zoning
* Zoning designation
* General plan designation, if relevant
* Automotive repair permitted?
* Automotive repair permitted by right?
* Conditional Use Permit potentially required?
* Existing automotive use?
* Previous automotive use?
* Possible grandfathered/nonconforming automotive use?
* Outdoor vehicle storage permitted?
* Tow/storage yard potential?
* Auto body/paint use permitted?
* Notes regarding city/county zoning requirements
* Planning department/source used to verify information
If zoning cannot be confirmed, clearly write "Needs Verification."
Do not guess.
OWNER INFORMATION – HIGH PRIORITY
We strongly prefer owner-direct leads whenever possible.
For each property, research publicly available ownership information and include:
* Property owner name
* Individual or business entity
* LLC/corporation name
* Owner mailing address, when publicly available
* Owner business phone number, when publicly available
* Owner business email, when publicly available
* Ownership entity
* Secretary of State/business entity information where relevant
* Property ownership source
* Owner-direct contact available? YES/NO
Please distinguish clearly between:
OWNER DIRECT
and
BROKER / PROPERTY MANAGEMENT COMPANY
Broker / Agent Information
If represented by a commercial real estate company, provide:
* Brokerage/company
* Listing agent
* Agent phone
* Agent email
* Office phone
* Listing URL
* Property manager, if different
* Property management company
* Property management phone/email
* Leasing contact
* Agent license number, if readily available
Decision-Maker Classification
Every lead should have a column identifying:
* Owner Direct
* Owner Representative
* Property Manager
* Commercial Broker
* Listing Agent
* Unknown
We want to know who actually has authority to negotiate the property.
Comparable Properties / Market Information
For stronger leads, additional research may include:
* Comparable nearby lease listings
* Comparable sales
* Typical price per square foot
* Typical lease rate per square foot
* Nearby automotive businesses
* Vacancy in the immediate area
* Recent commercial sales nearby
* Estimated market rent
* Whether asking rent appears below, at, or above market
This additional research will qualify the lead for the higher payment tier.
Lead Sources
Researchers may use legitimate public and commercial sources such as:
* Commercial real estate listing websites
* Brokerage websites
* County assessor/property records
* City and county GIS/property databases
* Secretary of State/business records
* Planning/zoning maps
* Commercial property management websites
* Google Maps
* Business directories
* Publicly available property ownership records
* Commercial real estate broker websites
* Public business contact information
* Direct verification with brokers/property managers when appropriate
All owner/contact research must come from lawful and publicly available sources.
Payment
This project is paid per qualified lead.
Payment range:
$0.10–$0.25 per accepted property lead, depending on completeness and quality.
Examples:
$0.10 Basic Lead
Current property listing with:
* Address
* City/ZIP
* County
* Square footage
* Asking price/rent
* Listing URL
* Broker contact
$0.15 Enhanced Lead
Everything above plus:
* Zoning
* Automotive-use information
* APN
* Property details
* Agent phone/email
* Recent verification
$0.20 High-Quality Lead
Everything above plus:
* Verified ownership entity
* Owner name
* Owner mailing/business contact information
* Broker vs. owner clearly identified
* Zoning/use research
* Strong property details
$0.25 Premium & Foreclosure Lead
Highly researched lead containing most available information, including:
* Current/verified availability
* Property details
* Complete listing information
* Owner/entity research
* Direct owner contact when publicly available
* Broker/property manager contact
* Zoning and automotive-use research
* APN
* Comparable property/market information
* Clear notes explaining why the property may work for a mechanic shop
What Will NOT Be Paid For
We will reject:
* Duplicate properties
* Clearly expired listings
* Properties already sold or leased without being labeled as off-market prospects
* Residential properties
* Properties under 2,000 square feet unless exceptionally relevant
* Properties over 8,000 square feet unless exceptionally relevant
* Properties clearly unsuitable for automotive use
* Missing addresses
* Fake/generated contact information
* Unverified information presented as fact
* Duplicate listings from multiple websites presented as separate leads
* Properties outside Fresno or Madera County unless requested
* Lists copied directly from a single website without additional research
Quality Over Quantity
We would rather receive 100 thoroughly researched, actionable leads than 1,000 low-quality listings.
The purpose of this project is to allow us to immediately contact:
1. Property owners
2. Property managers
3. Commercial real estate brokers
and begin negotiating for a mechanic shop location.
Spreadsheet Organization
The successful candidate must provide the project in Google Sheets, Excel, or CSV format.
The spreadsheet should be sortable/filterable by:
* County
* City
* ZIP
* Square footage
* Lease vs. sale
* Monthly rent
* Sale price
* Zoning
* Automotive use
* Owner direct
* Broker represented
* Contact available
* Listing status
* Verification date
* Lead quality level
Please include a separate Notes column for important findings.
Ideal Candidate
We are especially interested in candidates with experience in:
* Lead generation
* Skip tracing for legitimate business/property research
* Commercial real estate research
* Property ownership research
* Real estate prospecting
* County assessor research
* GIS/property databases
* Commercial leasing
* Zoning research
* Data mining
* Spreadsheet/data entry
* Commercial property management
* Real estate virtual assistant work
Knowledge of Fresno County, Madera County, Central California commercial real estate, or automotive property requirements is a major plus.
Application Instructions
When applying, please answer these questions:
1. What commercial real estate or lead-generation research experience do you have?
2. Have you researched property owners through assessor, GIS, or public business records?
3. Can you distinguish between the property owner, property manager, listing broker, and leasing agent?
4. Are you comfortable researching zoning and whether automotive repair is an allowable use?
5. What sources would you use to identify active Fresno and Madera County commercial properties?
6. How would you verify that a listing is still active?
7. How many detailed leads could you reasonably provide?
8. Can you provide a sample of 3–5 properties showing how you would organize the spreadsheet?
9. Are you comfortable working under a $0.10–$0.25 per accepted lead payment structure based on the quality and completeness of each lead?
The sample will be used primarily to evaluate your research method and spreadsheet organization. Do not submit hundreds of leads before being selected.
This may become an ongoing lead-generation position for a researcher who consistently provides accurate, current, actionable commercial real estate leads.
ADD TO INDEED AD — FORECLOSURE / DISTRESSED PROPERTY RESEARCH IS HIGHEST PRIORITY
HIGHEST PRIORITY: Foreclosures, Pre-Foreclosures & Distressed Commercial Properties
The most important part of this assignment is identifying commercial and industrial properties in Fresno County and Madera County that are in foreclosure, pre-foreclosure, default, auction, REO/bank-owned status, tax-default status, or otherwise financially distressed.
I am especially interested in properties that could be purchased and converted or continued as an automotive mechanic shop, repair facility, service garage, warehouse, industrial shop, or similar automotive-related business.
Target size remains approximately:
2,000–8,000 square feet
However, exceptionally attractive foreclosure opportunities slightly outside this range may still be included.
Foreclosure Categories to Search
The researcher should actively search for:
* Notice of Default / NOD properties
* Pre-foreclosure properties
* Notice of Trustee Sale properties
* Upcoming trustee-sale/auction properties
* Postponed foreclosure sales
* Recently scheduled foreclosure sales
* Bank-owned / REO commercial properties
* Lender-owned commercial properties
* Recently foreclosed properties
* Tax-defaulted commercial properties
* Tax-sale properties
* Distressed commercial properties
* Vacant commercial or industrial buildings with signs of financial distress
* Mechanic shops or automotive properties facing foreclosure
* Industrial properties facing foreclosure
* Off-market distressed properties
* Properties where foreclosure may potentially be resolved through a negotiated sale before auction
OWNER INFORMATION IS CRITICAL FOR PRE-FORECLOSURES
For foreclosure and pre-foreclosure leads, I want the researcher to make a strong effort to identify the actual legal property owner using lawful, publicly available sources.
For each foreclosure lead, include as much of the following as is publicly available:
* Property address
* City
* County
* ZIP code
* APN / parcel number
* Property owner name
* Ownership entity/LLC/corporation
* Owner mailing address
* Publicly available business phone
* Publicly available business email
* Secretary of State entity information, where applicable
* Registered business information
* Property ownership source
* Owner-direct contact available: YES/NO
* Whether owner appears to occupy/use the property
* Current business operating at the property, if any
* Business name
* Business phone number
* Business website
* Property manager, if applicable
* Broker, if applicable
Do not invent, guess, or misrepresent private contact information. Information should come from lawful public records, legitimate commercial databases, public business records, or other authorized sources.
Foreclosure Information Required
Create separate spreadsheet columns for:
* Foreclosure Status
* Pre-Foreclosure / NOD / Trustee Sale / REO / Tax Default / Other
* Notice of Default filing date
* Notice of Trustee Sale filing date
* Scheduled auction date
* Scheduled auction time
* Auction location
* Trustee name
* Trustee phone
* Trustee website, if available
* Trustee sale number
* Lender/beneficiary
* Original loan amount, if available
* Estimated outstanding balance, if publicly available
* Default amount, if publicly available
* Opening bid, if available
* Auction starting bid
* Prior liens, if identifiable
* Tax delinquency information
* Foreclosure document/source
* Date information was last verified
* Current foreclosure status as of verification date
Foreclosure information changes quickly. Every foreclosure lead should include a "Last Verified" date.
VERY IMPORTANT — PRE-FORECLOSURE OPPORTUNITIES
I am particularly interested in properties where the owner still owns the building but is facing foreclosure.
The goal is to identify these properties early enough that I may be able to contact the owner regarding a legitimate potential purchase or commercial real estate transaction before the foreclosure sale occurs.
These leads should be clearly marked:
PRE-FORECLOSURE — OWNER CONTACT PRIORITY
For these properties, researchers should identify:
* Legal owner
* Ownership entity
* Public owner/business contact information
* Mailing address
* Property address
* NOD date
* Trustee sale date, if scheduled
* Trustee
* Lender
* Estimated property value
* Current asking price, if separately listed
* Existing mortgage information, where publicly available
* Property characteristics
* Whether the property is currently occupied
* Existing business at location
* Whether property is currently listed for sale
* Listing broker, if any
* Any available indication that the owner is already marketing the property
DISTINGUISH THE CONTACT TYPE
Every foreclosure lead must clearly identify whether the available contact is:
* OWNER DIRECT
* OWNER'S BUSINESS
* OWNER'S REPRESENTATIVE
* BROKER / LISTING AGENT
* PROPERTY MANAGER
* TRUSTEE
* LENDER / REO DEPARTMENT
* AUCTION COMPANY
* UNKNOWN
Do not combine these contacts into one field.
I need to know who I am actually contacting and what role they have in the property.
PROPERTY VALUE / DEAL ANALYSIS
For foreclosure properties, higher-value leads should include basic deal information whenever reasonably available:
* Estimated market value
* Assessor value
* Prior sale price
* Prior sale date
* Current asking price
* Foreclosure opening bid
* Estimated price per square foot
* Comparable nearby sales
* Comparable commercial lease rates
* Estimated after-purchase value
* Known liens, where publicly available
* Property taxes due
* Estimated equity, if reasonably calculable from public information
* Potential discount compared with nearby commercial properties
Researchers should clearly label estimates as ESTIMATES rather than presenting them as verified facts.
AUTOMOTIVE PROPERTY PRIORITY
Give especially high priority to foreclosure properties that are currently or were previously:
* Mechanic shops
* Auto repair shops
* Tire shops
* Transmission shops
* Brake shops
* Smog shops
* Auto-body shops
* Fleet maintenance facilities
* Truck repair facilities
* Dealership service departments
* Car lots with service bays
* Warehouses with automotive use
* Industrial buildings with roll-up doors
* Service-commercial buildings
* Contractor yards
* Transportation facilities
Properties with existing automotive infrastructure may be considerably more valuable to me than ordinary warehouse space.
FORECLOSURE LEADS SHOULD BE RANKED
Add a Priority Score column:
Priority A — Contact Immediately
Pre-foreclosure, desirable automotive/industrial property, owner identified, and foreclosure sale approaching.
Priority B — Strong Opportunity
Foreclosure/distressed property that appears suitable, but additional research or zoning verification is required.
Priority C — Possible Opportunity
Property meets some criteria but has significant unknowns.
Priority D — Research Only
Property may eventually become relevant but is not presently actionable.
PAY PREMIUM FOR EXCELLENT FORECLOSURE LEADS
Foreclosure leads with complete ownership and transaction research should qualify for the highest payment tier.
A premium foreclosure lead should ideally include:
* Current foreclosure status
* Property address
* APN
* Square footage
* Property/automotive suitability
* Owner name/entity
* Owner mailing information
* Publicly available owner/business contact
* NOD date
* Trustee sale date
* Trustee information
* Lender information
* Foreclosure source/document
* Current zoning
* Automotive-use information
* Approximate property value
* Comparable properties
* Current listing information, if any
* Broker information, if represented
* Date all information was verified
The objective is not simply to produce a list of foreclosure addresses.
I want actionable commercial real estate leads that allow me to understand the property, ownership, foreclosure timeline, decision-maker, potential value, and best person to contact about a legitimate purchase.

Evening Case Coordinator / Client Concierge

Remote | 4 hours per day | Monday–Friday

We are a fast-growing dental laboratory working with dental practices across the USA.

We’re looking for an extremely organised, proactive person to manage our evening case coordination and client communication.

Your role

You will be responsible for keeping our cases moving and ensuring our clients are kept updated throughout the process.

Your daily responsibilities will include:

* Managing client communication through WhatsApp
* Monitoring active dental cases
* Updating our internal Google Sheets
* Managing and checking case files within Dropbox
* Checking that new cases have all required files and information
* Coordinating with our design and manufacturing teams
* Following up immediately when information or files are missing
* Monitoring deadlines and identifying cases at risk of delay
* Providing clients with clear, professional case updates
* Escalating important issues to management
* Making sure every active case has a clear status and next action

What we’re looking for

You must be:

* Extremely organised
* Reliable and consistent
* Confident communicating with US clients
* Excellent written English
* Comfortable using WhatsApp, Google Sheets and Dropbox
* Able to manage multiple cases simultaneously
* Proactive rather than waiting to be told what to do
* Comfortable working in a fast-moving environment

Dental or dental laboratory experience would be a major advantage, but attitude, communication and organisation are more important.

What success looks like

At the end of every shift:

Every client has been answered.
Every case is updated.
Every deadline has been checked.
Every problem has an owner.
Every case has a next action.

We’re looking for someone who wants to take ownership of this part of the business and potentially grow into a larger operations/client management role as the company continues to expand.

To apply: Send a short introduction explaining your previous experience, the systems you’ve worked with, your availability, and why you think you’d be good at managing a high-volume client workflow.

We’re looking for a reliable, proactive, and organized Virtual Assistant who can support us with a combination of HR Project Management, Sales, and administrative tasks.

We’re open to candidates with different professional backgrounds, but we especially value someone who can bring a strong mix of HR, project management, communication, and sales skills.

💼 Position Details
✅ Hours: 8–10 hours per week
✅ Rate: $5–$6 USD/hour
✅ Schedule: Flexible, with availability during agreed working hours
✅ Long-term opportunity for the right person
✅ Remote / Work from Home
🎯 Priority Skills

1. 🥇 HR Project Management — Highest Priority

✅ Coordinate and follow up on HR-related projects
✅ Organize tasks, deadlines, and priorities
✅ Track project progress and make sure tasks are completed on time
✅ Communicate with team members and follow up when necessary
✅ Assist with recruiting and hiring processes
✅ Help organize candidate information, interviews, and follow-ups
✅ Maintain clear documentation and organized workflows

2. 🥈 Sales Support

✅ Assist with lead generation and prospect research
✅ Identify potential clients and business opportunities
✅ Support outreach and follow-up activities
✅ Maintain lead lists and CRM information
✅ Communicate professionally with prospects
✅ Help track sales activities and opportunities

3. 🥉 Administrative / Virtual Assistant Support

✅ Manage spreadsheets, documents, and databases
✅ Conduct online research
✅ Organize information and files
✅ Assist with scheduling and follow-ups
✅ Support general day-to-day business operations
🌟 Ideal Candidate
✅ Strong organizational and time-management skills
✅ Excellent written and verbal English
✅ Proactive and able to work independently
✅ Strong attention to detail
✅ Comfortable communicating with candidates, clients, and team members
✅ Experience with HR, recruiting, project management, or sales
✅ Comfortable using tools such as Google Workspace, Excel/Google Sheets, Slack, Trello, ClickUp, Notion, CRM platforms, or similar tools
✅ Fast learner who can adapt to new systems and processes
✅ Reliable and consistent with communication
✅ Able to handle multiple priorities without losing track of details
🚀 Why Join Us?
✅ Flexible part-time schedule
✅ Opportunity to work closely with a growing team
✅ Variety of responsibilities — HR, project management, sales, and operations
✅ Potential for additional hours and responsibilities as the business grows
✅ Long-term collaboration for the right person
📩 To Apply

Please include:

✅ A brief introduction about yourself
✅ Your relevant experience in HR, project management, recruiting, or sales
✅ The tools and software you have experience using
✅ Your current availability
✅ Your hourly rate
✅ A brief example of a project or task you successfully managed

We’re looking for someone who is dependable, takes initiative, and can become a valuable part of our team. If you’re a great all-around professional who can combine HR project management with sales support, we’d love to hear from you!

I'm looking for someone experienced in B2B lead generation, data collection and web scraping to help build a targeted database of businesses in and around a specific radius in the UK.

The purpose of the database is to identify potential customers for a local workplace food/catering business, so we're particularly interested in businesses with a reasonable number of employees working from one location.

Businesses we're interested in

Primarily:

- Warehouses and distribution centres
- Manufacturing businesses and factories
- Industrial businesses
- Engineering companies
- Larger offices
- Construction companies
- Automotive businesses/dealerships
- Other workplaces with approximately 20+ employees on site

We'd initially be looking at one town and approximately a 20-mile radius.

Data required

Ideally, we'd like:

- Company name
- Business type / industry
- Trading address
- Postcode
- Website
- Main telephone number
- General/company email address
- Approximate number of employees, where available
- Relevant contact name, where legitimately available
- Contact's job title, e.g. Facilities Manager, Office Manager, Operations Manager, HR Manager, General Manager
- Business LinkedIn URL, where available
- Source of the data

The final data should be supplied in a clean CSV/Excel/Google Sheets format with duplicates removed.

Important - UK GDPR / PECR compliance

We do not want someone simply scraping personal information indiscriminately.

The data will be used for legitimate B2B prospecting in the UK, so I'm looking for someone who understands compliant B2B data collection and can explain:

- What sources you would use
- How you would collect/scrape the information
- Whether you're using public data, APIs or third-party data providers
- How you ensure the collection method complies with UK GDPR/PECR and the terms of the data sources being used

Please don't propose scraping sources where the platform's terms explicitly prohibit it.

When applying. Please tell me:

- How you would approach this project
- What tools/data sources you would use
- Your experience with UK B2B lead generation
- Your cost for an initial list of approximately 500 qualified businesses

If the initial project works well, there is potential for further work expanding the database into other locations and maintaining/enriching the data over time.

SafeBooks LLC is a growing virtual accounting firm that helps small business owners stay organized, understand their finances, meet their tax obligations, and make better business decisions.

We also operate a growing DIY Bookkeeping Community that provides small business owners with resources, education, templates, and ongoing support.

I am looking for a highly organized, tech-comfortable Operations & Marketing Assistant who can help me manage the behind-the-scenes work of the business, improve our systems, support our marketing efforts, and turn ideas into completed projects.

This is not a traditional administrative assistant position where you simply wait for instructions. I am looking for someone who anticipates needs, enjoys creating systems, using AI and automation, and helping a busy business owner get things off her plate.

You do not need to be an accountant or tax professional. However, experience working with accounting, tax, bookkeeping, professional services, or financial businesses would be a major plus.

I will provide a weekly tasks list on a Google Sheets project dashboard and a Loom video, so that you know expectations for the week. We can also communicate via Zoom, email and Loom video, but the Google Sheets dashboard will give the clear expectations for the week. Tasks are related to the following job areas:

1. Operations & Administrative Support

You will help keep the business organized and make sure projects don't fall through the cracks.

Responsibilities may include:

Managing and organizing projects and task lists
Maintaining internal dashboards and trackers
Organizing Google Drive files and folders
Turning Loom videos or verbal instructions into written procedures
Following up on assigned tasks and deadlines
Maintaining recurring business checklists
Creating forms, templates, spreadsheets, and other internal resources
Identifying tasks that could be simplified, automated, delegated, or handled with AI

2. Email & Client Communication Support

A major part of this role will be helping keep communication organized.

Tasks may include:

Organizing Gmail inboxes
Creating Gmail labels, folders, and filters
Identifying recurring emails that can be unsubscribed from
Flagging messages that require my attention
Organizing emails by client, vendor, project, or category
Drafting routine client emails for my review
Creating reusable email templates

3. Marketing & Content Support

You will help turn my ideas and expertise into polished marketing content.

Tasks may include:

Brand and scheduling social media content (purchased from marketing company)
Repurposing long-form content into shorter posts
Creating Facebook, Instagram, LinkedIn, and YouTube content
Designing graphics in Canva
Creating ads for digital products and memberships
Creating promotional campaigns
Preparing newsletters
Creating YouTube thumbnails, intros, outros, descriptions, and other assets
Organizing content calendars
Tracking basic marketing metrics
Researching content ideas and trends relevant to small business owners
Helping promote SafeBooks services, digital products, and educational resources

4. DIY Bookkeeping Community Support

SafeBooks operates a membership community for small business owners who manage some or all of their own bookkeeping.

You may help:

Manage and organize resources inside Podia
Upload PDFs, spreadsheets, templates, videos, and downloads
Keep the resource library organized and searchable
Create member announcements
Prepare monthly emails
Update pinned resources and Zoom information
Help organize member questions
Turn common questions into FAQs or new resources
Help plan monthly content for the community
Assist with member onboarding
Keep the member experience organized and professional

Technology We Use or May Use

Experience with all of these is NOT required, but you should be comfortable learning software.

Our tools include:

Google Workspace
Gmail
Google Drive
Google Docs
Google Sheets
Canva
ChatGPT
Podia
Squarespace
TaxDome
QuickBooks Online
Loom
Zoom
YouTube
Social media platforms
Online scheduling and workflow tools

Experience with automation platforms such as Zapier or Make is a bonus!


Please begin your application with “SafeBooks Operations” so I know you read the full posting.