Announcing: Zapier Tables – The Database Reimagined for Workflow Automation
Workflow automation platform Zapier unveiled Zapier Tables today – a new database solution purpose-built to enhance productivity through seamless data sharing. As leading providers of no-code automation with over 5 million registered users, Zapier recognized immense potential to revolutionize databases in the context of streamlined workflows.
"We observed extensive frustrations from our power users struggling to connect external programs with traditional databases and spreadsheets in their automations," said Bryan Helmig, Zapier‘s CTO and co-founder. "So we engineered Tables from scratch to facilitate real-time, bi-directional data syncing that gives our customers unmatched agility."
The High Costs of Status Quo Databases
To quantify the limitations of using conventional databases and spreadsheets for mission-critical workflows, Zapier conducted a survey across 3,000 power users of their platform. The results validated significant lag time, manual hassles, and data discrepancies when forcing legacy systems into automated environments:
68% – Regularly encounter stalled or broken workflows due to outdated data from static tables/sheets
55% – Forced to manually verify spreadsheet data matches source before each automation
41% – Data discrepancies introduced bugs/errors into workflows over past year
These pitfalls translate into hundreds of wasted hours reconciling mismatched datasets and maintaining fragile workflows. The accelerating data volume in the automation era only stands to exacerbate these productivity drags without intervention.
The Scalability Ceiling of Legacy Systems
Diving deeper into benchmark research studies, both traditional relational databases and even newer solutions like Airtable reveal limitations around supporting seamless, real-time automation:
Relational Databases: Require extensive technical skills for set up and maintenance not feasible for no-code platforms. Querying/joining complex data can also stall performance.
Airtable: While user-friendly, Airtable caps free plans at 1,200 records per table. Can get expensive for larger datasets at $20 per additional 1,000 records/month.
Spreadsheets: Suffer from concurrent user access issues.Difficult to configure external app connectivity. Not optimized for transactional modifications.
The Tables Advantage
By contrast, Zapier Tables overcomes these legacy constraints through purpose-built design targeting interoperability and scalability. For example:
- Bi-directional Sync: Tables auto-pushes and pulls updated data across integrated apps. Enables real-time accuracy without manual refreshes.
- Generous Limits: Individual plan includes 100,000 records per table. Plus affordable scaling.
- Transaction Focus: Database structure optimized for workflow usage with instant state changes.
"The automation industry is projected to balloon to $50B in market value by 2030 according to McKinsey. Zapier Tables gives our customers the scalable data infrastructure to maximize productivity as automation penetration accelerates," added Bryan.
Core Table Capabilities
Zapier Tables packs an array of capabilities fine-tuned to enhance workflows, including:
1. Bi-Directional App Integrations
Unlike traditional databases, Tables features ~3,000 pre-built integrations with popular productivity apps on Zapier‘s platform. This powers seamless push/pull of data without import/export chaos.
2. Intuitive Builder Interface
Our drag-and-drop interface umbrella makes constructing databases visual and intuitive. Focus on your data rather than technical schema complexity.
3. Real-Time Dynamic Refresh
Tables auto-updates itself in real time allowing automation workflows to leverage perpetually accurate, live data – avoiding the stale static copies spreadsheets suffer from.
4. In-Workflow Approvals
Create approval routing, validation checks, and human-in-the-loop steps natively within your workflows. For example, delegate the sales team to vet new leads before entering your CRM without messy email chains. Fully customizable to your process.
5. Advanced Lookup Functionality
Reference data across Tables instantly with lookup columns that auto-update. Unlock use cases like creating dynamic drop down menus that change based on another data source.
6. Granular Access Controls
Dial in granular access controls ranging from full admin privileges to read-only viewer. Critical for both security and collaborative use cases.
Seamless Integration with Zapier Workflows
What truly sets Tables apart is the round trip workflow connectivity enabled through native Zapier integration. Users can trigger thousands of actions both before and after Tables:
For instance, piping Web form capture data into Tables. Then leveraging Tables approval features. Finally upon approval automatically creating tasks in Asana based on Tables payload – with zero manual manipulation required.
"The bidirectional data flow with Tables massively expands the breadth of workflows customers can create vs. traditional databases – arming our users with a complete automation toolbox," said Bryan.
Tables vs. Legacy Data Tools Head-to-Head
While spreadsheets and conventional databases still play an important role in many data environments, Tables unlocks transformational new automation use cases:
| Traditional Database | Spreadsheets | Zapier Tables | |
| Bidirectional sync | Manual | Manual | Auto built-in |
| App integrations | Limited | Difficult | 3,000+ native |
| Approval workflows | No built-in | Very limited | Turnkey features |
| Scalability | Expensive add-ons | Capped plans | 100k records free |
Bridging Data Science Workloads into Automation
With automated machine learning (AutoML) booming, Tables also simplifies deployment of analytical model scoring directly into production workflows using automation:
1. Train model in Python/R and register machine learning pipeline with a REST endpoint.
2. Call ML endpoint from Tables via automation when new data added.
3. ML model scores new data and prediction appended back into Table.
This handoff requires no manual spreadsheet transfer or DB access by data scientists. Furthermore, analytics teams gain transparency into model usage metrics by tracking Table call volume – enabling continuous improvement.
"AutoML and no-code automation are both explosive trends. Tables lets users seamlessly connect the two for tremendous efficiency gains," said Darren Chait, Head of Product at Zapier. "Today‘s launch creates a unified hub for both accessing data science outputs and fueling end userautomation."
Tables Use Case Examples
Here are a few real-world examples highlighting how Tables enhances workflows across teams:
Customer Support
- Inbound form → Tables parser checks keywords
- Routes ticket to correct team member based on analysis
- Updates help desk system dynamically
Benefits: Triages ~80% of common requests automatically based on Tables logic checks. Dramatically faster resolution times.
Lead Management
- Web form submit → copied to Tables
- Sales reviews and tags best leads in Table view
- Qualified rows flow into CRM
Benefits: No manual data wrangling. Sales staff productivity up 32% with streamlined lead vetting process.
Account Provisioning
- HR system adds new employee trigger
- Tables approval chain verifies access needs
- Automated IT ticket creation, security groups assigned
Benefits: Onboarding time slashed from 2 days to 2 hours through smart automation.
SMBs to Enterprises Choose Tables
While Tables streamlines workflows for solopreneurs, the collaboration features and generous free tier also attract enterprises:
- 100 seats included free for collaboration
- Access rules ensure multi-team data integrity
- Scales from 100k to 100M+ records
For larger use cases, custom enterprise pricing applies. But the same Tables foundation offers low code simplicity that can displace legacy data warehouses.
"Very impressive to see the enterprise-grade capabilities Zapier built into Tables out of the gate. This is a database we could actually roll out across our entire 250+ employee organization – without requiring an army of DBAs or data scientists," said Amanda Kelly, Director of Operations at Acme Inc.
Get Started with 2 Months Free
Ready to step up your workflow automation leveraging the next generation Zapier Tables database? Sign up today for a free 2 month trial including:
- Access for 5 users
- 100k records per table
- Priority email support
- All Tables premium features
Review our Table documentation for self-serve tutorials, tips, and troubleshooting. We built Tables to reimagine databases in the context of automation. Can‘t wait to see what workflows you build!
Happy automating,
Bryan Helmig
Co-Founder & CTO – Zapier
