Back
Substack New post by user. Airtable Create a new record.

Create an Airtable record when Substack publishes a post

Connect

How this automation works

Create a record in Airtable whenever a Substack post is published. It runs when a Substack user you follow publishes a new post and automatically adds the post's title, link, excerpt, author, and metadata to a new Airtable record. This is ideal for writers, editors, and content managers who want to archive or analyze Substack posts using Airtable.

If
Substack icon
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a Substack user you follow publishes a new post across any of their publications.
PostTitle PostUrl PostDescription PostExcerpt CoverImageUrl AuthorName AuthorPhotoUrl PublicationName PublishedDate WordCount PostType IsPaywalled PodcastUrl VideoUrl
Then
Airtable icon
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new record in a table of your choosing.
base_id table_id_or_name record_content

Services used in this Applet

Create your own Airtable and Substack workflow

Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.

5 triggers, queries, and actions

New note by user

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a Substack user you follow publishes a new note (short-form social post).

New post by user

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a Substack user you follow publishes a new post across any of their publications.

New record created

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.

History of records created

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.

Create a new record

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new record in a table of your choosing.

Create a new record

Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will create a new record in a table of your choosing.

History of records created

Pro plus icon
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.

New note by user

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a Substack user you follow publishes a new note (short-form social post).

New post by user

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a Substack user you follow publishes a new post across any of their publications.

New record created

Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.

Build an automation in seconds!

You can add delays, queries, and more actions in the next step!

More on Airtable and Substack

About Airtable

Airtable is the easy way to create your own organizational databases.

Explore Airtable

More integrations with Airtable

About Substack

Substack is a publishing platform for independent writers, journalists, and creators. Subscribe to your favorite authors and get their newsletters, podcasts, and notes delivered directly to you. Connect Substack to IFTTT to automate your reading workflow, cross-post content, and stay on top of every new publication from writers you follow.

Explore Substack

More integrations with Substack

IFTTT helps all your apps and devices work better together

Get started for free