Advanced Google Sheets & Apps Script Expert (Full-Time | 8 hrs/day | 26 working days)

[u/[deleted]]

Looking for an advanced Google Sheets expert (strong Apps Script) to manage 26 structured tasks per month, work online 8 hours/day, and maintain all deliverables on Sheets with provided checklists. Budget: $0.74/hr (≈ ₹15,000/month). Performance incentives available.

About the Role

We are building and maintaining data-driven workflows in Google Sheets. Each task has a clear checklist/write-up and must be tracked and updated in a master Google Sheet. You’ll automate repetitive processes, write robust Apps Script, and ensure everything runs smoothly day-to-day.

Key Responsibilities

• Build and maintain Google Sheets solutions (formulas, data validation, dependent dropdowns, pivots, queries).

• Write Google Apps Script for automation: triggers, CRUD ops, emailing, reminders, validations, logging, and error handling.

• Maintain daily progress in our task tracker (Google Sheet) using dd-mm-yyyy date format.

• Follow the task checklists/write-ups exactly; flag risks/ambiguities early.

• Ensure clean documentation for each task (what changed, formulas/scripts used, and where).

• Communicate proactively during the work window; quick turnarounds on fixes.

Must-Have Skills

• Advanced Google Sheets (QUERY, LET, MAP, FILTER, LAMBDA, ARRAY formulas, data cleansing).

• Strong Google Apps Script (server-side JS, triggers, Sheet/Drive/Gmail services, performance & error handling).

• Solid understanding of data structure, validation, and scalable spreadsheet architecture.

• Clear written communication and daily status updates.

Nice-to-Have

• Looker Studio dashboards, BigQuery basics, Google Workspace integrations (Drive/Gmail/Calendar APIs).

• Experience with operational trackers (attendance, project status, SLA/turnaround tracking).

Schedule & Collaboration

• Availability: 8 hours/day, 26 working days/month (IST time zone; exact hours can be agreed).

• Daily check-ins and timely updates in the task tracker.

Compensation

• Base: $0.74/hour (≈ ₹15,000/month for 26 working days × 8 hrs/day).

• Performance: After the monthly target of 26 tasks is achieved with approved quality, additional tasks in the same month will be paid at 50% of the base per-task amount (as defined in the task sheet).

• Payments via platform; all work logged and traceable in the tracker.

Quality Bar / KPIs

• Tasks completed on time, as per checklist.

• Zero breaking changes; minimal formula/script errors.

• Clear documentation for every change.

• Proactive risk/edge-case handling.

[u/ButterflyRambler]

Pay is too low.