📊 Email weekly Google Maps ranking heatmaps with GeoGridAPI and Gmail
⚡ 0 views · 📊 Market Research & Insights
💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.
Description
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.
🔗 Nodes Used
HTTP Request, Gmail, Stop and Error, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File