MySQL
Salesforce
zapier

An automated workflow using zapier

Connects MySQL + Salesforce

Create Salesforce leads from new MySQL Database entries

About this workflow template

This automation scenario allows you to connect MySQL and Salesforce

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.

Categories

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

Diagram

Create Salesforce leads from new MySQL Database entries
Workflow diagram: MySQL + Salesforce integration

How it works?

When this trigger fires in MySQL

MySQL

New Row in MySQL

Triggered when you add a new row.

Then this action happens in Salesforce

Salesforce

Create Record in Salesforce

Creates a new record of a specified Salesforce object (ie. Contact, Lead, Opportunity, etc.).

How to set up this workflow

This guide contains information on how to set up an automatic workflow that allows to Create Salesforce leads from new MySQL Database entries.

Part I

Configure Applications

First, we need to connect MySQL and Salesforce to Zapier.

  • Create Zapier account.

    Create Zapier account.

    Create Zapier account if you don't have one.

  • Connect MySQL to Zapier.

    Connect MySQL to Zapier.

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

  • Connect Salesforce to Zapier.

    Connect Salesforce to Zapier.

    Give Zapier access to your Salesforce account, using Salesforce 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 MySQL

    Set up a Trigger action for MySQL

    Choose the following trigger: New Row (Triggered when you add a new row.).

  • Then set up an Action for Salesforce

    Then set up an Action for Salesforce

    Choose this action: Create Record (Creates a new record of a specified Salesforce object (ie. Contact, Lead, Opportunity, etc.).).

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 MySQL and Salesforce.

  • 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 Create Salesforce leads from new MySQL Database entries!

Supported triggers and actions

  • Salesforce

    New record

    Triggers when a record of the specified Salesforce object (ie. Contact, Lead, Opportunity, etc.) is created.

    zapier
    triggerbyzapier
  • Salesforce

    Updated field on record

    Triggers when a field of your choosing (ie. email address, status) is updated on any record of a specified Salesforce object (ie. Contact, Lead, Opportunity, etc.).

    zapierpabbly-connect
    triggerbyzapierpabbly-connect
  • Salesforce

    Updated record

    Triggers when any record of the specified Salesforce object (ie. Contact, Lead, Opportunity, etc.) is updated.

    zapier
    triggerbyzapier
  • Salesforce

    Watch records in an object

    Triggers when a record in an object is created or updated.

    integromat
    triggerbyintegromat
  • Salesforce

    New outbound message

    Triggers when a new outbound message is received in Salesforce.

    zapier
    triggerbyzapier
  • Salesforce

    Opportunity was won

    This Trigger fires every time an Opportunity changes to the "Closed Won" stage. Note: For realtime notifications, you or your Salesforce administrator must install the IFTTT Salesforce Package. For more details see: ift.tt/salesforce

    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

Salesforce

Salesforce

CRM

Enterprise cloud CRM platform

Salesforce is the world's top-rated Customer Success Platform and #1 Cloud-based CRM application. It unites all departments with a shared view of every customer and boosts sales productivity with industry-specific apps and best practices.

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.