~/talk

Spreadsheet Isn't Shit. Make the Most of Your Google Sheets

TalkinSpanishat WordCamp Madrid 2023 · 2023-11-04..11-05· [developer-experience, web-platform]
links:none on file
slides:none on file

Practical workshop showing how to use Google Sheets and Excel features to manage a WordPress site: track and control site URLs, validate meta tags (title and description), and perform quick audits via spreadsheets. Demonstrates generating UTM codes, creating QR (bidi) codes, using a Google Sheets extension to connect Google Search Console, and leveraging the ChatGPT API from spreadsheets.

AI-written summary · about

  1. 0:00Introduction
  2. 1:13UTM parameters
  3. 4:24UTM codes in Sheets
  4. 15:08VID codes for images
  5. 18:42URLs from WordPress
  6. 22:39Screaming Frog for SEO
  7. 26:28Duplicate URLs
  8. 30:43Meta tag lengths
  9. 33:13Search intent
  10. 42:23SEO basics in Sheets
  11. 49:03ChatGPT with Sheets
  12. 50:30Q&A
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.