We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.

**Highly recommended!** Usually you want the results to be most recent first so we can skim off only new results, so choose something like `date_created` or your autoincrement `id`. Column names that contain a space must be enclosed within brackets `[ ]`.

We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.

Query results must have a unique `id` field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.

**Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows**

Usually something auto-incremented like `id`. Must be unique. Column names that contain a space must be enclosed within brackets `[ ]`.

Usually something like `date_updated` or `last_modified`. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.

Trigger on changes to cells in this column only. To trigger on changes to any column, leave blank and use a date field like `date_updated` or `last_modified` as Order By.

To trigger on updates to any column, leave the field "Trigger Column" blank and use a datetime field like `date_updated` or `last_modified` as Order By. This field should be automatically updated by your database when the row is updated, and will be used to identify the updates and trigger the Zap.

You should include desired ordering and limiting (usually to 1 record) in the query.

**This query must run in less than ~30 seconds.**

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

MySQL

SQL server (or MS SQL) is a top of the line database geared for the cloud

SQL Server

Quickbase makes it easy to create custom applications and workflows to streamline processes, with IT visibility and control.

Quickbase

Firebase Realtime Database and Google Cloud Firestore are flexible databases that give you the ability to easily store and sync app data at global scale.

Firebase / Firestore

Amazon Relational Database Services (RDS) allow you to set up, operate, and scale relational databases in the cloud.

Amazon Relational Database Services (RDS)

Log in to Cyfe and configure a new Push API widget on your dashboard. On the widget configuration screen you will find an API endpoint for that particular widget. Copy/paste that endpoint below (e.g. "https<nolink />://app.cyfe.com/api/push/45ed0a904").
<div><i>Tip: Be sure to click the "Save Widget" button to activate the widget in Cyfe.</i></div>

Enter the name of your metric (e.g. "Emails", "Leads", or "Sales").

Enter or select the value you want to add to your Cyfe widget when this Zap is triggered. For example, if you're looking to track new emails received in Gmail over time then you would enter "1" below. On the other hand if you're looking to track the amount of sales generated in Quickbooks over time then you would select the Quickbooks "Amount" field using the "Insert fields" button.
<div><i>Tip: Please reach out to support@cyfe.com if you need help with this.</i></div>

Enter a hexadecimal color code for your metric (e.g. "#2fd75b" or "#ff7e0e").

Select whether this is a numeric metric (e.g. number of leads) or a currency based metric (e.g. amount of sales).

Select whether high values should be perceived as good or bad (e.g. high "sales" are good while high "expenses" are bad).

Cyfe is an all-in-one business dashboard app that helps you easily monitor all your business data from one place (e.g. social media, analytics, marketing, sales, support, infrastructure, etc).

Cyfe

MySQL databases are powerful, but they can be hard to digest. With this Zapier automation, every new row in a MySQL database is sent to Cyfe as a value in a dashboard widget, creating a graph that you can understand at a glance. 

A new row is added to your MySQL database

Zapier sees that new row, and automatically pushes a value to your Cyfe dashboard widget

A Cyfe account, with at least one Push API widget set up on your dashboard

Cyfe + MySQL

Track the number of new MySQL rows over time in Cyfe

Supported triggers and actions

New Column

New Row (Custom Query)

New or Updated Row

Update Row

Find Row via Custom Query

New Row

New Table

New Row

Find Row

Push Value

About Cyfe

Related categories

About MySQL

Related categories

Similar apps

SQL Server

Quickbase

Firebase / Firestore