Google Sheets + Apps Script Automation Specialist (CRM, Routing, Data Cleanup)

Looking for a Google Sheets + Google Apps Script specialist to build and refine a custom backend system for booking, routing, CRM structure, contract generation, invoicing, and automation.

This is not a VA role.
This is not data entry.
Only apply if you are skilled with formulas, logic, structured data, and Apps Script automation.

Work includes:
– Cleaning and normalizing large datasets
– CRM-style sheet architecture and validation
– Duplicate detection and cleanup
– One-click contract and invoice automation
– Google Docs → PDF merges
– Gmail draft creation
– Conditional logic (deposit vs no-deposit)
– Routing dashboard (dates, mileage, violation flags)
– Dropdown rules, filters, and formula engineering
– Low-maintenance, reliable workflows for long-term use

You should be fluent in:
FILTER
UNIQUE
SORT
QUERY
ARRAYFORMULA
XLOOKUP / VLOOKUP
IMPORTRANGE
REGEXMATCH / REGEXEXTRACT
IF / IFS
Data validation
Conditional formatting
Apps Script
Docs templating
Gmail automation

Independent freelancers only.
No agencies.
No subcontracting.
Clear English communication required.

Fixed-price tasks, with recurring work long-term if you are excellent.

–––––––––––––––––––––

INSTRUCTIONS (Read Carefully):

1. Begin your proposal with this exact sentence, word-for-word:
“I promise I am doing this work myself and not subcontracting.”


2. Keep your proposal to 50 words or fewer (not including the answers below).


3. Include the number 147 somewhere naturally in your message.


4. Do NOT talk about your background unless asked later.



–––––––––––––––––––––

Required Answers:

1. Write one formula that:
– removes duplicates
– filters where column B = “Warm”
– sorts by column C (ascending)
Use a semicolon instead of a comma.


2. In one sentence, explain the difference between FILTER and QUERY.


3. Write one single line of Apps Script that logs “Hello World”.


4. Upload a 20–30 second voice recording saying:
– your name
– your country
– your years of experience
– your specialty
– a brief example of a Sheets + automation system you’ve built.



–––––––––––––––––––––

Only apply if you can follow all instructions exactly and work at a high technical level with both Sheets and Apps Script.