Integrate the Reddit API with the Airtable API

Setup the Reddit API trigger to run a workflow which integrates with the Airtable API. Pipedream's integration platform allows you to integrate Reddit and Airtable remarkably fast. Free for developers.

Popular Ways to Connect Reddit with Airtable#

Create single record with Airtable API on New comments by user from Reddit API

Reddit + Airtable

Try it

Create single record with Airtable API on New comments on a post from Reddit API

Reddit + Airtable

Try it

Create single record with Airtable API on New hot posts on a subreddit from Reddit API

Reddit + Airtable

Try it

Create single record with Airtable API on New links by user from Reddit API

Reddit + Airtable

Try it

Create single record with Airtable API on New Posts on a subreddit from Reddit API

Reddit + Airtable

Try it

Popular Reddit and Airtable Triggers#

New Comments by User from the Reddit API

Emit new event each time a user posts a new comment.

Try it

New comments on a post from the Reddit API

Emit new event each time a new comment is added to a subreddit.

Try it

New hot posts on a subreddit from the Reddit API

Emit new event each time a new hot post is added to the top 10 items in a subreddit.

Try it

New Links by User from the Reddit API

Emit new event each time a user posts a new link.

Try it

New Links on a Subreddit from the Reddit API

Emit new event each time a new link is added to a subreddit

Try it

Popular Reddit and Airtable Actions#

List Comments in a Post with the Reddit API

List comments for a specific post. See the docs here

Try it

Create Single Record with the Airtable API

Adds a record to a table.

Try it

List Subreddits by Query with the Reddit API

List subreddits based on a search criteria. See the docs here

Try it

Create Multiple Records with the Airtable API

Create one or more records in a table by passing an array of objects containing field names and values as key/value pairs.

Try it

List Records with the Airtable API

Retrieve records from a table with automatic pagination. Optionally sort and filter results.

Try it

Overview of Reddit#

You could build a tool that monitors specific subreddits and notifies you
when new posts match certain criteria.
You could build a tool that analyzes the posts and comments in a given
subreddit to generate statistics or visualizations about the topic.
You could build a bot that automatically posts or comments in response to
certain keywords or phrases.
You could build a tool that helps manage your Reddit account by automating
tasks like posting, messaging, or voting.
You could build a tool that extracts data from Reddit posts and comments for
use in other applications.

Connect Reddit#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    reddit: {
      type: "app",
      app: "reddit",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://oauth.reddit.com/api/v1/me`,
      headers: {
        Authorization: `Bearer ${this.reddit.$auth.oauth_access_token}`,
        "User-Agent": `pipedream:v0.0.1 (by /u/pipedream-oauth)`,
      },
    })
  },
})

Overview of Airtable#

Using the Airtable API, you can build applications that can:

Create and manage databases
Add, update, and delete records
Search for records
Sort and filter records
Display records in a variety of ways
Import and export data

Connect Airtable#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    airtable: {
      type: "app",
      app: "airtable",
    },
    baseId: {
      type: "$.airtable.baseId",
      appProp: "airtable",
    },
    tableId: {
      type: "$.airtable.tableId",
      baseIdProp: "baseId",
    },
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.airtable.com/v0/${this.baseId}/${this.tableId}`,
      headers: {
        Authorization: `Bearer ${this.airtable.$auth.api_key}`,
        "accept": `application/json`,
      },
    })
  }
})

Community Posts#

Building a Reddit Workflow with Pipedream

Almost four years ago I blogged about a demo I built using Reddit's API. The demo was a multi-user application that made use of Mongo for persistence and Passport.js for user authentication. You would login, select subreddit's to subscribe to, and then once a day it would email you the new posts from that subreddit. This was built in a "traditional" Node.js style with a server running full time to process requests. I thought it would be fun to build this again (although slightly different) using Pipedream's support for working with the Reddit API. I built two different versions of a simple workflow I'd like to share below.

Updating my Reddit Workflow with Pipedream

Back almost exactly a month ago, I blogged about using Pipedream to build a Reddit email report. The idea was that I wanted a daily email of posts from my subscribed subreddits for the past 24 hours of content. The implementation was a bit complex. I used one workflow to handle "get a days worth of content from subreddit" as a general "API" and another workflow connected to my authentication. It handles getting my subscriptions, hitting the API, and then generating the email. This worked well, but after a while of actually getting the email, I noticed some problems. So I decided to fix that.

Airtable Webhooks with Slack + Pipedream

We love Airtable here at Pipedream. But Airtable lacks one killer feature — webhooks. We took advantage of Airtable’s Slack notifications and built a way to send webhooks to an HTTP endpoint every time a record is created or updated in a base. It takes 10 minutes to setup and it’s free.

Webhooks workaround using Slack

This has been an open item in the Airtable support community for a few years, see "Webhooks for Records 393" and here 39, & here 28, and we are excited to offer a free solution to the community. Here is the high level solution: Based on the transitive property (A=B and B=C, then A=C), Airtable supports Slack Notifications, and Slack supports webhooks, so Airtable supports webhooks! You just have to know how to set it up correctly. With a simple integration via Pipedream into Slack, all Airtable users can now get near real time notifications of all updated fields and values in Airtable.

Overcoming Airtable Scripting Limitations with Pipedream

How I used Pipedream — Created a workflow having an API endpoint to convert Airtable’s Attachment Image URL to Base64 encode image (to push it to another API). Similarly, there could be a million other use-cases.