Google Drive
MySQL
zapier

An automated workflow using zapier

Connects Google Drive + MySQL

Add rows to a MySQL database for new Google Drive files

About this workflow template

This automation scenario allows you to connect Google Drive and MySQL

It can be build using Zapier, a no-code workflow automation tool. Zapier allows you to create automated scripts using a simple drag-and-drop interface for non-technical users. This is a ready-made scenario, but it can be customized by adding more apps, actions, filters or branches.

Google Drive and MySQL can also be integrated using automation tools other than zapier:

Diagram

Add rows to a MySQL database for new Google Drive files
Workflow diagram: Google Drive + MySQL integration

How it works?

When this trigger fires in Google Drive

Google Drive

New File in Google Drive

Triggers when any new file is added (inside of any folder).

Then this action happens in MySQL

MySQL

New Row in MySQL

Adds a new row.

How to set up this workflow

This guide contains information on how to set up an automatic workflow that allows to Add rows to a MySQL database for new Google Drive files.

Part I

Configure Applications

First, we need to connect Google Drive and MySQL to Zapier.

  • Create Zapier account.

    Create Zapier account.

    Create Zapier account if you don't have one.

  • Connect Google Drive to Zapier.

    Connect Google Drive to Zapier.

    Give Zapier access to your Google Drive account, using Google Drive credentials.

  • Connect MySQL to Zapier.

    Connect MySQL to Zapier.

    Give Zapier access to your MySQL account, using MySQL credentials.

Part II

Build an integration workflow

Next, we need to create a workflow automation scenario using graphical no-code web interface of Zapier.

  • Set up a Trigger action for Google Drive

    Set up a Trigger action for Google Drive

    Choose the following trigger: New File (Triggers when any new file is added (inside of any folder).).

  • Then set up an Action for MySQL

    Then set up an Action for MySQL

    Choose this action: New Row (Adds a new row.).

Part III

Test and Publish

Finally, we need to test this automation and publish it.

  • Customize data flow

    Customize data flow

    Configure the data that is exchanged between Google Drive and MySQL.

  • Test the workflow and turn it on for production use

    Test the workflow and turn it on for production use

    Test your scenario and publish to production. Now you have an automatic workflow, that will Add rows to a MySQL database for new Google Drive files!

Supported triggers and actions

  • Google Drive

    New file in folder (legacy)

    Triggers when a new file is created within a specific folder (but not its subfolders). Please note for files moved to a folder, this trigger may not work as expected, use the newer version for that use case.

    zapier
    triggerbyzapier
  • Google Drive

    New file

    Triggers when any new file is added (inside of any folder).

    zapierautomateiopabbly-connect
    triggerbyzapierautomateiopabbly-connect
  • Google Drive

    New file in folder

    Triggers when there is a new file in a specific folder

    automateiozapier
    triggerbyautomateiozapier
  • Google Drive

    Watch files in a folder

    Triggers when a file is created or modified in a selected folder.

    integromat
    triggerbyintegromat
  • Google Drive

    Updated file

    Triggers when a file is updated in a specific folder (but not its subfolders).

    zapierautomateiopabbly-connect
    triggerbyzapierautomateiopabbly-connect
  • Google Drive

    New file in your folder

    This trigger fires every time a new file is added to the Google Drive folder you specify. Note: Does not work for Google Docs, Forms, or Sheets files.

    ifttt
    triggerbyifttt
  • MySQL

    Update row

    Updates an existing row.

    zapierautomateiopipedreamintegrately
    actionbyzapierautomateiopipedreamintegrately
  • MySQL

    Find row

    Finds a row in a table via a lookup column.

    zapierpipedream
    actionbyzapierpipedream
  • MySQL

    Create row

    Create row

    pipedreamintegrately
    actionbypipedreamintegrately
  • MySQL

    Delete row

    Delete row

    pipedream
    actionbypipedream
  • MySQL

    Execute query

    Execute query

    pipedream
    actionbypipedream
  • MySQL

    Execute stored procedure

    Execute stored procedure

    pipedream
    actionbypipedream

Apps you need

Google Drive

Google Drive

Cloud Storage

A comprehensive cloud storage solution

Google Drive is a versatile cloud-based platform that lets you store your files, photos, videos, and more safely. You can access them from anywhere and share with others, making collaboration a breeze.

Zapier

Zapier

Automation Platforms

No-code automation service

Zapier simplifies busy people's lives by automating web app data transfers, reducing tedious tasks, and allowing teams to collaborate effortlessly. With over 5,000 popular apps connected, it's never been easier to streamline your workflow.