Import Google Sheets Data to MySQL Weekly

Automates weekly import of data from Google Sheets into MySQL database using a cron trigger. Ideal for syncing sales or commission data effortlessly.

This workflow automates the periodic import of data from a Google Sheets spreadsheet into a MySQL database. It starts with a Cron node configured to trigger every week at 5 AM, ensuring hands-free operation. The Google Sheets node then reads data from a specified sheet using OAuth2 authentication, pulling columns like title and price. Finally, the MySQL node inserts this data into a 'books' table with options for ignoring duplicates and low-priority execution to avoid performance issues. Key be
Platform
n8n
Category
Sales
Price
$5.99
Creator
Jordi Faber

How to import this workflow into n8n

  1. 1Purchase or download the workflow to get the n8n workflow JSON file.
  2. 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
  3. 3Open each node marked with a credential warning and connect your own accounts and API keys.
  4. 4Run the workflow once manually to verify the data flow, then toggle it to Active.

Related Sales workflows

More from Jordi Faber

All Sales workflows →All n8n workflows →

Need this deployed? We'll set it up for you.

Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.

Get It DeployedCustom Build