Upgrade Your Outreach LIVE COWORK SESSION

Build a Google Maps Scraper for WhatsApp Outreach in Google Sheets (Apps Script + Places API) Sheet: https://bettersheets.co/tutorials/google-maps-scraper-for-outreach This episode shows a live, unedited build of a Google Sheets + Google Apps Script tool that searches Google Maps via the Places API, pulls location results with phone numbers, and supports WhatsApp outreach. The workflow includes setting up a sheet for an API key and outreach message, enabling the correct Google Maps/Places API and billing, and fixing the “no results” issue by creating the OAuth consent/client configuration in Google Cloud Console. The script adds a custom menu (“Get Places”) to run searches that create a new tab per query, logs results into rows, and generates WhatsApp links that prefill the message. It also tracks outreach by marking selected rows as “outreached,” highlights duplicates across new searches so you don’t contact the same phone number twice, and includes an archive function to hide tabs. The video finishes by cleaning up usability: adjusting column widths, setting wrap strategy, styling headers, adding instructions/links in the setup tab, expanding message options, and adding a character count for the outreach message, so others can make a copy of the sheet and use it. 00:00 Build Scraper Live 01:02 Define Outreach Goals 02:16 Sheet Layout WhatsApp Link 03:47 API Key Setup 08:24 First Run Debugging 16:11 OAuth Fix Success 16:51 Outreach Tracking Duplicates 18:21 Customize Message Workflow 20:54 Format Columns Wrap Header 31:56 Polish Outreach Tab 36:33 Add Setup Instructions 47:34 Make Copy Share Sheet 49:42 Wrap Up Subscribe