← Typeform + Google Cloud integrations

Bigquery Insert Rows with Google Cloud API on New Submission from Typeform API

Pipedream makes it easy to connect APIs for Google Cloud, Typeform and 1000+ other apps remarkably fast.

Trigger workflow on
New Submission from the Typeform API
Next, do this
Bigquery Insert Rows with the Google Cloud API
No credit card required
Into to Pipedream
Watch us build a workflow
Watch us build a workflow
7 min
Watch now ➜

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

Adyen logo
Brex logo
Carta logo
Checkr logo
Chameleon logo
DevRev logo
LinkedIn logo
Netflix logo
New Relic logo
OnDeck logo
Replicated logo
Scale AI logo
Teamwork logo
Warner Bros. logo
Xendit logo

Developers Pipedream

Getting Started

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

  1. Select this integration
  2. Configure the New Submission trigger
    1. Connect your Typeform account
    2. Select a Form
  3. Configure the Bigquery Insert Rows action
    1. Connect your Google Cloud account
    2. Select a Dataset ID
    3. Select a Table Name
    4. Configure Rows
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. 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

Description:Emit new submission
Version:0.0.5
Key:typeform-new-submission

Typeform Overview

With the Typeform API, you can easily create beautiful, interactive forms that
allow people to share their information with you in an engaging way. Here are
some examples of what you can build with the Typeform API:

  • A contact form for your website that allows people to easily get in touch
    with you
  • An order form for your product or service that allows people to place orders
    easily and securely
  • A survey form that allows you to collect data and feedback from people
  • A registration form for your event or conference that allows people to sign
    up easily and securely

Trigger Code

import { createHmac } from "crypto";
import { uuid } from "uuidv4";
import common from "../common.mjs";
import constants from "../../constants.mjs";
import utils from "../utils.mjs";

const { typeform } = common.props;
const { parseIsoDate } = utils;

export default {
  ...common,
  key: "typeform-new-submission",
  name: "New Submission",
  version: "0.0.5",
  type: "source",
  description: "Emit new submission",
  props: {
    ...common.props,
    http: "$.interface.http",
    db: "$.service.db",
    formId: {
      propDefinition: [
        typeform,
        "formId",
      ],
    },
  },
  methods: {
    ...common.methods,
    generateSecret() {
      return "" + Math.random();
    },
  },
  hooks: {
    ...common.hooks,
    async activate() {
      const secret = this.generateSecret();
      this._setSecret(secret);

      let tag = this._getTag();
      if (!tag) {
        tag = uuid();
        this._setTag(tag);
      }

      return await this.typeform.createHook({
        endpoint: this.http.endpoint,
        formId: this.formId,
        tag,
        secret,
      });
    },
    async deactivate() {
      const tag = this._getTag();

      return await this.typeform.deleteHook({
        formId: this.formId,
        tag,
      });
    },
  },
  async run(event) {
    const {
      body,
      headers,
    } = event;

    const { [constants.TYPEFORM_SIGNATURE]: typeformSignature } = headers;

    if (typeformSignature) {
      const secret = this._getSecret();

      const hmac =
        createHmac(constants.ALGORITHM, secret)
          .update(body)
          .digest(constants.ENCODING);

      const signature = `${constants.ALGORITHM}=${hmac}`;

      if (typeformSignature !== signature) {
        throw new Error("signature mismatch");
      }
    }

    let formResponseString = "";
    const data = Object.assign({}, body.form_response);
    data.form_response_parsed = {};

    for (let i = 0; i < body.form_response.answers.length; i++) {
      const field = body.form_response.definition.fields[i];
      const answer = body.form_response.answers[i];

      let parsedAnswer;
      let value = answer[answer.type];

      if (value.label) {
        parsedAnswer = value.label;

      } else if (value.labels) {
        parsedAnswer = value.labels.join();

      } else if (value.choice) {
        parsedAnswer = value.choice;

      } else if (value.choices) {
        parsedAnswer = value.choices.join();

      } else {
        parsedAnswer = value;
      }

      data.form_response_parsed[field.title] = parsedAnswer;
      formResponseString += `### ${field.title}\n${parsedAnswer}\n`;
    }

    data.form_response_string = formResponseString;
    data.raw_webhook_event = body;

    if (data.landed_at) {
      data.landed_at = parseIsoDate(data.landed_at);
    }

    if (data.submitted_at) {
      data.submitted_at = parseIsoDate(data.submitted_at);
    }

    data.form_title = body.form_response.definition.title;
    delete data.answers;
    delete data.definition;

    this.$emit(data, {
      summary: JSON.stringify(data),
      id: data.token,
    });
  },
};

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.
LabelPropTypeDescription
TypeformtypeformappThis component uses the Typeform app.
N/Ahttp$.interface.httpThis component uses $.interface.http to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the run() method of the component.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
FormformIdstringSelect a value from the drop down menu.

