I need a seasoned Google Apps Script developer to streamline several everyday tasks across Google Sheets, Drive, and Forms. My goal is to automate internal workflows and set up reliable integrations with both Google Workspace APIs and our own custom APIs. Core objectives • Build reusable Apps Script modules that trigger from form submissions or scheduled timers. • Push and pull data between Sheets, Drive folders, and external services through Google Workspace APIs (e.g., Drive, Sheets, Admin) and our private REST endpoints. • Create a light-weight solution for social-media posting automation initiated from a spreadsheet dashboard. • Deliver clear, well-commented code plus a short setup guide so my team can maintain it. What will win the job • Demonstrated experience writing production-ready Apps Scripts. • Familiarity with OAuth scopes, triggers, and advanced services. • Ability to propose the best architecture, keep execution time within quotas, and handle API rate limiting gracefully. We require an expert Google Apps Script (GAS) developer to implement a cost-effective, in-house automation tool for our content workflow. The goal is to use the Gemini API to automatically generate social media captions from our long-form blog posts (focused on the Drug Price Control Order (DPCO) and the Drugs and Cosmetics Act) Deliverables. A fully functional Google Sheet template containing the custom GAS function. Clean, commented code with full rights transferred to us. Brief user guide and technical documentation. Context The content is regulatory and compliance-sensitive. Experience with sophisticated prompt engineering to ensure accuracy and prevent AI "hallucinations" is a major advantage. Quote Required Please submit your proposal with a fixed-price quote and a clear timeline for this implementation. Would you like to refine the wording to emphasize the economic viability or specific legal terms?