Google Workspace CRM Development for Medical Store

Freelancer Job Description
Project Title: Wellness Retail Customer Registration & WhatsApp CRM Automation
Project Overview
We require an experienced Google Workspace Automation Developer to build a low-cost CRM system for a medical store using Google Forms, Google Sheets, Google Apps Script, QR Codes, and WhatsApp Business.
Scope of Work
• Create a Google Form for customer registration.
• Generate a QR code linking to the registration form.
• Store submissions automatically in Google Sheets.
• Automatically generate a unique Customer ID.
• Build a searchable customer database.
• Configure WhatsApp Business profile, labels, quick replies, and broadcast workflow.
• Automate staff email notifications for new registrations.
• Create birthday and medicine reminder lists.
• Build a Looker Studio dashboard showing registrations, customer categories, birthdays, and consent statistics.
• Deliver complete documentation and provide one training session.
Required Skills
• Google Apps Script
• Google Workspace
• Google Forms
• Google Sheets
• JavaScript
• WhatsApp Business
• API Integration
• CRM Automation
• Looker Studio
Deliverables
• Complete working system
• Source code
• Documentation
• Installation guide
• One month of bug support
Preferred Experience
Previous work with pharmacy, retail, healthcare, or CRM automation projects