Monthly macro economic memo, auto-published to Notion

PromptCreate

Build me an agent workflow that produces a monthly one-page US macro memo and publishes it to Notion. Trigger: cron, fires at 7:00 AM America/New_York on the first business day of each month (skip Saturday, Sunday, and US federal holidays).

Integrations: FRED (St. Louis Fed), Perplexity AI, Notion. The Notion database ID where memos should be filed is a workflow input the user provides at setup.

Step 1: Pull the latest observation and the prior-12-month window for the following FRED series using Get Series Observations (series IDs are canonical, case-sensitive). Activity: INDPRO, GDPC1. Labor: PAYEMS, UNRATE, ICSA, AHETPI. Inflation: CPIAUCSL, PCEPI, CPILFESL. Consumer: RSAFS, UMCSENT. Housing: HOUST, MORTGAGE30US, CSUSHPISA. Rates: DFF, DGS10, T10Y2Y. For each series compute the latest value, the month-over-month change, and the year-over-year change. Use the series' native frequency (do not force aggregation). Coerce missing values (FRED returns the literal string ".") before math.

Step 2: Call Perplexity AI Create Chat Completion with a sonar-pro model to gather the prevailing macro narrative. Ask for: (a) the most recent FOMC statement language and any change vs the prior statement, (b) the current consensus rate path implied by fed funds futures, (c) two to four notable pieces of analyst or strategist commentary from the past month. Require citations. Constrain the search to roughly the last 35 days.

Step 3: Draft the memo. Open with a 2-3 sentence lead paragraph that highlights the two or three most notable indicator moves this month (largest surprises vs trend). Then six sections with short prose plus the relevant indicator readings: Activity, Labor, Inflation, Consumer, Housing, Outlook. Outlook weaves in the Perplexity narrative (Fed, rate path, analyst views). Finish with a Sources section listing the Perplexity citations as links.

Step 4: Publish via Notion Create a Page as a child of the provided database. Page title format: "Macro Memo — {Month YYYY}" (e.g. "Macro Memo — July 2026"). Set a Date property to the run date if the database has one; otherwise just create the page. The memo body should be rendered as Notion blocks (heading_2 per section, paragraph for prose, a simple bulleted_list_item per indicator reading, and a bookmark or paragraph with link for each source). Keep it to roughly one page when read in Notion.

Tone: concise, analyst-grade, no hype, no emojis. Numbers carry units (%, k, bps). Do not invent figures or citations: every number must come from the FRED pull, every claim in Outlook must trace to a Perplexity citation.

What does this prompt do?

Pulls the latest readings for the 17 indicators most analysts watch (growth, jobs, inflation, consumer, housing, rates) and computes month-over-month and year-over-year changes.
Gathers the current macro narrative from the web, including recent Fed language, consensus rate path, and notable analyst commentary, with sources cited.
Drafts a structured memo with sections for Activity, Labor, Inflation, Consumer, Housing, and Outlook, leading with the two or three biggest changes.
Publishes the finished memo as a dated child page in your Notion macro database, with citations linked at the bottom.

What do I need to use this?

A FRED account (free) for the economic data.
A Perplexity AI account for the narrative research.
A Notion workspace with a database where the memos should be filed, shared with your Notion connection.

How can I customize it?

Swap the indicator list to match your coverage. Add commodity prices, FX, credit spreads, or sector specifics, or drop ones you do not track.
Change the schedule, the audience, or the tone. Monthly is the default but quarterly or post-FOMC also work.
Reshape the memo. Add a one-line CIO summary at the top, a watchlist for next month, or a chart links section.

FAQs

Where does the economic data come from?

From FRED, the Federal Reserve Bank of St. Louis economic database. It is the canonical source for US series like GDP, payrolls, CPI, and Treasury yields, and the data is free.

How does it know what the market is thinking?

It asks Perplexity AI to summarize the most recent Fed statement, the consensus rate path, and analyst commentary from the past month, with citations linked at the bottom of the memo.

Where does the memo end up?

As a new dated child page inside the Notion database you point it at. Share that database with your Notion connection once and every new memo will land there automatically.

Can I add or remove indicators?

Yes. Tell the workflow which series to track and it will adjust the data pull and the section it lives in. You can also reorder the sections or add new ones.

What if I want it weekly instead of monthly?

Change the schedule when you set it up. The same workflow runs at any cadence, and you can have it run right after a specific data release if you prefer.

Related templates

Screen chartered vessels for AIS gaps and sanctions red flags

Every six hours we check each ship on your watchlist for unexplained tracking gaps and off-port transfers, then log real findings and alert your team.

Agentic Task

Compare candidate store locations with drive time trade areas

Open one place to see every candidate site mapped with 5, 10 and 15 minute drive time areas, competitor counts, and a site brief you can defend.

App

Browse every competitor ad and build a Notion swipe file

See what your competitors are running on Google, Meta and LinkedIn in one screen, save the best ads to a shared Notion swipe file, and get a teardown on demand.

+1

App

Audience persona studio for brand and product marketers

Pick a brand, competitor, category or hashtag and get persona cards from real social conversation, saved each quarter so you can track how your audience shifts.