I thought Iâ€™d share a little bit about how Iâ€™m using integromat, as it contains a gotcha that I need to remember for the future, and a solution to that problem.
Iâ€™m setting up a little newsletter called Ten Things I Found, in which Iâ€™ll share (wait for itâ€¦) 10 things I found on my journey as an indiehacker. Itâ€™ll include tools, advice, strategies, humourous tweets â€“ anything that caught my eye really.
And Iâ€™ll share them in case anyone is interested. It wonâ€™t be a scheduled email â€“ Iâ€™ll just send it when Iâ€™ve got 10 things worth sharing.
To help create the content, this is my flow:
And it works as follows:
- I bookmark anything of interest in raindrop.io. I started using this recently as a way of adding tags to my bookmarks, as I sometimes couldnâ€™t find things in Chromeâ€™s hierarchical structure. (I love Raindrop by the way â€“ so much so that I upgraded with a small annual fee for some additional functions).
- Integromat sweeps Raindrop on a scheduled basis, and adds the bookmark details to a Google Sheet, one bookmark per row, in a tab called â€œBookmarksâ€. (10/10 for originality, Andy). It stores the title, description, URL, and another column called â€œIssue Numberâ€, which is set to 0.
- That 0 means I havenâ€™t sent out the resource in a newsletter yet.
- The sheet includes a specific cell on another sheet, which shows the total number of bookmarks which have an issue number of 0, then it sends me an email with that number. Once it gets to 10, Iâ€™ll look to see if those 10 are suitable for the newsletter (I donâ€™t share all bookmarks, as some are just for my own interests).
- Then it loops through the bookmarks it just added, and populates rows in another sheet (called â€œTagsâ€) with each tag linked to each bookmark, referring back to the row in the Bookmarks sheet where the bookmark was added. Iâ€™m not using the tags in the newsletter currently, but theyâ€™re there for future reference.
Ah yes, that â€œgotchaâ€.
Point 4 above refers to a cell which contains the total number of bookmarks not yet assigned to an issue. The reason for this is that originally I had Integromat do a search directly in the Google Sheet for the rows that had 0 for the Issue Number, then send the email.
At the time I wrote this, I had 118 bookmarks unassigned.
And I got about 30 mails before I realised what was going on and stopped the process.
Iâ€™m sure Integromat didnâ€™t want their IP address blacklisted for spamming, so I put the solution above in place ðŸ™‚
Also â€“ itâ€™s more elegant: let Sheets do the thing itâ€™s good at (calculating stuff), and let Integromat do the thing itâ€™s good at (reading the output of that calculation).
And thatâ€™s it. Youâ€™ll notice the newsletter isnâ€™t sent at this point, but thatâ€™s for another post.
Of course, if youâ€™re interested in the newsletter itself, feel free to sign up. Iâ€™m sure youâ€™ll get something useful from it on a regular basis.