Store data with Zapier Tables

Zapier Tables is a data storage solution built for automation.

Tables are composed of records (each row in a table) and fields (each column in a table). You can add records manually or automatically, using Zaps. 

Create a new table

You can create a new table at https://tables.zapier.com:

  • Click Create blank table to start creating fields and inserting information. 
  • To import existing data, click Create table from CSV file.

On this page, you can also view existing tables and ones that were shared with you. You can also access Tables from the left sidebar when logged into your Zapier account.

 

Bulk edit table records

When viewing a table, you can do the following bulk actions:

  • Send pending records: sends any records with a “Pending” status to a Zap. If you select specific records,  the button will show the number of pending records to send.
  • Hide fields: select which fields to hide from view. Tables will still send hidden content to Zaps. 
  • Filter: select a field and rule to view only specific records.

You can find more actions by clicking the three dot navMoreHoriz icon icon.

  • Ignore pending records: prevents current pending records from being sent to Zaps. If you select specific records, the button will show the number of pending records to ignore.
  • Download all records: download all records as a CSV file.
    • Download filtered records: this option appears when a filter is active. Download all visible records as a CSV file.
  • Delete records: select specific records to delete them from the table. This action cannot be undone.

 

Add new fields

You can add new fields by clicking the plus sign formAddSquareOutlined icon on the right side of a table.

Zapier Tables offer fields that allow you to format data, or interact with Zaps. Learn more about the different field types on tables.

ratingStar icon Tip

You can also add a field in any position in a table by clicking on the name of an existing field and selecting Insert before or Insert after.

 

After you create a new field, you can also create a Zap to interact with the information on that field. Learn more about triggering and continuing Zaps from Tables.

 

Reorder fields

You can reorder existing fields in a table by dragging and dropping them.

  1. Click and hold the name of the field you want to move.
  2. Drag it to the position you want to move it to. A blue line indicates the position where the field will be dropped.

 

Add new records

You can add new blank rows by clicking the plus sign formAddSquareOutlined iconat the bottom of a table.

 

Sort records

You can sort records by specific fields. If you use sorting, the values on that field will define the order in which records appear in a table. To sort records in a table:

  1. Click the name of the field you want to sort by.
  2. Select Sort ascending or Sort descending.

 

Delete a record or a field

To delete a record:

  1. Click the checkbox to the left of the record you want to delete.
  2. Click the three dot navMoreHoriz icon icon at the top of the table.
  3. Select Delete records. The option will reflect how many records are selected.

To delete a field:

  1. Click the name of the field.
  2. Click Delete field.

 

Delete a table

To delete a table: 

  1. On the Tables page, click the three dot navMoreHoriz icon icon next to the table you want to delete.
  2. Click Delete.
  3. Click Confirm to delete the table. 

You can also delete a table when viewing its contents.

  1. Click Settings navCog icon.
  2. Scroll to the bottom of the Table Settings panel.
  3. On the section Danger zone, click Delete this table.
miscEye icon Note

Deleted tables cannot be recovered.

 

Edit table settings

To edit the table's details, click Settings navCog icon. The right sidebar will open, with the following options:

  • Name: change the table's name.
  • Description: change the table's description.
  • Send records: change how records are sent to Zaps - manually or automatically. 
  • Delete table: delete the entire table and its contents. This action cannot be undone.

Pending records

Once you use a table in a Zap, any new records that you manually add to or update in the table are set to “Pending” by default. This is to ensure records are only sent to Zaps when you are done creating or updating them. You can select one of the following options: 

  • Pending (Default): records created manually will be marked as pending until you send them to your Zaps.
  • Automatically: records created manually will be sent automatically to your Zaps.
miscEye icon Note

If a Zap creates or updates a record in the table, those records will not be set to pending. Records created by a Zap will always automatically trigger any Zaps that use the table. 

Learn more about using Zaps with table records.

 

Share a table

You can create a public sharing link for your tables, to share them with others. If you have a Team or Company account, you can also share your tables directly with others in your Zapier account. 

 

Tables offer four different roles:

Role name

Permissions

Owner

The user who created the table. Edit fields, settings, records, and create Zaps. 

Builder

Edit fields, settings, records, and create Zaps. 

Editor

Create, edit, and delete records.

View only

View and export records.

 

To share a table:

  1. In the top navigation of the table, click Share personGroup icon.
  2. Click Create a link. This creates a public sharing link for that table.
    1. In the dropdown menu, select a permission setting.
    2. Click the Copy actionCopy icon icon to copy it to the clipboard.
  3. If you're on a Team or Company account, you can also search for a user, team, or account by name. 
    1. In the dropdown menu, select a permission setting.
  4. Click Close.
miscEye icon Note

When you share a table with another user, they will not have access to any Zaps that use the table. If you are on a Team or Company plan, you can share the Zap folder with that user. 

 

Connect Zaps to your table

You can connect a table to one or more Zaps. Any field in a table can be used to trigger or continue Zaps. You can also send all new records or all updated records to a Zap.

Learn more about triggering and continuing Zaps from table records.

 

Usage limits

Field-related limits

 

Table fields have specific limits on the amount of data they can store. 

Field type

Limit

Text

255 characters

Long Text

10,000 characters

Decimal

7 decimal digits

 

Learn more about table field types.

 

Plan-related limits

Depending on your plan type, Tables have different limits. 

 

Tables in an account

Plan

Limit

Free

10

Paid

20

 

Records in a table

Plan

Limit

Free

2,000

Paid

5,000

 

Fields in a table

Plan

Limit

Free

25

Paid

25

 

Tables can interact with Zaps in many ways. Find out more about using Zaps with tables.

Was this article helpful?
1 out of 2 found this helpful