Run Report in GA4 with Google Analytics API on Custom Interval from Schedule API

Pipedream makes it easy to connect APIs for Google Analytics, Schedule and 2,000+ other apps remarkably fast.

Trigger workflow on

Custom Interval from the Schedule API

Next, do this

Run Report in GA4 with the Google Analytics API

No credit card required

▶

Watch us build a workflow

4 min

Watch now ➜

Trusted by 800,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Schedule trigger and Google Analytics action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the Custom Interval trigger
1. Connect your Schedule account
2. Configure Cron Schedule
Configure the Run Report in GA4 action
1. Connect your Google Analytics account
2. Configure Property
3. Configure Start Date
4. Configure End Date
5. Configure Metrics
6. Optional- Configure Dimensions
7. Optional- Configure Dimension filter
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

Custom Interval on Schedule

Description:Trigger your workflow every N hours, minutes or seconds.

Version:0.0.2

Key:schedule-custom-interval

View on GitHub

Schedule Overview#

The Schedule app in Pipedream is a powerful tool that allows you to trigger workflows at regular intervals, ranging from every minute to once a year. This enables the automation of repetitive tasks and the scheduling of actions to occur without manual intervention. By leveraging this API, you can execute code, run integrations, and process data on a reliable schedule, all within Pipedream's serverless environment.

Trigger Code#

import schedule from "../../schedule.app.mjs";

