Jewelry Store No-Code Automation

I run a physical jewelry shop in Spain that buys gold from private individuals. I need to automate the full contract and legal reporting workflow using a no-code / low-code stack.

Main tools:

Airtable (core database)

Make (automation/orchestration)

Google Workspace (Docs, Drive, Gmail)

No full custom-coded app required.

Scope of Work

The system must handle:

1️⃣ Customer Transactions

Multi-item contracts (1 contract → multiple gold items)

Automatic totals (items, weight, amount)

Sequential contract numbering

Legal status tracking (Pending, Sent to Police, Blocked, Released)

2️⃣ Automatic Contract PDF Generation

Google Docs template

Dynamic item list generation

Automatic PDF creation

Structured storage in Google Drive

3️⃣ Police Export & Legal Tracking

Weekly "Send to Police" action

Automatic calculation of 15-day legal holding period

Export file with exact required Spanish authority fields

Timestamped export archive

Status update in Airtable

4️⃣ Basic Reporting

Simple Airtable dashboards:

Contracts per period

Total weight

Total amount

No advanced BI required.

Deliverables

Airtable base designed from scratch (normalized structure).

Make scenarios with clear naming and basic error handling.

Google Docs contract template connected to Airtable.

Automated PDF generation and Drive storage.

Police export routine.

Documentation explaining the structure.

Acceptance Criteria

A single contract creation should:

Generate the contract PDF

Save it in Drive

Update legal status fields

Appear correctly in reports

Be exportable for police compliance

After live demonstration and one week of real-world testing, project is complete.