Want to automatically save email attachments to your Google Drive? There’s a zap for that. These days it seems like Zapier needs no introduction, but in case you haven’t used it yet: Zapier is a low-code way to automate event flows between tools. Want to use Zapier to do this? It’ll be harder than you think. Pros: Maximum flexibility & control, tailored to your use caseĬons: Requires valuable engineering resources to build and maintain (which these days cost companies up to $150 / hour, plus the opportunity cost of your engineers’ time), not scalable, no customer service when things go wrong or your data schema changes Often things break at the worst times, as any developer knows :) For technical teams, this may distract from product development, especially if the script requires maintenance over time. However, writing these scripts is a technical process that might be too high a boundary for nontechnical teams. Both Airtable and Notion offer APIs through which you can read and write data (although for Airtable you need the Enterprise plan to get access to webhooks and the metadata API, so we recommend using BaseQL instead). If you’re just doing one-way syncs, it may be enough to work with the APIs built into your tools and databases. After all, why pay for something you could do yourself? Incomplete or mismatching data, constant requests to engineers… sound familiar? Below, we talk through 4 different ways to sync between Airtable/Notion and your backend DB.įor some teams, the knee-jerk method is to build an internal script. Instead, your engineers are constantly fielding requests for CSV exports, distracting them from product development. Ops: Your ops team needs to be able to contextualize reasons for missed deadlines, but your SLA data is syncing in MongoDB and your ops team doesn’t know how to edit that data directly.You can consolidate that data in your Postgres database, but it’s still not touching Notion, so your Notion view is incomplete. Customer success: Notion is your customer success HQ, but you have customer data across a ton of sources (Amplitude, Stripe, Zendesk, etc).Sales & marketing: you scrape leads data online and drop them into your MySQL database, but you need your sales team to vet and qualify those leads without learning SQL.The problem is that often a company’s data primarily sits (or should sit) in a backend database, like MySQL or MongoDB - so, how to bridge the gap between the two? The whole point of using Airtable and Notion is to give nontechnical folks the ability to easily work with data. Our team uses Notion for 90% of our workflow. Notion is a flexible, user-friendly web-based tool that can be used for everything from task management, documentation, customer relationship management, and budgeting. Similar to G Sheets but with a more feature-rich environment, Airtable has become the primary data analysis tool for many companies. Among them: Airtable and Notion.Īirtable is a highly functional data tool. An option can be removed, but not updated.Over the last five years, we’ve seen many startups shift most of their workload into a handful of new multipurpose tools. A multi_select database property’s options values.The following database properties cannot be updated via the API: In some cases data will no longer be returned, such as people type → file type. These are compatible and the type can be converted. "1, 2, 3") and a people property value is represented as a comma-separated list of IDs. So when a type is changed both in the Notion and in the API, the data will continue to be available, it is just presented differently.įor example, a multi select property value is represented as a comma-separated list of strings (eg. Notion will convert that rich text based on the types defined in a database's schema. □Īll properties in pages are stored as rich text. To update a relation database property, share the related database with the integration. To add a new row to a database, call Create a page.įor an overview of how to use the API with databases, refer to the working with databases guide. To update a row rather than a column, query the Update page endpoint. Sending a request with a properties body param changes the columns of a database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |