Overview

This system is made up of three distinct parts:


Google Sheets Query System

Purpose

This system automates the generation and rotation of search queries used to feed the ‘yoga_teacher_discovery’ Make scenario.

The Query Pool is fully dynamic — locations and query templates can be added at any time, and each can be toggled on or off to control what's included in the active rotation.

The system ensures:

Primary asset: Google Sheet yoga_teacher_discovery_system


Google Sheets Structure

Sheet: yoga_teacher_discovery_system

Tab: Locations

Locations are added manually. Each row has an Active checkbox — when checked, that location is included in the Query Pool and is combined with all active query templates.

image.png


Tab: Query Templates

Query templates define the search patterns. Each row has an Active checkbox — when checked, that template is paired with all active locations to generate the Query Pool.

Every template must include the [LOCATION] placeholder exactly as written. This gets swapped out for each location at runtime.

image.png