Airtable + Letterdrop

Create Airtable records when a new posts is are published in Letterdrop

For some of us super organized people, we would like to have a record of all your newsletters and blog posts in your Airtable CRM so we can take down notes on how we shared it and what we learned from publishing it. This Zap has you covered so you have comprehensive notes on your growth experiments.

When this happens...
New Blog Post Published
Triggers when a new blog post is published.
TriggerInstant
automatically do this!
Create Record
Creates a new record with auto-populating fields.
ActionWrite

Try this template

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

Email Added
Triggers when a new email is added to your list.
Trigger
Instant
Try It
New Blog Post Published
Triggers when a new blog post is published.
Trigger
Instant
Try It
Subscriber Updated
Triggers when a subscriber is updated.
Trigger
Instant
Try It
- TitleRequired
- Subtitle
- HTML BodyRequired
  Provide the body of your post in HTML format.
Action
Write
- BaseRequired
- TableRequired
- Limit to View
  (Optional) Limit to records added to a specific View, and return records in the View order.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Trigger
Scheduled
Try It

- BaseRequired
  Base in which to create the record.
- TableRequired
Action
Write
- BaseRequired
  Pick the Airtable base containing the records you wish to update.
- TableRequired
  Pick the Airtable table containing the records you wish to update.
- RecordRequired
  Pick the Airtable record that you wish to update.
Action
Write

- BaseRequired
  Base to search for a record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  Limit the search to a specific view. Useful for sorting results.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Action
Search
- BaseRequired
  Base in which to create the record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  Limit the search to a specific view. Useful for sorting results.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Action
Search or write

Email Removed
Triggers when an email is removed from your list.
Trigger
Instant
Try It
Project Updated
Triggers when a project is updated.
Trigger
Instant
Try It
- EmailRequired
  Email of subscriber to add
- TypeRequired
  Free or paid subscriber
- Welcome Email
  Whether or not you want to send a welcome email once this subscriber is added.
- Additional Data
  Add additional fields to store for this subscriber. Exmaple: Enter "name" in the left column and "John" in the right column. See our API docs for a full list of accepted fields.
Action
Write
- EmailRequired
  Email of subscriber to remove
Action
Write
- BaseRequired
- TableRequired
- Help Text
  You must have at least one "Last Modified Time" type column in your Table in order to use this Trigger. Learn more about those here.
- Which timestamp field should this Zap use to check for updates?Required
  When this column changes to a new timestamp, your Zap will trigger on the corresponding record. Note: Must be a Last Modified Time column type.
- Limit to View
  Filter on updates to a specific View in your Table.
- Include file contents?
  Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Trigger
Scheduled
Try It
- BaseRequired
  Base in which to create the record.
- TableRequired
Action
Write
- Api Docs Info
  API docs for Airtable are located here https://airtable.com/api
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- BaseRequired
  Base to search for a record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  You can optionally limit the search to a specific view id.
Action
Search
- BaseRequired
  Base in which to create the record.
- TableRequired
  Pick an Airtable table that you want to search.
- Search by Field
  Pick a field from the base to match against the search value.
- Search Value
  The value of unique identifier for the record.
- Search Formula
  (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
- Limit to View
  You can optionally limit the search to a specific view id.
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more

Related categories

Databases

Similar apps

Quick Base

Databases

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Letterdrop

Content marketing automation for SEO, social media, and email newsletters.

Related categories

Marketing Automation

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Airtable + Letterdrop

Create Airtable records when a new posts is are published in Letterdrop

Email Added

New Blog Post Published

Subscriber Updated

Draft Blog Post

TitleRequired

Subtitle

HTML BodyRequired

New Record

BaseRequired

TableRequired

Limit to View

Include file contents?

Create Record

BaseRequired

TableRequired

Update Record

BaseRequired

TableRequired

RecordRequired

Find Many Records (With Line Item Support)

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

Include file contents?

Find or Create Record(s) (With Line Item Support)

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

Include file contents?

Email Removed

Project Updated

Add Subscriber

EmailRequired

TypeRequired

Welcome Email

Additional Data

Remove Subscriber

EmailRequired

New or Updated Record

BaseRequired

TableRequired

Help Text

Which timestamp field should this Zap use to check for updates?Required

Limit to View

Include file contents?

Create Records (With Line Item Support)

BaseRequired

TableRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Record

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

Find or Create Record

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

About Airtable

Related categories