Skip to main content

Push Data to Google Cloud Storage (GCS)

Who gets this? Data Warehouse Push is currently only available in beta for Postscript brands on the enterprise plan. To begin using Data Warehouse Push, please be sure to first contact your Customer Success Manager.

Data Warehouse Push allows Postscript to automatically send both historical and new data stored in-app, including clicks, order attribution, and more, to your designated data warehouse.

In this article, we'll walk you through the three steps for configuring your Google Cloud Storage (GCS) destination.

IMPORTANT! Once complete, share the credentials with Postscript and we'll handle the rest.

Prerequisites

  • An active Google Cloud Platform (GCP) account with console Admin access


Step 1: Create a Service Account

  1. Log in to the Google Cloud Console.

  2. Navigate to IAM & Admin > Service Accounts and select Create Service Account.

  3. Give the service account a name (e.g. postscript-integration) and select Create and Continue.

  4. Assign the following roles:

    • BigQuery Admin

    • Storage Admin

  5. Select Done.

NOTE: In some projects, the Storage Admin role may not include the storage.buckets.get permission by default. If you run into access errors, create a custom role that mirrors Storage Admin with that permission added, and assign the custom role to the service account instead.


Step 2: Generate a JSON Key

  1. From the Service Accounts list, select on the service account you just created.

  2. Go to the Keys tab and select Add Key > Create new key.

  3. Select JSON and select Create.

  4. The key file downloads automatically — keep it secure. You'll need to share it with Postscript.


Step 3: Enable the Cloud Storage API

  1. In the GCP Console, navigate to APIs & Services > Library.

  2. Search for Google Cloud Storage JSON API and select Enable.


Step 4: Create a GCS Bucket

  1. In the GCP Console, navigate to Cloud Storage > Buckets and select Create Bucket.

  2. Set a bucket name (e.g. yourcompany-postscript-data).

  3. Set the storage class to Regional (Multi-Region is not recommended) and choose your preferred region.

  4. Select Create.


Step 5: Gather Your Connection Details

Once the above steps are complete, send the following to your Postscript contact:

Field

Description

JSON Key File

The file downloaded in Step 2

Project ID

Found on the GCP Console home page

Project Number

Found on the GCP Console home page (optional)

Service Account Email

The email address of the service account (e.g. [email protected])

Bucket Name

The name of the GCS bucket you created in Step 4

Region

The region your bucket is in (e.g. us-central1)

Get Support


Have questions? Please feel free to reach out to our Support team at [email protected] or via live chat.

Need ongoing channel strategy guidance? Please fill out this form and we'll connect you to one of our certified partners.

Did this answer your question?