This topic was automatically generated from Slack. You can find the original thread here.
Good morning.
Is there an integration for Pipedream using Substack?
I’d like to pull an RSS feed and then push it into Substack.
Good morning! While I don’t see a specific Substack integration, you can achieve your goal by using the RSS app in Pipedream to pull an RSS feed and then use the Substack API to push the content into Substack. First, you can use the “New Item in Feed” trigger from the RSS app to pull the RSS feed. Here’s how to use it: 1. Search for the RSS app from the trigger menu 2. Select the New Item in Feed trigger 3. Connect your RSS account 4. Select a Feed URL or pass a string from a previous step. 5. Follow the instructions on the trigger configuration screen. You may need to generate a test event from RSS to get real data to test your workflow. After that, you’ll need to make an HTTP request to the Substack API to create a new post or update an existing one. You can use the axios from the @pipedream/platform package to make the request. Here’s an example of how you can make a request to the Substack API: import { axios } from "@pipedream/platform"; export default defineComponent({ async run({ steps, $ }) { const substackApiKey = "YOUR_SUBSTACK_API_KEY"; const substackApiUrl = "https://api.substack.com/..."; // Replace with the appropriate Substack API endpoint const response = await axios($, { method: "POST", url: substackApiUrl, headers: { "Authorization": `Bearer ${substackApiKey}`, }, data: { // Add the required data for the Substack API request }, }); return response; }, }); Replace YOUR_SUBSTACK_API_KEY with your actual Substack API key and update the substackApiUrl and data properties as needed based on the Substack API documentation. Please note that you’ll need to consult the Substack API documentation for the specific API endpoints and data requirements, as I don’t have access to that information.
I read that Substack does not have a public API.
You’re correct that Substack does not have a public API at the moment. In that case, pulling an RSS feed and pushing it into Substack directly might not be possible using their API. However, you can still use Pipedream to pull an RSS feed using the “New Item in Feed” trigger from the RSS app, as mentioned earlier. Unfortunately, without a public API for Substack, it’s challenging to automate the process of pushing the content into Substack directly. You might need to manually copy and paste the content from the RSS feed into your Substack posts.