Automate Daily Notion Sync

We are looking for a reliable, one-way integration that automatically pulls data from Zucchetti GO and inserts it into our Notion workspace on a daily basis.
The goal is to eliminate all manual data handling (copy-paste, exports) and ensure our Notion databases always reflect the latest data.

Scope of Work
1. Data Extraction (Zucchetti GO)
Connect to the Zucchetti GO API (or supported endpoint)
Retrieve the following datasets exactly as stored:
Customers
Suppliers
Articles
Offers
Delivery Notes
Invoices

2. Data Transformation & Mapping
Map Zucchetti fields to corresponding Notion database properties
Ensure compatibility with Notion data types:
Text, Number, Date, Select, Relations, etc.
Maintain consistent schema alignment

3. Data Insertion (Notion)
Use the official Notion API to:
Create new records
Optionally update existing records (if required)
Prevent duplicate entries (via unique IDs or timestamps)

4. Automation & Scheduling
Implement a scheduled job that runs once per day
Suggested approaches:
Cron job (server/VPS)
Serverless (AWS Lambda, GCP, etc.)
Ensure:
Retry logic for failures
Logging of each run (success/failure)

5. Error Handling & Logging
Handle:
API failures
Partial data syncs
Duplicate prevention
Provide:
Clear logs (human-readable)
Optional alerts (email/Slack)

6. Documentation & Handover

Provide complete documentation including:

Setup instructions
Required credentials:
Zucchetti API keys
Notion integration token
Environment variables
Field mapping configuration
Steps to:
Modify schema mappings
Redeploy the integration