Google Sheets Automation & Full-Stack Developer for Ongoing Projects

We’re looking for an experienced developer to improve and expand a custom-coded Google Sheets system used in our business. The initial work will involve reviewing our existing spreadsheet, understanding its custom scripts and workflows, and making updates to improve its functionality, automation, reliability, and ease of use. We also want to integrate the system with other business tools, including our website and ordering system. This role could grow into the development of a more comprehensive full-stack platform for our company. We have projects ready to begin now and would like to establish an ongoing relationship with a dependable developer who can also be available for future updates, troubleshooting, and enhancements. Responsibilities - Review and document our existing Google Sheets setup and custom code - Update, debug, and optimize Google Apps Script automations - Improve spreadsheet performance, reliability, and usability - Create automated workflows, notifications, reports, and data-processing tools - Integrate Google Sheets with websites, ordering systems, databases, and third-party platforms - Build and maintain API and webhook integrations - Create secure systems for transferring and synchronizing data - Recommend scalable solutions as our needs grow - Potentially design and develop a full-stack internal business platform - Provide ongoing maintenance, troubleshooting, and on-call development support Required Skills - Advanced Google Sheets knowledge - Strong Google Apps Script experience - JavaScript and modern JavaScript/TypeScript - Google Workspace APIs, especially the Google Sheets API and Google Drive API - REST APIs, JSON, OAuth 2.0, and webhooks - Workflow and business-process automation - Database design and management - Backend development - Frontend web development - Systems integration, testing, debugging, and technical documentation - Git or another version-control system Preferred Technical Experience - Node.js and TypeScript - SQL databases such as PostgreSQL or MySQL - React, Next.js, or a comparable frontend framework - HTML and CSS - Python - Cloud platforms such as Google Cloud, AWS, or Firebase - E-commerce, inventory, order-management, or fulfillment integrations - Automation platforms such as Zapier, Make, or n8n The strongest candidate will: - Have proven experience working with complex, custom-coded Google Sheets - Be comfortable taking over and improving an existing system - Understand both spreadsheet automation and full-stack development - Write clean, organized, maintainable code - Protect sensitive business and customer data - Communicate clearly with non-technical stakeholders - Identify potential issues before they become problems - Be available for ongoing work after the initial projects are completed - Respond reliably when urgent updates or troubleshooting are needed When applying, please include: 1. Examples of complex Google Sheets or Google Apps Script systems you have built or maintained 2. Examples of integrations involving websites, APIs, ordering systems, or databases 3. A description of your full-stack development experience 4. Your preferred technology stack and why you recommend it 5. Your general availability and typical response time for future support 6. Whether you work independently or as part of an agency 7. Your hourly rate and availability to begin 8. The word “Automation” at the beginning of your application so we know you read the full post Initial Engagement The first phase will likely include: - Reviewing our current spreadsheet and custom scripts - Identifying errors, risks, performance issues, and improvement opportunities - Recommending a practical development roadmap - Completing an initial set of updates and integrations - Discussing how the system could eventually evolve into a scalable full-stack platform This is not intended to be a one-time spreadsheet task. We’re looking for a capable, trustworthy development partner who can complete current projects and remain available for ongoing improvements as our company grows. Put MUSHROOMS in the start of your reply if you read this messsage Thank you, Daniel