export default {
  name: "Custom Interval",
  version: "0.0.2",
  key: "schedule-custom-interval",
  type: "source",
  description: "Trigger your workflow every N hours, minutes or seconds.",
  props: {
    schedule,
    cron: {
      propDefinition: [
        schedule,
        "cron",
      ],
    },
  },
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Schedule	`schedule`	`app`	This component uses the Schedule app.
Cron Schedule	`cron`	`$.interface.timer`	Enter a cron expression

Trigger Authentication#

The Schedule API does not require authentication.

About Schedule#

Trigger workflows on an interval or cron schedule.

Action#

Run Report in GA4 on Google Analytics

Description:Returns a customized report of your Google Analytics event data. Reports contain statistics derived from data collected by the Google Analytics tracking code. [See the documentation here](https://developers.google.com/analytics/devguides/reporting/data/v1/rest/v1beta/properties/runReport)

Version:0.0.3

Key:google_analytics-run-report-in-ga4

View on GitHub

Google Analytics Overview#

The Google Analytics API unlocks the power of your analytics data, enabling automated access to custom reports, real-time statistics, and user behavior analysis. With it, you can extract actionable insights, push data to other platforms, and tailor your business strategy with precision. Leveraging Pipedream's serverless platform, these capabilities can be seamlessly integrated into workflows that trigger actions in other apps, send alerts, or even feed data warehouses for deeper analysis.

Action Code#

import analytics from "../../google_analytics.app.mjs";

export default {
  key: "google_analytics-run-report-in-ga4",
  version: "0.0.3",
  name: "Run Report in GA4",
  description: "Returns a customized report of your Google Analytics event data. Reports contain statistics derived from data collected by the Google Analytics tracking code. [See the documentation here](https://developers.google.com/analytics/devguides/reporting/data/v1/rest/v1beta/properties/runReport)",
  type: "action",
  props: {
    analytics,
    property: {
      type: "string",
      label: "Property",
      description: "A Google Analytics GA4 property identifier whose events are tracked. Specified in the URL path and not the body. To learn more, [see where to find your Property ID](https://developers.google.com/analytics/devguides/reporting/data/v1/property-id). Within a batch request, this property should either be unspecified or consistent with the batch-level property.",
    },
    startDate: {
      type: "string",
      label: "Start Date",
      description: "Start date in YYYY-MM-DD format",
    },
    endDate: {
      type: "string",
      label: "End Date",
      description: "End date in YYYY-MM-DD format",
    },
    metrics: {
      type: "string[]",
      label: "Metrics",
      description: "Metrics attributes for your data. Explore the available metrics [here](https://developers.google.com/analytics/devguides/reporting/data/v1/api-schema#metrics)",
    },
    dimensions: {
      type: "string[]",
      label: "Dimensions",
      description: "Dimension attributes for your data. Explore the available dimensions [here](https://developers.google.com/analytics/devguides/reporting/data/v1/api-schema#dimensions)",
      optional: true,
    },
    dimensionFilter: {
      type: "object",
      label: "Dimension filter",
      description: "Dimension filters let you ask for only specific dimension values in the report. Read more about dimension filters [here](https://developers.google.com/analytics/devguides/reporting/data/v1/basics#dimension_filters)",
      optional: true,
    },
  },
  async run({ $ }) {
    const metrics = this.metrics || [];
    const dimensions = this.dimensions || [];

    const dimensionFilter = typeof this.dimensionFilter === "string"
      ? JSON.parse(this.dimensionFilter)
      : this.dimensionFilter;

    const data = {
      dateRanges: [
        {
          startDate: this.startDate,
          endDate: this.endDate,
        },
      ],
      dimensions: dimensions.map((dimension) => ({
        name: dimension,
      })),
      metrics: metrics.map((metric) => ({
        name: metric,
      })),
      dimensionFilter: dimensionFilter,
    };
    const report = await this.analytics.queryReportsGA4({
      property: this.property,
      data,
    });
    $.export("$summary", `Successfully retrieved report for the property ${this.property}`);
    return report;
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Google Analytics	`analytics`	`app`	This component uses the Google Analytics app.
Property	`property`	`string`	A Google Analytics GA4 property identifier whose events are tracked. Specified in the URL path and not the body. To learn more, see where to find your Property ID. Within a batch request, this property should either be unspecified or consistent with the batch-level property.
Start Date	`startDate`	`string`	Start date in YYYY-MM-DD format
End Date	`endDate`	`string`	End date in YYYY-MM-DD format
Metrics	`metrics`	`string[]`	Metrics attributes for your data. Explore the available metrics here
Dimensions	`dimensions`	`string[]`	Dimension attributes for your data. Explore the available dimensions here
Dimension filter	`dimensionFilter`	`object`	Dimension filters let you ask for only specific dimension values in the report. Read more about dimension filters here

Action Authentication#

Google Analytics uses OAuth authentication. When you connect your Google Analytics account, Pipedream will open a popup window where you can sign into Google Analytics and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Google Analytics API.

Pipedream requests the following authorization scopes when you connect your account:

emailprofilehttps://www.googleapis.com/auth/analytics.readonlyhttps://www.googleapis.com/auth/analytics.edit

Try it

Run Report with Google Analytics API on Weekly schedule from Schedule API

Schedule + Google Analytics

Try it

Run Report with Google Analytics API on Custom Interval from Schedule API

Schedule + Google Analytics

Try it

Run Report with Google Analytics API on Monthly Schedule from Schedule API

Schedule + Google Analytics

Try it

Run Report in GA4 with Google Analytics API on Daily schedule from Schedule API

Schedule + Google Analytics

Try it

Popular Triggers#

Custom Interval from the Schedule API

Trigger your workflow every N hours, minutes or seconds.

Try it

Daily schedule from the Schedule API

Trigger your workflow every day.

Try it

Monthly Schedule from the Schedule API

Trigger your workflow on one or more days each month at a specific time (with timezone support).

Try it

Weekly schedule from the Schedule API

Trigger your workflow on one or more days each week at a specific time (with timezone support).

Try it

New Page Opened from the Google Analytics API

Emit new event when a page is viewed

Try it

Popular Actions#

Create GA4 Property with the Google Analytics API

Creates a new GA4 property. See the documentation

Try it

Run Report with the Google Analytics API

Return report metrics based on a start and end date. See the docs here

Try it

Run Report in GA4 with the Google Analytics API

Returns a customized report of your Google Analytics event data. Reports contain statistics derived from data collected by the Google Analytics tracking code. See the documentation here

Try it