Create an Airtable record when Substack publishes a post
1 ready-made Airtable and Substack Applets
Turn one on, or build your own. Substack can start an automation with "New note by user", and IFTTT can then run "Create a new record" on Airtable.
Automate Airtable and Substack from your AI assistant
Have Claude, ChatGPT, or Cursor build and run Airtable and Substack automations for you, like “Create an Airtable record when Substack publishes a post”, with IFTTT MCP.
Set up IFTTT MCP
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
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
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!
If
Select a trigger the automation will use
New note by user
New post by user
New record created
Then
Select an action the automation will perform
Create a new record
You can add delays, queries, and more actions in the chat.
GET STARTED
How to connect to a Airtable automation
Find an Applet using Airtable and Substack
Find an automation to connect to, or create your own!Connect IFTTT to your accounts
Securely connect the Applet services to your respective accounts.Finalize and customize your Applet
Review trigger and action settings, and click connect. Simple as that!Upgrade your automations with
-
Connect to more Applets
Connect up to 20 automations with Pro, and unlimited automations with Pro+ -
Add multiple actions with exclusive services
Add real-time data and multiple actions for smarter automations -
Get access to faster speeds
Get faster updates and more actions with higher rate limits and quicker checks
Airtable and Substack tips, tools, and resources
-
Popular
How an IFTTTer is automating their project management
-
Business
Connect Google Calendar to your iPhone (and more) with IFTTT
-
Business
Project management automations for solopreneurs
-
Social media
Where to find your next 30 content ideas (and how to never lose one again, with IFTTT)
-
Social media
How to automate Discord moderation for spam, raids, and rule-breakers without watching 24/7
-
Productivity
Best task management automation tools (2026)
More on Airtable and Substack
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.