Yes. Map igshpa_status as a tag and loop_specialties as a list mapping so they render as badge rows. IGSHPA renders with the official credential icon, loop specialties render with diagrams of each loop type. Both refresh from the sheet on the cache window when credentials change.

SleekRank groups the installer sheet by loop_specialties and publishes a hub per loop pattern. Add a URL pattern like /geothermal/loop-type/{slug}/ and the vertical closed loop, horizontal closed loop, pond loop, and open loop hubs appear automatically with the matching installers listed.

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 columns for itc_qualifying, state_rebate, and utility_program. Map each as a tag and render in an incentive block. Geothermal shoppers calculate ROI based on the 30 percent ITC stacking with state and utility programs, so surfacing eligibility filters the wrong-fit leads.

Update the igshpa_status cell to expired in the sheet. The page refreshes on the cache window with the expired credential removed and the installer drops out of any IGSHPA filtered hub. The badge disappears automatically without a sweep across every related page.

Yes. Add columns for in_house_drilling, drilling_partner, and well_depth_max. Map each as a tag and render in a capability block. Vertical loop installations require well drilling, and homeowners ask whether the installer drills in-house or partners with a drilling company. Surfacing the answer reduces qualification calls.

Yes. The base template supports Gravity Forms and Fluent Forms with hidden fields. The installer slug and service state 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. Geothermal directories typically use 43200 seconds for a twice-daily refresh, which is fast enough for new accreditations, brand authorizations, and incentive updates without hitting the data source on every page load.