#Airtable zapier digest how to
#Airtable zapier digest update

Airtable Sync integration: API sync - An alternative way of bringing CSV data into Airtable.Airtable Sync FAQs - Answers to common questions that might help unblock you if you are encountering issues.Sync - Basic setup - If you haven’t set up a sync before, we recommend first reading this article to become familiarized with how the Airtable Sync feature generally works.

#Airtable zapier digest update

Owners/ Creators - In order to create or update synced tables, you'll need to have creator permissions in the base where you are setting up the sync. This external source sync feature allows you to leverage that functionality to sync external data from a system without a specific native Airtable integration into an Airtable base.īusiness and Enterprise Scale access only xlsx file attachment via email on a regular basis. Many external systems have features that can send a CSV or.

#Airtable zapier digest how to

Here's how to use Zapier to automatically generate a daily digest of what's changed in Airtable.Learn how to use the Airtable Sync integration feature to bring information from external applications into a single, centralized table within Airtable. Whether you're working with a team on a large-scale project, or tracking changes across hundreds of records every day, you may want a quick way to see what's most recently been updated. With Airtable's last modified time field and an integration built with third-party tool Zapier, you can create a custom email digest to put those updates directly in your inbox. Build the foundation of your daily digestĪirtable’s last modified time field will automatically mark the date (and time) of the most recent change to a record.

You can even tell it to only update when certain fields have changed. This can come in handy in Airtable, all by itself, to help you sort and group records based on most recent activity. You can also build on top of it to create other useful tools, like the daily digest we’re learning to make right now. Because the last modified time field updates automatically, we can use some simple logic to create a view that tracks daily updates. Later, we’ll provide Zapier with that view in order to create a daily digest that will round up every update and send them to you in one, concise summary that you design.įirst things first, create a new field and choose Last modified time as its type. If you pick something else, just make sure to update the formula accordingly once we get to it.) (You can choose another name, but you might want to stick with it for now because we’ll use it in a formula later. If you changed the names of any of the fields we’ve created you’ll need to alter this formula accordingly. If not, it should work without any changes. The formula does nothing other than check if the Zapped field has anything in it and, if it does, see if the Zapped and Last update field contain the same date and time. If it does, the formula will return a yes. If it does not, or if the Zapped field is empty, the formula will return a no. This comparison tells us if Zapier processed the latest update to a given record.