# Daily sync of book data from Google Sheets to MySQL — no manual entry
This workflow automates the daily transfer of book data (title, price) from Google Sheets to a MySQL database, eliminating manual data entry. Ideal for users who rely on Google Sheets as a source for product catalogs or inventory tracking.
## Who it´s for
- E-commerce owners syncing prices from spreadsheets to databases
- Content administrators automating catalog updates
- Warehouse managers maintaining inventory in Google Sheets
## What the automation does
- Triggers daily at 5 AM via cron schedule
- Reads updated book titles and prices from a specified Google Sheet
- Inserts the data into the `books` table in MySQL
- Ensures consistent, hands-free synchronization
## What´s included
- Ready-to-use n8n workflow
- Cron-based scheduling logic
- Integrations with Google Sheets API and MySQL
- Basic setup and adaptation guide
## Requirements for setup
- Google account with access to the target Google Sheet
- MySQL server access (host, port, credentials, database name)
- Self-hosted or cloud n8n instance
## Benefits and outcomes
- Saves time on daily catalog updates
- Reduces human error in data entry
- Centralizes data: source in Google Sheets, storage in MySQL
- Enables further integration of the database with websites or CRMs
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet