build business tools with GPT3
tl;dr: Use GPT-3 to automate data collection, enrichment, and standardization
cost: $0 to start; up to $400/mo at scale
time: 30 minutes
table of contents:
background
The company OpenAI …
Post tagged: how-to
understanding Google auths
tl;dr: I explain several ways to create and use Google API Console auth
read time: 10m (skim), closer to an hour to implement and test
cost: free
The Google API Console is home to a baffling array of 305 APIs (at time of writing), including Google Docs, Sheets, Drive …
scraping tweets for fun and profit
tl;dr: find spontaenous interactions by scraping tweets with given keywords
cost: $0
build time: 5 minutes (MVP)
Twitter can be a great way to connect with alike minds. But if you're here, you're (probably) not yet a Thought Leader™. Let's walk through a quick way to speed that up …
make your own personal CRM (for free in 20 minutes)
tl;dr: don't miss important personal moments with your own personal CRM
cost: $0
build time: 20 minutes (MVP)
Update August 2020: the trick that enabled easy data import has been disabled. you can still use this build, but it will be more manual to set up
Hey friends,
if …
how to make Alfred Workflows (& the ones I use)
tl;dr: create automations and workflows in Alfred
cost: $0 after one-time $31 cost
build time: 2 minutes (download existing) / 20-60 minutes (build your own)
you may remember me raving about Alfred in my SaaS stack article. (If not, it's a cool software that has a bunch of neat features …
set up Google Tag Manager (and track anything in Google Analytics)
tl;dr: Manage your website events and pixels easily in one place
cost: $0
time: 15 minutes
Google Tag Manager is the most approachable¹, most scalable², and most commonly used 'event' management system for a budding website/webapp. It is free and can be easily³ shared with non-technical collaborators once …
dorking (how to find anything on the Internet)
tl;dr: Use advanced Google Search to find any webpage, emails, info, or secrets
cost: $0
time: 2 minutes
Software engineers have long joked about how much of their job is simply Googling things
Now you can do the same, but for free
Below, I'll cover dorking, the use of …
mastering Colab
tl;dr: How to use and productionize Google Colab, a free Jupyter Notebook service
cost: $0
build time: 15 minutes (MVP)
Google Colaboratory (or just Colab) is a recently popular cloud-ish implementation of Jupyter Notebooks.
In addition to Jupyter features you're familiar with - cell based execution, shared state across cells …
set up a microservice in 5 minutes with Serverless
tl;dr: write serverless infrastructure as code
cost: $0
build time: 5 minutes (MVP)
overview
Serverless, confusingly, means two things.
There's serverless the concept - your infra provider dynamically spins up compute at invocation time and (spins it down after). This means no more worrying about managing (or scaling) compute - it's …
mastering Google AppScript
tl;dr: write Javascript in Google Sheets to build advanced automations
cost: $0
build time: 10 minutes (MVP)
Google AppScript is a custom Javascript 'platform' that allows you to write custom scripts for Google Sheets, Docs, Slides, Forms, and Gmail. It is particularly useful for enabling technical functionality like API …
set up Google Ads APIs
tl;dr: create all Google Ads auth components so you can automate Google & Youtube Ads
cost: $0 (you don't necessarily need to run any ads, either)
build time: 60 minutes
before getting into it, one (or two) disclaimer(s):
There are two Google ad-related API suites: the old Adwords API …
set up email sending (anywhere)
tl;dr: How to set up AWS Simple Email Service, through which you can send emails via many invocation methods
cost: $0 per first 62k emails/mo
build time: 60 minutes (MVP) + 2 days wait to get out of sandbox
Every SaaS product at scale leans heavily on email for …
set up this blog
tl;dr: How to make a static website, built on Pelican, Netlify hosting, Netlify CMS, and Github.
cost: $0/mo (<$1/mo w/ domain)
build time: 45 minutes (MVP) / 2.5 hours (with CMS + custom domain name)
why static (vs dynamic) sites
With a personal site, less is really more …
how to scrape
tl;dr: Using Python requests and BeautifulSoup libraries to scrape data from most data sources
cost: $0
build time: 30 minutes (MVP) / 120 minutes (cleaner v2)
BeautifulSoup allows you to navigate through the raw HTML pulled down from a website (in JS, this is called 'Walking the DOM'). Generally, you …
set up Reddit API
tl;dr: set up the Reddit API and use it to generate interest data
cost: $0
setup time: 5 minutes
Reddit can be a great place to waste an hour or to explore particular new hobbies. It also can be a valuable source of free information on one's customers. In …
set up Google Sheets APIs (and treat Sheets like a database)
tl;dr: set up programmatic reads and writes from any Google Sheet you have access to
cost: $0
build time: 15 minutes (MVP)
Let's start with a hot take to get the blood boiling.
Google Sheets is (probably) the most important database your company uses.
Why?
Every single employee can …
set up Twilio SMS to Email
tl;dr: set up a pass-through phone number that forwards to anywhere
cost: $0.0075 per inbound SMS
build time: 15 minutes (MVP)
overview
Think of all the times you've had to submit a phone number to get a promotional code, or an ebook download, or the love of your …