See llms.txt for all machine-readable content.

Back to Templates

Generate site feasibility and risk reports with Google Gemini and Slack

Created by

Created by: iamvaar || iamvaar
iamvaar

Last update

Last update 2 days ago

Categories

Share

Quick overview

Youtube Video: https://youtu.be/Ry6lMULSsF4

This workflow collects a site location via an n8n form, checks whether the coordinates are on land, pulls elevation, protected-species occurrences, and US Census demographics, then uses Google Gemini to generate a structured feasibility and risk report and posts it to Slack.

How it works

  1. Receives a site submission (name, latitude, longitude, radius) from an n8n Form trigger.
  2. Checks the coordinates with isitwater.com and posts a rejection message to Slack if the location is water.
  3. If the location is land, retrieves elevation from Open Topo Data and searches GBIF for nearby occurrences of IUCN-listed threatened species within the specified radius.
  4. Geocodes the point to a US Census block group and fetches ACS 5-year estimates (median household income and population) from the US Census API.
  5. Aggregates the site, elevation, species, and census data into a single structured record, including simple flags like low-elevation flood risk and protected species counts.
  6. Sends the structured data to Google Gemini (via an n8n LangChain chain) to produce a JSON-formatted risk score, verdict, summaries, and recommendation.
  7. Formats the AI output into a Slack-friendly report and posts it to the configured Slack channel.

Setup

  1. Add credentials for isitwater.com (HTTP Bearer token), Google Gemini/PaLM API, and Slack.
  2. Update the Slack channel selection in both Slack posting steps to your target channel (and ensure the channel exists).
  3. (Optional) Add a US Census API key to the Census ACS request, or remove the empty key parameter if you do not use a key.