Keyflow

Search Keyflow

Find a shortcut, workflow, MCP server or skill

Sync Google Sheets data with MySQL

n8n template #1964
This workflow performs several data integration and synchronization tasks between Google Sheets and a MySQL database. Here is a step-by-step description of what this workflow does: Manual Trigger: The workflow starts when the user clicks "Execute Workflow." Schedule Trigger: This node schedules the workflow to run at specific intervals on weekdays (Monday to Friday) between 6 AM and 10 PM. It ensures regular data synchronization. Google Sheet Data: This node connects to a specific Google Sheets document and retrieves data from the "Form Responses 1" sheet, filtering by the "DB Status" column. SQL Get inquiries from Google: This node retrieves data from a MySQL database table named "ConcertIn

How to set it up

  1. Open template #1964 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
  2. Create 2 credentials under Credentials → Add credential: Google Sheets, MySQL. Then open each of those nodes and pick the credential.
  3. Click Execute workflow and step through each node's output to confirm the data looks right.
  4. Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Sync Google Sheets data with MySQL" (https://n8n.io/workflows/1964). It uses: Google Sheets, MySQL. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Questions

Yes. n8n Team published it free on n8n.io as a verified creator, and it has 7,760 views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets, MySQL. The other 0 nodes are built into n8n.

Similar workflows

NameViews
  1. Build an AI-Powered Tech Radar Advisor with SQL DB, RAG, and Routing Agents12K
  2. Import data from MySQL into Google Sheets5,532
  3. Generate AI Viral Videos with Seedance and Upload to TikTok, YouTube & Instagram215K
  4. Fully Automated AI Video Generation & Multi-Platform Publishing191K
  5. Generate AI Videos with Google Veo3, Save to Google Drive and Upload to YouTube156K
  6. Scrape business emails from Google Maps without the use of any third party APIs150K
  7. Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel99K
  8. AI-Powered Short-Form Video Generator with OpenAI, Flux, Kling, and ElevenLabs93K