Amazon SES Campaign & WordPress-Zoho Integration

We are looking for an experienced automation developer to complete two connected workflows for an online platform.

Our previous freelancer cancelled the project. The lead-capture system is already operational: Claude automatically collects relevant leads from online directories and saves them in Google Sheets. This part should not be rebuilt unless minor integration changes are required.

1. Automated Email Outreach Using Amazon SES

We currently have approximately 23,000 leads stored in Google Sheets, with new leads added automatically each day.

The freelancer must build an automated workflow that:

Reads unsent leads from Google Sheets.
Sends partnership invitation emails through Amazon SES.
Uses our existing company email address, which will be provided privately.
Begins with a safe domain warm-up schedule.
Gradually increases sending volume to approximately 1,000 emails per day.
Allows us to edit the daily limit, schedule, subject line, email template and follow-up settings without changing code.
Automatically stops when all existing leads have been contacted.
Continues afterward by processing only newly added leads.
Prevents duplicate emails.
Excludes invalid, bounced, complained and unsubscribed addresses.
Provides a pause and resume option.
Includes an unsubscribe link and suppression list.
Processes Amazon SES delivery, bounce and complaint notifications.
Automatically pauses or alerts us if bounce or complaint rates become unsafe.
Includes retry logic and accessible error logs.
Keeps the recurring infrastructure cost below approximately USD 10 per month.

The workflow must update each lead’s status in Google Sheets, including:

New
Ready
Sent
Delivered
Bounced
Complained
Unsubscribed
Failed

The freelancer must configure Amazon SES production access and proper email authentication, including SPF, DKIM and DMARC. No DNS changes should be made without our approval.

Deliverability is a priority. The system must not send all 23,000 emails immediately.

2. Managed WordPress and Zoho Integration

Our managed WordPress website includes a recruiter/partner registration process.

The required workflow is:

A recruiter submits the registration form on the website.
Their account and application are created with a Pending Review status.
The applicant’s information is automatically sent to Zoho CRM.
We review the application and click Approve or Reject.
If approved:
The status changes to Approved – Contract Sent.
Zoho automatically sends the relevant contract through Zoho Sign or the appropriate Zoho contract application available in our account.
Available applicant information is prefilled into the contract.
The recruiter completes the required fields and signs the contract.
When the contract is completed:
Zoho is updated to Contract Signed/Active.
The corresponding WordPress account receives the correct recruiter/partner role and portal access.
If rejected:
The application is updated to Rejected in WordPress and Zoho.
We can record the rejection reason.
An editable rejection email can be sent if enabled.

The workflow must prevent duplicate Zoho records and duplicate contract requests. Clicking Approve more than once must not send multiple contracts.

We prefer Zoho CRM to act as the central application-review and status dashboard. The freelancer should confirm the best implementation after reviewing our existing WordPress registration system and Zoho account.

Technical and Security Requirements
Review the existing work before beginning development.
Preserve the current Claude-to-Google-Sheets lead-capture automation.
Implement the WordPress integration using a maintainable custom plugin or another update-safe method.
Do not make fragile edits directly to the WordPress theme.
Use secure Zoho OAuth authentication.
Authenticate and validate incoming webhooks.
Do not hardcode passwords, API keys or access tokens.
All AWS, Zoho, Google, WordPress and source-code accounts must remain under our ownership.
The freelancer must not request AWS root credentials.
Provide a testing or staging mode before activating live emails and contracts.
Email templates, sending limits, timing and workflow settings must be editable by a non-developer.
Important actions and errors must be recorded in accessible logs.
Deliverables
Working Google Sheets-to-Amazon SES email automation.
Configurable warm-up and daily sending schedule.
Bounce, complaint and unsubscribe processing.
WordPress-to-Zoho applicant synchronization.
Application review with Approve and Reject actions.
Automated contract creation and sending through Zoho.
Signed-contract status callback.
Automatic WordPress account activation after contract completion.
Source code for all custom development.
Data-field mapping document.
Setup and deployment documentation.
Testing checklist and results.
Recorded tutorial explaining how to:
Edit email templates.
Change sending limits.
Pause and restart outreach.
Review applications.
Approve or reject applicants.
Review errors and retry failed processes.
Final handover of all source code, configurations and automation ownership.
Acceptance Tests

The project will be accepted when:

A controlled email batch is sent without duplicates.
The configured daily limit is respected.
Bounce, complaint and unsubscribe events update Google Sheets correctly.
Pausing the workflow prevents new emails from being sent.
Restarting continues from the correct unsent lead.
Once the existing list is completed, only new leads are processed.
A test registration creates the correct record in Zoho.
Approving an application sends exactly one contract.
Rejecting an application does not send a contract.
Completing the contract updates Zoho and activates the correct WordPress account.
Failed API requests are logged and can be safely retried.
Suggested Milestones
Review the existing system and provide a final technical plan.
Complete and test the Amazon SES outreach workflow.
Complete the WordPress-to-Zoho registration and review workflow.
Complete contract sending, signing callback and account activation.
Complete testing, documentation, tutorial and final handover.

Please provide a fixed-price quotation and realistic completion timeline. Identify any required paid WordPress plugins or Zoho plan features before development begins.

To confirm that you have read the complete scope, begin your bid with the word Automation and include:

Examples of similar Amazon SES projects.
Examples of WordPress and Zoho API integrations.
Your proposed technical approach.
Estimated recurring monthly costs.
Estimated completion time.
The access and information you will require.