Quick Overview
This workflow runs every Monday and uses GeoGridAPI to generate a Google Maps local ranking geo-grid for a business and keyword, then downloads the heatmap PNG and emails a metrics summary and the image attachment via Gmail.
How it works
- Runs every Monday at 08:00 on a schedule trigger.
- Sends the configured business query, keyword, grid size, radius, and language to the GeoGridAPI REST API to start a geo-grid run.
- Polls GeoGridAPI every 20 seconds (up to 20 checks) until the grid finishes or fails.
- Stops with an error if the grid is not completed (failed or still running after the maximum checks).
- Downloads the completed heatmap image (PNG) from GeoGridAPI.
- Builds an HTML email with key figures (average rank, top 3 and top 20 coverage, week-over-week change when available, and top competitors ahead) and attaches the PNG.
- Sends the email report to the configured recipient using Gmail.
Setup
- Create a GeoGridAPI account and generate an API key.
- Add an n8n HTTP Header Auth credential for GeoGridAPI (Authorization: Bearer <your_key>) and select it for the GeoGridAPI HTTP requests.
- Connect a Gmail OAuth2 credential for sending email.
- Update the Settings values for business, keyword, grid size, radius (km), language, and the recipient email address.