Update Customer with Formaloo API on New Database from Notion API

Pipedream makes it easy to connect APIs for Formaloo, Notion and 2,400+ other apps remarkably fast.

Trigger workflow on

New Database from the Notion API

Next, do this

Update Customer with the Formaloo API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

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

Select this integration
Configure the New Database trigger
1. Connect your Notion account
2. Configure timer
Configure the Update Customer action
1. Connect your Formaloo account
2. Select a Customer Code
3. Optional- Configure Full Name
4. Optional- Configure First Name
5. Optional- Configure Last Name
6. Configure Username
7. Configure Email
8. Configure Phone Number
9. Optional- Configure Number Of Tags
10. Optional- Configure Score
11. Optional- Select a Country
12. Optional- Select a State
13. Optional- Select a City
14. Optional- Select a Language
15. Optional- Configure Customer Data
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#

New Database on Notion

Description:Emit new event when a database is created. Note: Databases must be shared with your Pipedream Integtration to trigger event.

Version:0.0.8

Key:notion-new-database

View on GitHub

Notion Overview#

Notion's API allows for the creation, reading, updating, and deleting of pages, databases, and their contents within Notion. Using Pipedream's platform, you can build workflows that connect Notion with various other services to automate tasks such as content management, task tracking, and data synchronization. With Pipedream's serverless execution, you can trigger these workflows on a schedule, or by external events from other services, without managing any infrastructure.

Trigger Code#

import base from "../common/base.mjs";
import sampleEmit from "./test-event.mjs";
import constants from "../common/constants.mjs";

