Data & Analytics Workflow Templates
These free data automation templates enrich spreadsheets, sync records between systems, and answer questions over your databases. They run on Heym, an source-available and self-hosted platform, so data teams can build ETL-style pipelines and reporting without per-row billing.
- Google Sheets enrichment
- BigQuery sync
- field mapping
- analytics Q&A
What you can automate with Data & Analytics templates
Spreadsheet enrichment
Read new Google Sheets rows, classify or enrich them with an LLM, and write the results back automatically.
Database Q&A
Answer Slack questions by letting an agent query Postgres through MCP and posting the answer back.
Warehouse sync
Read qualified rows from a source, stream them into BigQuery, and log the sync outcome in a DataTable.
Field remapping
Map incoming text into named fields with the Set node before handing off to webhooks or databases.
API prototyping
Load sample records to test mapping and transformation nodes before wiring up production data.
Popular Data & Analytics templates
Google Sheets AI Enricher
Read new rows from Google Sheets, classify or enrich them with an LLM, and write the results back automatically.
Slack + Postgres MCP Answer Agent
Answer Slack channel questions by letting an Agent query Postgres through MCP, then post the answer back to Slack.
Grist to BigQuery Sync Log
Read qualified rows from Grist, stream them into BigQuery, and log the sync outcome in a Heym DataTable.
Set — Field Remap
Map incoming text into named fields with the Set node before handing off to webhooks or databases.
JSONPlaceholder User Profile
Load a sample user record from JSONPlaceholder — handy for prototyping Set/Mapper nodes and mock APIs.
Browse all Data & Analytics templates
Pick a workflow, copy the JSON, and adapt the nodes for your team.
Why teams run Data & Analytics workflows on Heym
Heym is a source-available, self-hosted AI workflow platform for agentic automation: agents that call tools, retrieve from your own documents, and pause for human review when a step needs it.
Free and source-available
Released under MIT with a Commons Clause, with no per-task or per-execution pricing.
Self-hosted
Runs on your own infrastructure with Docker, so your data and credentials stay yours.
One-paste import
Copy a template JSON, paste it onto the canvas, and run it in minutes.
Agentic by default
Agent nodes, MCP tools, and built-in RAG on a visual workflow canvas.
Data & Analytics templates FAQ
How do I automate spreadsheet enrichment?
The Google Sheets AI Enricher template reads new rows, classifies or enriches each one with an LLM, and writes the result back to the sheet, so your data updates itself on a schedule.
Can an agent query my database?
Yes. The Slack + Postgres MCP Answer Agent lets an agent run read queries against Postgres through MCP and post the answer back to a channel, with no manual SQL needed from the asker.
Can I customize a template after importing it?
Every node, prompt, credential, and connection is editable after import. Swap the model, change the trigger, add or remove tools, and rewire branches directly on the canvas without writing boilerplate.
Is Heym free and self-hosted?
Yes. Heym is source-available under an MIT license with a Commons Clause, so you can run every template on your own infrastructure with Docker. There is no per-task or per-execution pricing, and your data and credentials stay inside your environment.
What makes these different from ordinary automation templates?
Each one runs on an AI-native canvas, so agent nodes, MCP tools, and built-in RAG sit in the same workflow as the triggers, branching, and integrations. That is the difference between a fixed sequence of steps and an agentic workflow that can retrieve context, call tools, and pause for human review while it runs.
Related guides
Explore other use cases
Marketing & SEO
23Content repurposing, social publishing, SEO research, analytics reporting, and audience monitoring for growth teams.
Sales & CRM
17Lead qualification, CRM enrichment, personalized outreach, follow-up workflows, and revenue handoffs.
Customer Support
24Email triage, FAQ replies, human approval checkpoints, inbox summaries, and customer escalation routing.
Legal & Compliance
22Governed research, review checkpoints, policy-sensitive document handling, and audit-friendly agent workflows.
HR & Recruiting
12Candidate search, resume-style ranking, recruiting summaries, interview preparation, and hiring pipeline automation.
Finance Ops
15Invoice extraction, payment webhooks, receipt creation, pricing monitors, and finance data handoffs.
Document Ops
34RAG ingestion, document Q&A, PDF and DOCX workflows, translation, file sharing, and structured extraction.
Dev & IT Ops
39Release monitoring, Sentry issue triage, API reliability, code review, WebSocket alerts, RabbitMQ jobs, and internal tool workflows.
App Integrations
52Connect Slack, Discord, Telegram, HTTP APIs, MCP tools, and external systems with reusable workflow patterns.
Personal Productivity
22Personal assistants, briefing emails, meeting summaries, lightweight research, reminders, and daily automation.
Education & Learning
12Language learning, study guides, lesson planning, assessment feedback, research workflows, and LMS operations.
Healthcare
10Clinical-style triage examples, structured health summaries, specialist review patterns, and careful human oversight.
AI Agents
90General LLM and agent workflows for classification, generation, evaluation, image creation, and text-to-workflow examples.
Agent Teams
15Orchestrator, researcher, writer, validator, and specialist agent patterns for multi-step AI work.
Operations Automation
64Scheduled checks, debounce steps, generic routers, async dispatchers, and repeatable business operations.
Agent Skills
12Agent templates with bundled skills, custom tools, Python actions, and repeatable expert workflows.