Automate data insertion from Google Sheets to MySQL weekly

• Automate weekly updates of inventory data from Google Sheets to MySQL.
• Streamline sales tracking by syncing data from Google Sheets to a MySQL database.
• Maintain an up-to-date database of contacts by automating data insertion.

Cron node triggers the workflow every week at 5 AM. Google Sheets node reads data from a specified sheet. MySQL node inserts the retrieved data into the designated database table.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure the Cron node to set the desired trigger time.
3. 3
   Set up the Google Sheets node with the correct sheet ID and authentication.
4. 4
   Connect the MySQL node to your database and specify the table for data insertion.
5. 5
   Test the workflow to ensure data is being transferred correctly.