export default {
  ...base,
  key: "notion-new-database",
  name: "New Database",
  description: "Emit new event when a database is created. Note: Databases must be shared with your Pipedream Integtration to trigger event.",
  version: "0.0.8",
  type: "source",
  async run() {
    const databases = [];
    const params = this.lastCreatedSortParam();
    const lastCreatedTimestamp = this.getLastCreatedTimestamp();

    do {
      const response = await this.notion.listDatabases(params);

      for (const database of response.results) {
        if (!this.isResultNew(database.created_time, lastCreatedTimestamp)) {
          params.start_cursor = null;
          break;
        }
        databases.push(database);
      }

      params.start_cursor = response.next_cursor;
    } while (params.start_cursor);

    databases.reverse().forEach((database) => {
      const meta = this.generateMeta(
        database,
        constants.types.DATABASE,
        constants.timestamps.CREATED_TIME,
        constants.summaries.DATABASE_ADDED,
      );
      this.$emit(database, meta);
    });

    const lastCreatedTime = databases[databases.length - 1]?.created_time;
    if (lastCreatedTime) {
      this.setLastCreatedTimestamp(Date.parse(lastCreatedTime));
    }
  },
  sampleEmit,
};

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
Notion	`notion`	`app`	This component uses the Notion app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`

Trigger Authentication#

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

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

About Notion#

Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.

Action#

Update Customer on Formaloo

Description:Update a specific customer. [See the documentation](https://www.formaloo.com/en/developers/)

Version:0.0.1

Key:formaloo-update-customer

View on GitHub

Formaloo Overview#

The Formaloo API lets you interact with your forms and data on Formaloo. You can create new forms, fetch responses, analyze submissions, and more, right within Pipedream. Pipedream's serverless platform facilitates the automation of these tasks, enabling you to integrate Formaloo with hundreds of other services to streamline workflows, analyze data, and synchronize across platforms.

Action Code#

import formaloo from "../../formaloo.app.mjs";
import { prepareData } from "../common/utils.mjs";

export default {
  key: "formaloo-update-customer",
  name: "Update Customer",
  version: "0.0.1",
  description: "Update a specific customer. [See the documentation](https://www.formaloo.com/en/developers/)",
  type: "action",
  props: {
    formaloo,
    customerId: {
      propDefinition: [
        formaloo,
        "customerId",
      ],
    },
    fullName: {
      propDefinition: [
        formaloo,
        "fullName",
      ],
      optional: true,
    },
    firstName: {
      propDefinition: [
        formaloo,
        "firstName",
      ],
      optional: true,
    },
    lastName: {
      propDefinition: [
        formaloo,
        "lastName",
      ],
      optional: true,
    },
    username: {
      propDefinition: [
        formaloo,
        "username",
      ],
    },
    email: {
      propDefinition: [
        formaloo,
        "email",
      ],
    },
    phoneNumber: {
      propDefinition: [
        formaloo,
        "phoneNumber",
      ],
    },
    numberOfTags: {
      propDefinition: [
        formaloo,
        "numberOfTags",
      ],
      optional: true,
      reloadProps: true,
    },
    score: {
      propDefinition: [
        formaloo,
        "score",
      ],
      optional: true,
    },
    countrySlug: {
      propDefinition: [
        formaloo,
        "countrySlug",
      ],
      optional: true,
    },
    stateSlug: {
      propDefinition: [
        formaloo,
        "stateSlug",
        ({ countrySlug }) => ({
          countrySlug,
        }),
      ],
      optional: true,
    },
    city: {
      propDefinition: [
        formaloo,
        "city",
        ({ stateSlug }) => ({
          stateSlug,
        }),
      ],
      optional: true,
    },
    language: {
      propDefinition: [
        formaloo,
        "language",
      ],
      optional: true,
    },
    customerData: {
      propDefinition: [
        formaloo,
        "customerData",
      ],
      optional: true,
    },
  },
  async additionalProps() {
    return Array.from({
      length: this.numberOfTags,
    }).reduce((acc, _, index) => {
      const pos = index + 1;

      return {
        ...acc,
        [`tagSlug-${pos}`]: {
          type: "string",
          label: `Tag ${pos}`,
          description: "The tag you want to add.",
          options: async ({ page }) => {
            const { data } = await this.formaloo.listTags({
              params: {
                page: page + 1,
              },
            });
            return data?.tags.map(({
              slug: value, title: label,
            }) => ({
              label,
              value,
            }));
          },
        },
      };
    }, {});
  },
  methods: {
    getTag(index) {
      const pos = index + 1;
      const { [`tagSlug-${pos}`]: slug } = this;
      return {
        slug,
      };
    },
    getTags() {
      return Array.from({
        length: this.numberOfTags,
      }).map((_, index) => this.getTag(index));
    },
  },
  async run({ $ }) {
    const {
      formaloo,
      customerId,
      ...data
    } = this;

    const body = prepareData(data);
    const tags = this.getTags();
    if (tags.length) body.tags = tags;

    const response = await formaloo.updateCustomer({
      $,
      customerId,
      data: body,
    });

    $.export("$summary", `A new customer with Id: ${response?.data?.customer?.slug} was successfully created!`);
    return response;
  },
};

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
Formaloo	`formaloo`	`app`	This component uses the Formaloo app.
Customer Code	`customerId`	`string`	Select a value from the drop down menu.
Full Name	`fullName`	`string`	Customer's full name (in case it's not stored as the first name and last name).
First Name	`firstName`	`string`	Customer's first name.
Last Name	`lastName`	`string`	Customer's last name.
Username	`username`	`string`	Any username or identifier on your system which you use to identify the customer.
Email	`email`	`string`	Customer's primary email address.
Phone Number	`phoneNumber`	`string`	Customer's primary phone number.
Number Of Tags	`numberOfTags`	`integer`	The number of tags you want to add.
Score	`score`	`integer`	If you want the customer have an initial score.
Country	`countrySlug`	`string`	Select a value from the drop down menu.
State	`stateSlug`	`string`	Select a value from the drop down menu.
City	`city`	`string`	Select a value from the drop down menu.
Language	`language`	`string`	Select a value from the drop down menu.
Customer Data	`customerData`	`object`	Any data available on the customer in json format.

Action Authentication#

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

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

About Formaloo#

Formaloo is a powerful no-code collaboration platform that enables you to build custom business applications, internal tools and customer engagement tools fast & code-free!

More Ways to Connect Formaloo + Notion#

Other Popular Integrations#

Create Customer with Formaloo API on New Database from Notion API

Notion + Formaloo

Update Customer with Formaloo API on New Database from Notion API

Pipedream makes it easy to connect APIs for Formaloo, Notion and 2,400+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,400+apps by most popular

1
-
24
of
2,400+
apps by most popular