n8n automation

need an n8n automation for the following requirements:

1. Google Sheets → Supabase Sync
• Trigger when a new row is added.
• Clean and standardize phone number format to +9665XXXXXXXX.
• Insert record into Supabase table contacts.

2. WhatsApp Cloud API Sender
• Fetch 100 contacts daily (status = NEW).
• Send a predefined WhatsApp template.
• Update status to SENT and store message_id.

3. WhatsApp Webhook Handler
• Capture delivery, read, and reply events.
• Update status accordingly (DELIVERED, OPENED, RESPONDED).
• Store all events in events_log.

4. Daily Email Report
• Count sent/opened/responded.
• Send email report once per day.

5. Manual Trigger Workflow
• Allow an HTTP endpoint to trigger retry actions.

Tools required:
• Google Sheets
• Supabase
• WhatsApp Cloud API
• n8n