Google Workspace Automation Expert – SEO Audit Lead Generation System (Apps Script + Gemini API) -- 2

Job Title
Google Workspace Automation Expert – SEO Audit Lead Generation System (Apps Script + Gemini API)

Job Description
We are looking for an experienced Google Workspace automation expert to set up a fully automated internal SEO audit & lead-generation system using Google Forms, Google Sheets, Google Apps Script, Gmail, and Gemini API.
This system is for internal use only (not public SaaS) and is focused on automated SEO audit reports for lead generation, not deep technical SEO.
We already have a clear functional requirement and workflow. The task is implementation and proper configuration inside our Google Workspace.

Project Overview (What Needs to Be Built)
Employees will submit one internal Google Form with client details.
After submission, the system must automatically:
Collect basic SEO signals from the client website


Generate a light SEO audit report using Gemini API


Create a Google Doc (or PDF) audit report


Send a branded audit email to the client automatically


Save all data in Google Sheets for tracking


Allow admin to resend reports anytime


Track which employee submitted which lead


No manual SEO work after form submission.

Core Technologies (Mandatory Experience)
You must have proven experience with:
Google Apps Script (advanced)


Google Forms → Sheets automation


Google Sheets as database / admin panel


GmailApp / MailApp automation


Gemini API (or similar LLM API integration)


Google Docs automation (create/edit documents programmatically)


API integrations (PageSpeed Insights or similar)


Error handling, logging, triggers, quotas


❌ We are NOT using WordPress
❌ We are NOT using external servers (Laravel/Node not required)

Key Functional Requirements
1. Google Form (Internal Use)
Form fields include:
Employee name & email


Client website URL


Client email


Target keywords


Client contact details (internal only)


Source URL (Freelancer/Upwork project link, internal tracking)


Only website + keywords + client email are used for the audit and email.
All other data must remain internal and hidden from the client.

2. SEO Audit (Light, Automated)
Homepage SEO checks (title, meta, H1)


HTTPS check


robots.txt & sitemap check


PageSpeed score (mobile/desktop)


Basic keyword presence check



3. Gemini API (AI Report)
Generate:


SEO score (0–100)


Issue list (High / Medium / Low)


Plain-English summary


“What we will fix” (sales-oriented)


Strict prompt control (no mention of data source)



4. Automated Email
Send audit report to client email


Professional, conversion-focused copy


Company contact details included


Admin can resend report anytime



5. Admin Tracking
Google Sheet as admin panel


Track:


Employee name


Client details


Submission date


Report sent date


Resend history


Error logs



Deliverables
Fully working automation inside our Google Workspace


Clean, well-structured Apps Script code


Proper triggers (on form submit)


Documentation explaining:


How to manage


How to resend


How to update API keys


Basic testing + bug fixes