A Zero-Plugin WordPress Lead Pipeline to Google Sheets
Aanand Madhav - Writing
A zero-plugin WordPress lead collection setup using an embedded HTML form, Google Apps Script, Google Sheets, and confirmation email.
google sheets
🏡 Spreadsheets, Photos, and the Art of Moving Out
Amedee
When you move out of a cohousing, you don’t just pack your boxes — you pack your shared life.And in our case, that meant making an inventory of everything that lived in the house at Van Ooteghem:Who takes what, what gets sold, and what’s destined for the containerpark. To keep things organised...
make your own personal CRM (for free in 20 minutes)
Alec Barrett-Wilsdon
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 …
mastering Google AppScript
Alec Barrett-Wilsdon
tl;dr: write Javascript in Google Sheets to build advanced automations cost: $0 build time: 10 minutes (MVP) updated: 2021-06-23 table of contents: #1 - getting started #2 - reading GSheet tabs #3 - writing GSheet tabs #4 - API requests #5 - end user UX #6 - gotchas #7 - snippets #8 - auth for...
set up Google Sheets APIs (and treat Sheets like a database)
Alec Barrett-Wilsdon
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 …