Research & Knowledge
Summarize a YouTuber's latest video into a Google Doc daily
A Make scenario runs at 9 AM, finds a YouTuber's newest video, has Hugging Face summarize it, and appends the summary to a Google Doc.
Make
Build data analysis reports and dashboards with a coding agent
A toolkit gives a coding agent a semantic layer and dashboard files so it can query data warehouses and publish in-depth reports and visualizations.
Time saved
Not reported
Setup time
Not reported
Running cost
Not reported
Cost range
Not reported
Use case overview
A toolkit gives a coding agent a semantic layer and dashboard files so it can query data warehouses and publish in-depth reports and visualizations.
Reported experience
What they did
Graphene is an npm CLI that you add to a project, either standalone or inside a repo such as dbt. You define semantic models in .gsql files and pages in markdown files. You start the dev server and prompt your coding agent to answer a question, build a dashboard, or edit the model. The agent writes GSQL queries and chart components, and the CLI checks syntax, renders pages, and prints screenshots so it can iterate.
How it went
The source gives no measured results. It claims analysis runs 10x faster and that pages look consistent by default, and it lists Snowflake, BigQuery, ClickHouse, Postgres, MotherDuck and DuckDB as supported sources.
Worth knowing
The Elastic License 2.0 allows free internal use only. Building a commercial product on it needs a separate agreement, and using it without Graphene Cloud requires git and a coding agent.
Example prompts
Help me build a data analysis report from [my data warehouse or data files, e.g. a Postgres database or a folder of CSVs]. First define a simple semantic layer in files, with the key tables, metrics and joins for [my business area]. Then query the data, answer [my main question], and publish a dashboard or report with charts as files in this folder. Stop when I can open the report and each chart lists the query behind it, and ask me before running anything that writes to the database.
Related use cases
Research & Knowledge
Mine Reddit threads into structured Notion reports
An n8n workflow scrapes Reddit posts and comments via Bright Data, extracts concerns and themes with Gemini, and writes reports to Notion.
n8n · Gemini
Content & Creative
Turn AI newsletters into a daily podcast
An agent runs overnight, collects the author's AI newsletter subscriptions and produces a daily podcast to listen to on walks.
Other or custom