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 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 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.
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.
- Click and hold the name of the field you want to move.
- 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 at 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:
- Click the name of the field you want to sort by.
- Select Sort ascending or Sort descending.
Delete a record or a field
To delete a record:
- Click the checkbox to the left of the record you want to delete.
- Click the three dot
icon at the top of the table.
- Select Delete records. The option will reflect how many records are selected.
To delete a field:
- Click the name of the field.
- Click Delete field.
Delete a table
To delete a table:
- On the Tables page, click the three dot
icon next to the table you want to delete.
- Click Delete.
- Click Confirm to delete the table.
You can also delete a table when viewing its contents.
- Click Settings
.
- Scroll to the bottom of the Table Settings panel.
- On the section Danger zone, click Delete this table.
Deleted tables cannot be recovered.
Edit table settings
To edit the table's details, click Settings . 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.
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:
- In the top navigation of the table, click Share
.
- Click Create a link. This creates a public sharing link for that table.
- In the dropdown menu, select a permission setting.
- Click the Copy
icon to copy it to the clipboard.
- If you're on a Team or Company account, you can also search for a user, team, or account by name.
- In the dropdown menu, select a permission setting.
- Click Close.
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.