Google Analytics + MySQL + Schedule by Zapier Integrations

How to connect Google Analytics + MySQL + Schedule by Zapier

Zapier lets you send info between Google Analytics, MySQL, and Schedule by Zapier automatically—no code required.

When this happens...

automatically do this...

then do this!

Free forever for core features
14 day trial for premium features & apps

Do even more with Google Analytics + MySQL + Schedule by Zapier

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Google Analytics, MySQL, and Schedule by Zapier. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

- AccountRequired
  Be sure the Google Analytics account you are using has "Analyst" permissions
- PropertyRequired
- View (Profile)Required
Trigger
Scheduled
Try It
- AccountRequired
  Be sure the Google Analytics account you are using has "Analyst" permissions
- PropertyRequired
- View (Profile)Required
- Start DateRequired
- End DateRequired
- Output FormatRequired
  How Zapier will format the raw data from Google. Read more in the help docs.
- MetricsRequired
  Can select up to ten metrics to include in the report.
- Metric
- Comparison
- Value
- Dimensions
  Can select up to seven dimensions.
- Dimension
- Comparison
- Value
- Segments
  Maximum of four. Using segments reduces the total number of dimensions allowed to six.
- Metric to Sort By
  Must be a metric included in the report.
- Sort Order
  When sorting by a metric, which direction to sort.
- Limit
Action
Write
- AccountRequired
  Be sure the Google Analytics account you are using has "Analyst" permissions
- PropertyRequired
- View (Profile)Required
- Goal IdRequired
  Be sure the Google Analytics account you are using has "Analyst" permissions.
Action
Search
- Table/ViewRequired
  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.
- Order By
  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 [ ].
- Dedupe Key
  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.
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It

- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

- Trigger on weekends?
  Should this Zap trigger on Saturday and Sunday?
- Time of DayRequired
  Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Trigger
Instant
Try It
- Day of the MonthRequired
  Day of month this schedule should trigger on.
- Time of DayRequired
  Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Trigger
Instant
Try It

- AccountRequired
  Be sure the Google Analytics account you are using has "Analyst" permissions
- PropertyRequired
- TypeRequired
Action
Write
- AccountRequired
  Be sure the Google Analytics account you are using has "Analyst" permissions
- PropertyRequired
- View (Profile)Required
- Goal IDRequired
  A positive whole number.
- Name
- Value
  Assign a monetary value to the conversion.
- Active
- Type
Action
Write
- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
  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
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
  Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].
- Order ByRequired
  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 Column
  Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
  You should include desired ordering and limiting (usually to 1 record) in the query.
  This query must run in less than ~30 seconds.
Action
Search
- Trigger on weekends?
  Should this Zap trigger on Saturday and Sunday?
Trigger
Instant
Try It
- Day of the WeekRequired
- Time of DayRequired
  Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Trigger
Instant
Try It

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

How Google Analytics + MySQL + Schedule by Zapier Integrations Work

Step 1: Authenticate Google Analytics, MySQL, and Schedule by Zapier.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Google Analytics + MySQL + Schedule by Zapier

About Google Analytics

Google Analytics is an industry standard freemium web and mobile analytics package.

Related categories

Similar apps

New Relic

Server Monitoring

Ruler Analytics

Call Tracking

Mixpanel

Ads & Conversion

About MySQL

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

Related categories

Databases

Similar apps

SQL Server

Databases

Quick Base

Databases

Firebase / Firestore

Databases

About Schedule by Zapier

Schedule is a native Zapier app you can use for recurring tasks. Trigger an action every day of the month, every day of the week or every single day. You can also select the hour of the day. If you're a developer, this is similar to a crontab, cronjob or cron.

Related categories

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Google Analytics + MySQL + Schedule by Zapier Integrations

How to connect Google Analytics + MySQL + Schedule by Zapier

Do even more with Google Analytics + MySQL + Schedule by Zapier

New Goals

PropertyRequired

View (Profile)Required

Run Report

AccountRequired

PropertyRequired

View (Profile)Required

Start DateRequired

End DateRequired

Output FormatRequired

MetricsRequired

Metric

Comparison

Value

Dimensions

Dimension

Comparison

Value

Segments

Metric to Sort By

Sort Order

Limit

Search Goal

AccountRequired

PropertyRequired

View (Profile)Required

Goal IdRequired

New Row

Table/ViewRequired

Order By

Dedupe Key

New Table

New Row

TableRequired

Find Row

TableRequired

Lookup ColumnRequired

Lookup ValueRequired

Every Day

Trigger on weekends?

Time of DayRequired

Every Month

Day of the MonthRequired

Time of DayRequired

Create a Measurement

AccountRequired

PropertyRequired

TypeRequired

Update Goal

AccountRequired

PropertyRequired

View (Profile)Required

Goal IDRequired

Name

Value

Active

Type

New Column

Table/ViewRequired

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Row via Custom Query

QueryRequired

Every Hour

Trigger on weekends?

Every Week

Day of the WeekRequired

Time of DayRequired

Connect your apps and automate workflows