Google Drive & Workspace Automation Specialist Expert Freelancer

Заказчик: AI | Опубликовано: 06.11.2025

We are looking for an experienced Google Drive / Google Workspace Expert who can plan, structure, and automate our entire data workflow across multiple departments and teams. You will work with our leadership team and department heads to create Google Forms, Sheets, Templates, Data Pipelines, Dashboards, Access Controls, and Automated Report Flows, based on predefined operational structures. Scope of Work / Responsibilities: Set up a well-organized Google Drive folder structure for multiple departments. Create multi-role access levels (Admin / Manager / Team Leader / Executive / Remote / Office Staff / Freelancer / Agent). Build Google Forms for different workflows (e.g., Task Allocation, Daily Work Report, Lead Intake, Project Update, Sales Pipeline, etc.) Create Google Sheets with automation: Data consolidation Dropdown-controlled fields Validation rules Conditional formatting Implement Dashboards and Reporting using: Google Sheets Google Data Studio (Looker Studio) — optional Automate workflows using Google Apps Script / Zapier / Make (Integromat) wherever required. Train internal staff on how to use the system. Departments Included: (Already Structured – Just Needs System Setup) IT Development Team UI/UX & Web Design Testing / QA & Documentation SEO & Digital Marketing Unit Sales / Lead Desk HR & Recruitment Client Service & Support Team Field / Outsourced / Freelancer Agents What We Already Have: Organizational Process Flow Departments Roles & Work Responsibility Sheets Daily Task Sheet Templates Reporting Formats Hierarchy & Access Matrix Plan Your task is to convert all of this into a fully working Google Workspace Operations System. Required Skills: Strong experience with Google Sheets (Formulas, Queries, Pivot Tables, Dashboarding) Google Forms workflow setup experience Knowledge of Google Apps Script (for automation) Experience with Access & Sharing Permissions Good communication & ability to understand business workflow