#2 — IFTTT and Google Sheets: Create a List of my Medium Blog Posts
When I post (in Medium), have the post added to a new row in a Google Sheet
The Challenge?
I blog on Medium (duh, that’s where you are seeing this!) and I want to always have a current list of my blog posts (with little effort by me).
It’s a very handy reference resource for reviewing, searching and linking back to what I have published!
The Goal
So, here is my outline of expected ongoing effort on my part:
- Publish a blog post,
- Create a new item in my “Medium Blog Posts” Google Sheet (automated)
- Add categories, to facilitate filtering later, in Google Sheets,
- Open Excel, click the “refresh” button, and
- Have all my content current, accessible, and analyzable, within Excel!
The Process
Here is the workflow:
IFTTT — Applet ID 40866285d
“Medium Posts to Google Drive Spreadsheet #Google #Medium”
Automation End Result
I automated the back-end of this process as well. A Microsoft Excel file I created imports the Google Sheet list of blog posts into Excel and enables me to share lists, categories or other selected content with others — all linked back to the Medium posts.
I discussed the Excel Resource Dashboard (shown above) in an earlier post here (“Microsoft Excel — Automated Content Resource Dashboard”)
About Don
“It’s time for different”
Don is passionate about helping professionals and organizations keep up and adapt to the changing business world that we operate in.
“What Do You Do?”
I frequently get this question. My response (it’s not what you think!)? Check it out here!
