Problem
As part of my routine, I used to publish blog articles on our website & then manually update ClickUp tasks to reflect which ones went live. Let’s just say… a productivity killer for something that should be a no-brainer to automate.
Solution
Automating the whole flow.
I built a Google Apps Script that:
-
Reads the blog’s RSS feed.
-
Checks whether a blog is new or already logged in Google Sheets.
-
If it’s new, logs it in the sheet and auto-creates a task in ClickUp with all the details – assigned to me and marked “Live”.
Implementation
1. RSS Feed Monitoring: I fetched the blog’s RSS feed using Apps Script and parsed it to extract title, link, and description.
2. Sheet Check: Before adding anything new, the script checks if the link already exists in my Google Sheet to avoid duplicates.
3. ClickUp Integration: For every new blog post:
-
A task is created in ClickUp.
-
It’s auto-assigned to me (
Akshat Jain), with the status set to “Live” and due date as current time.
4. Automation Trigger: I set a time-based trigger to run this script every day so it stays in sync with blog publishing without my involvement.
Get in touch with me if you’d like to have the full code of the automation.
Results
-
100% automated blog-to-ClickUp pipeline.
-
No missed blog updates. Every post now gets auto-logged and tracked in real-time.
-
Saved 1–2 hour weekly that were earlier wasted on repetitive task updates.