Google Analytics + Google BigQuery + Schedule by Zapier Integrations

How to connect Google Analytics + Google BigQuery + Schedule by Zapier

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

When this happens...

automatically do this...

then do this!

Free 14-day trial

5,000+ supported apps

Do even more with Google Analytics + Google BigQuery + 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, Google BigQuery, 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
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
  Only columns that are type integer, bytes, int64, float, timestamp, date, datetime, numeric, bignumeric are returned. The column will be sorted in descending order. The latest row will be returned.
- Unique ColumnRequired
  The unique column is used to determine if a row is new. For example if the unique column is id and the latest row has an id of 1, then the next time the trigger runs, if the latest row has an id of 2, then the trigger will return the row with an id of 2.
Trigger
Scheduled
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
  The column to match against the value in the WHERE clause. The where clause will be WHERE column = value
- ValueRequired
  The value to match against the column in the WHERE clause. The where clause will be WHERE column = value
Trigger
Scheduled
Try It

- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
  Rows must be an array of objects. Example [{'id': '1', 'name': 'Test'}, {'id': '2', 'name': 'Test2'}]
- Skip Invalid Rows
  Insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist.
- Ignore Unknown Values
Action
Write

- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
  Only columns that are type integer, bytes, int64, float, timestamp, date, datetime, numeric, bignumeric are returned. The column will be sorted in descending order. The latest row will be returned.
- Sort Direction
  Required if Sort By Column is selected. Choose whether to sort the values Ascending or Descending.
- Where ClauseRequired
  Define the SQL WHERE clause which will determine which data is returned.
- LimitRequired
  Define how many rows to return.
Action
Search
- Project IDRequired
- SQL QueryRequired
  The raw SQL query to run against the table.
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

- 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
- ProjectRequired
- Dataset
- Table
  Only trigger for query jobs that reference the selected table. Leave blank for all query job results.
Trigger
Scheduled
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
  The column to match against the value in the WHERE clause. The where clause will be WHERE column = value
- Where ValueRequired
  The value to match against the column in the WHERE clause. The where clause will be WHERE column = value
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
  The column to match against the value in the WHERE clause. The where clause will be WHERE column = value
- Where ValueRequired
  The value to match against the column in the WHERE clause. The where clause will be WHERE column = value
- Update ColumnsRequired
  The columns and values to update in the table row. Separate each column and value with a comma. Example: column1=value1,column2=value2
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
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

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 + Google BigQuery + Schedule by Zapier Integrations Work

Step 1: Authenticate Google Analytics, Google BigQuery, 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 + Google BigQuery + 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 Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Related categories

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 + Google BigQuery + Schedule by Zapier Integrations

How to connect Google Analytics + Google BigQuery + Schedule by Zapier

Do even more with Google Analytics + Google BigQuery + 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

Project IDRequired

DatasetRequired

TableRequired

Sort By ColumnRequired

Unique ColumnRequired

Update Row

Project IDRequired

DatasetRequired

TableRequired

Unique ColumnRequired

ValueRequired

Create Rows

ProjectRequired

DatasetRequired

TableRequired

Import Data

Project IDRequired

DatasetRequired

TableRequired

RowsRequired

Skip Invalid Rows

Ignore Unknown Values

Find Row(s)

Project IDRequired

DatasetRequired

TableRequired

Sort By Column

Sort Direction

Where ClauseRequired

LimitRequired

Run a Query

Project IDRequired

SQL QueryRequired

Every Hour

Trigger on weekends?

Every Week

Day of the WeekRequired

Time of DayRequired

Create a Measurement

AccountRequired

PropertyRequired

TypeRequired

Update Goal

AccountRequired

PropertyRequired

View (Profile)Required

Goal IDRequired

Name

Value