Yes. Map qmerit_status as a tag and certified_brands as a list mapping so they render as badge rows. Qmerit renders with the official badge file, charger brands render with their respective logos. Both refresh from the sheet on the cache window when statuses or authorizations change.

SleekRank groups the installer sheet by certified_brands and publishes a hub per brand value. Add a URL pattern like /ev-chargers/brand/{slug}/ and the Tesla, ChargePoint, JuiceBox, Wallbox, and Grizzl-E hubs appear automatically with the matching certified installers listed and linked.

Yes. The base template includes a JSON-LD LocalBusiness block. SleekRank fills placeholders from the row data including service area, phone, review count, and price range. Per installer rich snippets render in search results from the same source data without separate plugin configuration.

Yes. Add a project_types column with values like residential, multi_family, commercial. Add a second URL pattern that includes project_type as a path segment. The directory generates a URL per installer per project type, each with its own H1 and copy tuned to the intent.

Update the qmerit_status cell to inactive in the sheet. The page refreshes on the cache window with the badge removed and the installer drops out of any certified filtered hub. Status changes propagate across every related page without a manual sweep.

Yes. Add columns for panel_upgrade and load_management with boolean or capability values. Map each as a tag and render in a service capability block. EV owners with older homes ask whether the installer handles panel upgrades, so surfacing the capability filters the wrong-fit leads.

Yes. The base template supports Gravity Forms and Fluent Forms with hidden fields. The installer slug and service city pass into the form submission, so leads land in your CRM tagged with the source page. Form routing rules assign each lead to the matching installer or regional team.

The cacheDuration in the page group config controls refresh frequency. EV charger directories typically use 21600 seconds for a four-times-daily refresh because OEM referral volume drives certification status changes more frequently than other trades.