iOS VNC Scripts - Google Sheets Integration

## Overview I am looking for an experienced iOS automation developer with strong Lua scripting skills to help complete an existing mobile automation project running on a dedicated iOS device. The project is already started and the foundation is in place, but it is still far from production-ready. Approximately **40% of the system has been implemented** and I need someone who can continue development, fix existing issues, and complete the remaining functionality. This is not a greenfield project. You will be working with an existing codebase and infrastructure. --- ## Current Project Status The following components already exist in some form: * Main automation workflow * Device communication layer * Remote execution system * Google Sheets integration * VPN management module * SMS verification module * TOTP generation module * Configuration management * Logging system Some modules are functional, some are partially implemented, and some require significant debugging and improvement. The goal is to transform the existing prototype into a stable, reliable workflow. --- ## Technical Environment ### Device Environment * Dedicated iOS device * Custom HTTP-based device control API * Lua scripts executed directly on the device ### Existing Integrations * Google Sheets * Google Apps Script backend * SMS verification provider * VPN automation * 4G SIM card management * Airplane Mode enable/disable automation * IP refresh workflow through cellular reconnect * TOTP / Two-Factor Authentication generation * Status monitoring and logging --- ## Project Goals The completed system should be capable of: 1. Reading pending records from Google Sheets 2. Configuring network settings 3. Rotating VPN connections when required 4. Switching Airplane Mode on/off to obtain a fresh cellular IP 5. Validating network connectivity before proceeding 6. Launching and controlling a mobile browser 7. Navigating through a multi-step onboarding process 8. Completing phone verification 9. Configuring two-factor authentication 10. Writing results back to Google Sheets 11. Processing records continuously with proper error handling --- ## Development Tasks ### Phase 1 – Existing Code Review * Review the current codebase * Understand existing modules * Identify unfinished sections * Identify bugs and bottlenecks * Create a completion plan ### Phase 2 – Browser Automation Current browser automation is incomplete and unreliable. Tasks include: * Stabilizing navigation flows * Improving screen transitions * Improving interaction reliability * Handling unexpected screens * Handling page layout variations ### Phase 3 – UI Interaction Improvements Several screens currently require better automation logic. Tasks include: * Reliable element detection * Keyboard handling * Scroll handling * Screen state validation * Dynamic UI interaction OCR-based approaches are welcome if they improve reliability. ### Phase 4 – Verification Flow Improve and validate: * SMS verification * Verification code entry * Timeout handling * Retry mechanisms * Error recovery ### Phase 5 – Two-Factor Authentication The current implementation requires testing and validation. Tasks include: * Full workflow testing * Fixing failures * Validation of generated codes * Data persistence verification ### Phase 6 – Network & IP Management Review and improve: * VPN rotation workflow * Cellular network reconnection * Airplane Mode automation * IP refresh validation * Network health checks * Failure recovery when connectivity is lost ### Phase 7 – Error Handling & Recovery Implement robust handling for: * Network interruptions * Verification failures * Unexpected UI changes * Session interruptions * Challenge screens * Timeouts * Browser crashes * Device communication failures The system should recover automatically whenever possible. ### Phase 8 – Scaling & Stability Prepare the workflow for higher-volume operation. Focus areas: * Reliability * Resource management * Logging * Performance optimization * Long-running execution stability --- ## Deliverables ### Functional System * Fully operational workflow * End-to-end testing completed * Successful processing of test records * Stable operation over extended periods ### Code Improvements * Bug fixes * Stability improvements * Cleaner structure where needed * Improved maintainability ### Documentation Provide documentation covering: * System architecture * Changes made * Configuration process * Troubleshooting steps * Deployment notes ### Logging Provide clear logs showing: * Workflow progress * Network changes * Failures * Recovery attempts * Final outcomes --- ## Required Skills ### Must Have * Lua * iOS automation * Mobile UI automation * API integrations * HTTP-based automation systems * Debugging complex workflows * Working with existing codebases ### Nice to Have * OCR / Computer Vision * Mobile browser automation * Google Sheets API experience * VPN automation * Cellular network automation * Long-running automation systems --- ## Access Provided Upon hiring, you will receive: * Existing source code * API documentation * Configuration files * Test environment * Logging access * Supporting infrastructure --- ## Timeline Preferred timeline: * Initial review: 1–2 days * Development and fixes: 5–10 days * Testing and stabilization: 2–4 days Flexible for the right candidate. --- Only apply if you have hands-on experience with mobile automation, debugging existing codebases, and building reliable automation workflows.