How to create and manage tables in Zapier

Tables in Zapier help you organize, store, and use structured data across your automated workflows. This guide explains how to create tables, add fields and records, and manage views so you can use table data effectively in your Zaps.

Follow the step-by-step instructions below to build tables that fit your processes, from tracking leads to managing tasks or logging automation results.

Access Zapier tables from your account

You can work with tables directly within your Zapier account. Tables live alongside your other automation tools and can be reused in many Zaps.

Sign in to your Zapier account.
Open the main navigation or dashboard area.
Go to the Tables section (sometimes labeled as data or tables depending on your view).

Once you are in the tables area, you can see a list of existing tables or start with a new one.

Create a new table in Zapier

Creating a table in Zapier gives you a dedicated place to store structured records, similar to a simple database or spreadsheet.

In the Tables section, select the option to create a new table.
Enter a table name that clearly describes the data, such as Leads, Support Tickets, or Subscriptions.
Confirm to create the table so you can begin adding fields and records.

After the table is created, you start with a basic layout that you can customize for your workflow.

Set up Zapier table fields

Fields define the type of information you store in each record. Thoughtful field design makes it easier to filter, search, and connect data to your Zaps.

Choose field types in Zapier tables

Each column in a Zapier table is a field with a specific type. Common field types include:

Text: For names, notes, and general descriptions.
Number: For quantities, prices, or scores.
Date / time: For deadlines, creation dates, or event times.
Email: For contact addresses used in other Zapier steps.
URL: For links to external resources.
Checkbox or boolean: For yes/no values.

Choose the type that best matches the data you plan to store so your table remains consistent and easy to use in your automations.

Add and edit fields in a Zapier table

Open the table where you want to add fields.
Click the header area to add a new field or column.
Enter a field name and choose the field type.
Save the new field to add it to every record in the table.

To edit an existing field, open the field settings from the header, then adjust the name or type as supported. Some changes may be limited depending on whether the field is already used in active Zaps.

Work with records in Zapier tables

Records are individual rows in your table. Each record combines all fields into a single item, such as a contact, ticket, or task.

Manually add records in Zapier

Open your chosen table.
Scroll to the bottom or use the add record button.
Enter values in each field, such as name, email, and status.
Save the record so it appears as a new row in the table.

Manual entry is useful for small data sets, corrections, or one-off updates that do not require a Zap.

Update and delete records in Zapier

To keep your table accurate, you can edit or remove records as your data changes.

Edit a record: Click into a cell, change the value, and confirm to save.
Delete a record: Use the record options menu and choose delete to remove the row.

Be careful when deleting records that might be referenced in existing Zaps, because those workflows may return errors if needed data is missing.

Use views to organize Zapier tables

Views let you focus on specific records or sort data in helpful ways without changing the underlying table.

Create filtered views in Zapier

A filtered view shows only records that match certain criteria, such as open tickets or active subscriptions.

Open your table and locate the views panel.
Create a new view and give it a descriptive name.
Add filters, for example: status is Open or date is after a specific day.
Save the view so you can revisit it at any time.

Filtered views help you design Zaps that only act on the right subset of your data.

Sort and layout options in Zapier views

Within a view, you can change how data is displayed:

Sort records by date, name, or any other field.
Hide or show specific columns so you only see relevant information.
Reorder columns to place important fields at the front.

These adjustments affect only the current view and do not change the data stored in the table.

Connect Zapier tables to your workflows

Once your tables are set up, you can use them in Zaps to create powerful automations that read and write data as part of your processes.

Common Zapier table use cases

Here are a few ways tables can support your automations:

Store leads collected from forms and route them to email or CRM tools.
Log support requests and sync them with help desk apps.
Track orders or subscriptions and trigger follow-up actions based on status.
Maintain a shared reference list, such as product catalogs or discount codes.

Because tables live in Zapier, they can connect to many different apps in your account without extra integrations.

Use table data in Zapier Zaps

In your Zaps, you can use actions or steps that interact with tables, such as finding, creating, or updating records. While the exact steps can vary based on the current interface, the overall pattern is similar:

Choose the table you want to use in the Zap step.
Map fields from previous steps into the table fields.
Test the step to confirm that data is written or retrieved as expected.

After testing, turn the Zap on so your table automatically reflects activity from connected apps.

Best practices for managing Zapier tables

To keep your tables reliable and easy to maintain, follow these guidelines:

Use clear, consistent names for tables and fields.
Avoid unnecessary fields that make records harder to manage.
Standardize formats for dates, numbers, and status values.
Review old records periodically and archive or remove what you no longer need.
Document which Zaps depend on a table before changing field structures.

Good structure from the beginning will reduce issues later when you scale your automations.

Learn more about Zapier tables

For detailed, official instructions and the latest interface updates, review the Zapier help section on creating tables at this Zapier tables guide. It provides specific screenshots, feature notes, and additional configuration options that may change over time.

If you are planning a more advanced automation strategy around tables and other tools, you can also explore optimization resources such as Consultevo for broader workflow design, documentation, and implementation support.

By combining well-designed tables with your Zaps, you can centralize important data, reduce manual entry, and keep every part of your automation system in sync.

Need Help With Zapier?

Work with ConsultEvo — a

Zapier Certified Solution Partner

helping teams build reliable, scalable automations that actually move the business forward.

Get Zapier Help

Zapier tables how-to guide