Zapier

Zapier connects Baserow to all the software you rely on.

With Zapier, you can build custom workflows that can execute actions in response to a trigger. You can easily connect Baserow to 5000+ apps and services, and automate repetitive tasks without writing code.

Here’s how to get started with syncing your Baserow database to other apps you use.

Supported Operations

Triggers:

  • Row Created - Trigger when a new row is created.
  • Row Created or Updated - Trigger when a new row is created or an existing one is updated.
  • Row Updated - Trigger when an existing row is updated.

Actions:

  • Delete Row - Deletes an existing row.
  • Create Row - Creates a new row.
  • Update Row - Updates an existing row.
  • Get Single Row - Finds a single row in a given table.
  • List Rows - Finds a page of rows in a given table.

Connect Baserow to Zapier

Create a Zapier account if you don’t already have one. Search for Baserow in the list of available apps and use your credentials to connect your Baserow account to Zapier.

Create a trigger

Zap is an automated workflow that connects your apps and services together. Zaps help you save time and prevent mistakes by automating some aspects of employee onboarding. Each Zap consists of a trigger and one or more actions. A trigger is what starts the Zap. When you start automating your operations, it’s easy to see how Zaps might free you from manual tasks.

First, set up a trigger containing the data you want to add.

Choose app & trigger event

Create a Zap trigger for when a new event occurs in your Baserow table.

Select Baserow as the app, then select the event you wish to occur from the list of possible Zapier triggers:

enter image description here

Choose Baserow account

If you already have your Baserow account connected to Zapier, select it from the account menu.

If not, click Create a new account and follow the instructions to connect your app to Zapier with an API token. An API token is similar to a password and allows Zapier to authenticate to Baserow to perform specific actions.

To authenticate the Baserow API on Zapier,

  1. Click on the ‘API Tokens’ tab within your Baserow ‘Settings’ page to create a Baserow API token
  2. Click on the ‘Create token +’ button
  3. Input the name and select an existing group
  4. Click on the ‘Create token’ button to create a new API token for the selected group and the authorized user.
  5. Input your Baserow API token in the Baserow API token field on Zapier. Then, click Continue to grant Zapier access to your Baserow database.

enter image description here

For more information about Baserow API token, read our user documentation on connecting Baserow with other software.

Set up trigger

Then select the table you wish to connect to Zapier. Find your Baserow table ID by clicking on the three dots next to the table. It’s the number between brackets:

enter image description here

You can choose a response to test the trigger. Your test form data will look like this:

enter image description here

Choose an action

An action is an event a Zap performs after it’s triggered, like adding a new record to a Baserow database, notifying your team in Slack or sending a follow-up email.

Select Baserow as the action app you wish to use, then select an action:

enter image description here

Connect your account to the action app you wish to connect with. Select it from the account menu if you already have an account linked to Zapier.

If not, click Create a new account and follow the on-screen steps to link your app to Zapier.

Set up action

Next, customize the data that you want to send over to your action app.

You’ll see dropdown menus and/or form fields to fill out in this step. In this example, we will map the form submission data that we want to sync across database tables.

enter image description here

For more information on how to get your row ID, read our user documentation on row identifiers.

Test the action

The last step is to test whether your action works as expected. The first screen displays the data input for your action—the information sent to your action app. Click Test & Continue to start the action step.

The next screen will show you whether Zapier was successful in performing the action step for you.

enter image description here

Finally, click on Publish Zap button. Once you turn on a Zap, Zapier will monitor for that trigger event.

When the Zap runs, it will execute all actions simultaneously. You can always add extra steps to any Zap to complete the onboarding process in a single Zap.

Get started with Baserow workflows on Zapier to save time.

If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community —we’re ready to assist you!