Trigger Authentication

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

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

offlineaccounts:readforms:writeforms:readimages:writeimages:readthemes:writethemes:readresponses:readresponses:writewebhooks:readwebhooks:writeworkspaces:readworkspaces:write

About Typeform

People-Friendly Forms and Surveys

Action

Description:Inserts rows into a BigQuery table. [See the docs](https://github.com/googleapis/nodejs-bigquery) and for an example [here](https://github.com/googleapis/nodejs-bigquery/blob/main/samples/insertRowsAsStream.js).
Version:0.0.1
Key:google_cloud-bigquery-insert-rows

Google Cloud Overview

The Google Cloud API allows developers to access a variety of Google Cloud
services from their own applications. Services that can be accessed include
Google Cloud Storage, Google Cloud Datastore, Google Cloud Functions, and
Google Cloud Pub/Sub. With the Google Cloud API, developers can build a variety
of applications that take advantage of Google Cloud services.

Action Code

import googleCloud from "../../google_cloud.app.mjs";
import utils from "../../common/utils.mjs";

export default {
  name: "Bigquery Insert Rows",
  version: "0.0.1",
  key: "google_cloud-bigquery-insert-rows",
  type: "action",
  description: "Inserts rows into a BigQuery table. [See the docs](https://github.com/googleapis/nodejs-bigquery) and for an example [here](https://github.com/googleapis/nodejs-bigquery/blob/main/samples/insertRowsAsStream.js).",
  props: {
    googleCloud,
    datasetId: {
      propDefinition: [
        googleCloud,
        "datasetId",
      ],
    },
    tableId: {
      propDefinition: [
        googleCloud,
        "tableId",
        ({ datasetId }) => ({
          datasetId,
        }),
      ],
    },
    rows: {
      type: "string[]",
      label: "Rows",
      description: "The rows to insert into the table. Each row is a JSON object with column names as keys and rows as values. E.g. `{\"name\": \"John\", \"age\": 20}`",
    },
  },
  async run({ $ }) {
    const {
      datasetId,
      tableId,
      rows,
    } = this;

    if (!Array.isArray(rows)) {
      throw new Error("Rows must be an array");
    }

    const rowsParsed = rows.map(utils.parse);

    try {
      const response = await this.googleCloud
        .getBigQueryClient()
        .dataset(datasetId)
        .table(tableId)
        .insert(rowsParsed);

      $.export("$summary", `Successfully inserted ${rows.length} rows into ${datasetId}.${tableId}`);

      return response;
    } catch (error) {
      console.log(JSON.stringify(error.errors, null, 2));
      throw error;
    }
  },
};

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.

LabelPropTypeDescription
Google CloudgoogleCloudappThis component uses the Google Cloud app.
Dataset IDdatasetIdstringSelect a value from the drop down menu.
Table NametableIdstringSelect a value from the drop down menu.
Rowsrowsstring[]

The rows to insert into the table. Each row is a JSON object with column names as keys and rows as values. E.g. {"name": "John", "age": 20}

Action Authentication

Google Cloud uses API keys for authentication. When you connect your Google Cloud account, Pipedream securely stores the keys so you can easily authenticate to Google Cloud APIs in both code and no-code steps.

  1. Create a service account in GCP and set the permissions you need for Pipedream workflows.

  2. Generate a service account key

  3. Download the key details in JSON format

  4. Open the JSON in a text editor, and copy and paste its contents here.

About Google Cloud

The Google Cloud Platform

More Ways to Connect Google Cloud + Typeform

Create a Form with Typeform API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Typeform
 
Try it
Create an Image with Typeform API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Typeform
 
Try it
Delete Form with Typeform API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Typeform
 
Try it
Create a Form with Typeform API on BigQuery - New Row from Google Cloud API
Google Cloud + Typeform
 
Try it
Delete an Image with Typeform API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Typeform
 
Try it
New Submission from the Typeform API

Emit new submission

 
Try it
New Pub/Sub Messages from the Google Cloud API

Emit new Pub/Sub topic in your GCP account. Messages published to this topic are emitted from the Pipedream source.

 
Try it
BigQuery - New Row from the Google Cloud API

Emit new events when a new row is added to a table

 
Try it
BigQuery - Query Results from the Google Cloud API

Emit new events with the results of an arbitrary query

 
Try it
Create a Form with the Typeform API

Creates a form with its corresponing fields. See the docs here

 
Try it
Create an Image with the Typeform API

Adds an image in your Typeform account. See the docs here

 
Try it
Delete an Image with the Typeform API

Deletes an image from your Typeform account. See the docs here

 
Try it
Delete Form with the Typeform API

Select a form to be deleted. See the docs here.

 
Try it
Duplicate a Form with the Typeform API

Duplicates an existing form in your Typeform account and adds "(copy)" to the end of the title. See the docs here

 
Try it